Job description

The position is located Manhattan , New York. The position is a hybrid which means 3 days working on site in Manhattan , New York. Require on site interview in Manhattan , New York. Hourly rate 110.00 with benefits Corp. to Corp. rate 120.00 Solution Architect - Data Warehouses & Data Engineering The Solution Architect will work in close partnership with both technical and business stakeholders, providing expert guidance, oversight, and validation for all client-led data architecture work. This role requires advanced expertise in Microsoft modern data warehousing technologies to drive scalable, enterprise-grade data solutions. Key Responsibilities Architectural Oversight • Lead and oversee comprehensive data architecture including data models, data pipelines, ETL/ELT processes, and integration strategies. • Design and implement solutions leveraging Microsoft Fabric capabilities including OneLake, Data Factory, Synapse Data Engineering, Synapse Data Warehouse, Synapse Data Science, SQL Server, and Power BI. • Ensure solutions are robust, scalable, and maintainable, supporting both current reporting needs and future analytics requirements. • Architect data warehouse patterns and standards. Requirements Translation • Collaborate with business analysts and stakeholders to translate business, compliance, and reporting requirements into scalable technical architectures and data models. • Design solutions that align with business objectives and regulatory requirements. • Create comprehensive data flow diagrams and architectural blueprints. Technical Validation • Provide expert review and validation of architectural decisions, data models, and implementation approaches proposed by client teams. • Advise on best practices for data lineage, historical tracking, schema versioning, and data quality. • Validate performance optimization strategies and cost management approaches for the solution. • Review and approve data governance policies and security implementations. Governance and Standards • Define and enforce architectural standards, data governance frameworks, and security models. • Establish documentation practices and maintain architectural decision records. • Ensure consistency and compliance across all data solutions. Collaboration • Facilitate collaboration between business and technical teams across the implementation lifecycle. • Lead technical design sessions and architectural review meetings. • Provide guidance on modern data engineering practices. Risk Management • Identify architectural risks and propose mitigation strategies, particularly in areas such as data integration, scalability, performance, and compliance. • Assess security implications and implement appropriate data protection measures within Fabric. Solution Roadmapping • Contribute to the development of phased roadmaps and architectural blueprints. • Ensure alignment with broader organizational initiatives and enable iterative delivery of business value. • Design future-state architectures that leverage emerging capabilities. Required Qualifications Technical Skills • Microsoft Data Products Expertise: 2+ years hands-on experience with SQL Server and Microsoft Fabric, including Data Factory, Synapse Analytics, OneLake, and Power BI integration. • Data Architecture: 7+ years experience in enterprise data architecture, data warehousing, and analytics solutions. • Cloud Platforms: Expert-level knowledge of Microsoft Azure services, particularly those integrated with Fabric. • Data Engineering: Proficiency in modern data engineering tools, ETL/ELT processes, and real-time data processing. • Programming: Strong skills in SQL, Python, PySpark, and familiarity with the .NET ecosystem. • Data Modeling: Advanced knowledge of dimensional modeling, data vault, and modern data modeling techniques. Business Skills • Proven ability to translate complex business requirements into technical solutions. • Experience with data governance, data quality, and compliance frameworks. • Strong project management and stakeholder communication skills. • Experience working in agile/iterative delivery environments. Certifications (Preferred) • Microsoft Certified: Azure Solutions Architect Expert • Microsoft Certified: Azure Data Engineer Associate • Microsoft Certified: Fabric Analytics Engineer Associate • Additional relevant Microsoft Azure and data platform certifications Experience Requirements • Bachelor's degree in Computer Science, Information Systems, or related technical field. • 8+ years of experience in enterprise data architecture and solution design. • 5+ years of experience with cloud-based data platforms and modern analytics solutions. • 2+ years of hands-on experience with Microsoft Fabric or equivalent unified analytics platforms. • Experience in regulated industries or environments with strict compliance requirements. • Proven track record of successfully delivering large-scale data transformation projects. Engagement Level • Ongoing: Bi-weekly/monthly oversight and architectural reviews. • Project-based: Intensive engagement during critical design and implementation phases. • On-demand: Available for escalated technical decisions and architectural consultations.

Requirements