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