Solution Architect/ Data Warehouse (3days/week onsite) || Manhattan , New York || Local Only Job at DMS Vision Inc, California

VHhkZUZIYlJaZWE3LzQ3anZUaVR6SHovV0E9PQ==
  • DMS Vision Inc
  • California

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

Akhilesh@dmsvisions.com

972-645-0322, 110

Job Tags

Local area,

Similar Jobs

Tesla

Internship, Data Engineer, Cell Engineering (Fall 2025) Job at Tesla

 ...weeks, full-time and on-site, for most internships. Our internship program is for students...  ...interpretation of battery tests and image data. Your work may include developing software...  ...Currently pursuing a degree in Computer Science, Data Science or a related field... 

Uber

AV Data Strategy Analyst Job at Uber

**About the Role**Uber's Data Infrastructure and Strategy (DI&S) team, part of the customer support branch known as Community Operation...  ...in a business analyst, data analyst, or similar role (internships, academic projects, or bootcamps welcome)+ 2+ years of hands on... 

Domino's Franchise

Delivery Driver - 12330 NC Hwy 210 suite Job at Domino's Franchise

 ...environment with a team focus on customer service Duties include delivery, learning to take phone orders and assistance with cleaning Advancement within the company to other positions if desired Cash tips paid daily with hourly averages wages at $12 to $14 per hour... 

Filtrex Service Group

Entry Level HVAC/R Tech Job at Filtrex Service Group

 ...Benefits: Dental insurance Health insurance Paid time off Vision insurance Job Description Filtrex Service Group - HVAC/R Maintenance Technician Filtrex is a nationwide company searching for skilled technicians to perform, conduct, and complete... 

Compunnel Inc.

Registered Nurse - Labor and Delivery Job at Compunnel Inc.

 ...Job Summary We are seeking a skilled Registered Nurse specializing in Labor and Delivery to provide exceptional care to patients throughout...  ...in labor and delivery. Experience with EPIC EMR. COVID-19 vaccination. Preferred Qualifications ~ Bachelor of Science...