Job Description :

Hi,

Hope all is well,

Please revert me with an updated resume if you would like to apply for this role,

Solution Architect/ Data Warehouse Experience (3days/week onsite) || Manhattan , New York || Local Only

Duration : 6+ Months

Location : Manhattan , New York

NEED LOCAL CANDIDATES ONLY

About

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.

Thank you

, 110

             

Similar Jobs you may be interested in ..