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

VEowL0w0YjgydE50OVJjQzJZbExJTloxS2c9PQ==
  • DMS Vision Inc
  • Wyoming, MI

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

American Driver

CDL A Regional & Entry Level Drivers - Home Weekly - Up to $1500 Wk Job at American Driver

 ...excellent benefits? Whether you're an experienced driver or a recent CDL-A graduate, we have regional opportunities for you. Job...  ...: Travel and hotel covered. Entry-Level CDL A Driver Training: Pay: Earn $650 per week during 46 weeks of OTR training... 

Above Roofing Inc.

Gutter Installer (Full-time) Job at Above Roofing Inc.

 ...perspectives and contributions of people from all age groups and backgrounds, including younger generations. We are looking for a Gutter Installer with ideally 3 years of experience in gutter installation. This person should be skilled in gutter work, comfortable leading... 

Ocean Freight Lines Inc

Owner Operator Truck Drivers - Dry Van & Flatbed Job at Ocean Freight Lines Inc

 ...Join Our Team & Keep Your Business Rolling! Ocean Freight Lines Inc is seeking experienced Owner Operator Truck Drivers to partner with us for consistent freight, top-tier support, and unmatched earning potential. If you own your truck and thrive on the open road, we... 

Vanguard-IP

IP Litigation/Life Sciences Associate VIP-19954 Job at Vanguard-IP

REQUIREMENTS Qualified applicants must have prior work experience in a biotechnology practice, along with a degree in a life sciences technology area (biochemistry, biology, chemistry, biomedical science, chemical engineering, molecular biology, pharmacy, or the like... 

Amtrak

Train Attendant - Los Angeles, CA Job at Amtrak

 ...Your success is a train ride away! As we move Americas workforce toward the future, Amtrak connects businesses and communities across...  ...journey to our coach and sleeping car passengers. The Train Attendant can work either coach or sleeping cars. Coach Attendants will...