Enterprise Data Architect – Microsoft Fabric & SQL Server

AMSYS Innovative Solutions, LLC; Houston (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

AMSYS Innovative Solutions, LLC seeks an experienced Data Architect to lead SQL Server-based data architecture and data warehousing modernization, including Fabric integration and cloud migration planning.

The role focuses on architecture assessment, solution design, and legacy platform rationalization, guiding implementation teams without building pipelines or code.

Qualifications

• 8–10+ years of Data Architecture/Data Warehouse experience.
• Strong SQL Server, enterprise data warehouse, and data mart background.
• Current Microsoft Fabric experience required.
• Experience with OneLake, Lakehouse/Warehouse, and data integration patterns.
• Legacy/on-prem to cloud modernization and migration experience.
• Strong data modeling and enterprise data integration experience.
• Working SQL/T-SQL knowledge for design reviews and troubleshooting.
• Experience producing HLDs, LLDs, and data-flow/architecture diagrams.
• Understanding of data governance, security, MDM, and data quality.

Responsibilities

• Assess existing SQL Server data warehouses, data marts, integrations, and data flows.
• Define current-state and target-state architecture.
• Provide architecture guidance across Microsoft Fabric and SQL Server environments.
• Design solutions using OneLake, Lakehouse, Warehouse, and Fabric integration patterns.
• Support modernization and rationalization of legacy data platforms.
• Develop/review HLDs, LLDs, architecture diagrams, data flows, and integration designs.
• Apply conceptual, logical, physical, and dimensional data modeling.
• Provide guidance around integration, governance, security, data quality, and MDM.
• Troubleshoot architecture/design issues and guide technical teams through implementation.
• Work independently with business and technical stakeholders in a lean environment.

Skills

Data Architecture

Data Warehouse

SQL Server

Data Modeling

T-SQL

HLDs/LLDs

Microsoft Fabric

Data governance

MDM

Security

Data quality

OneLake

Lakehouse

Pattern-based integration

Education

Bachelor's degree in Computer Science

Tools

Microsoft Fabric

OneLake

Lakehouse

SQL Server

Job description

We are looking for an experienced Data Architect with a strong background in SQL Server-based data architecture and data warehousing, along with current Microsoft Fabric experience.

The role will support the modernization of an existing enterprise data environment, including architecture assessment, solution design, legacy platform rationalization, and transition to Fabric.

This is an architecture and design role, not a Data Engineering position. The architect should be technically strong enough to troubleshoot issues and guide implementation teams without being responsible for building production pipelines, notebooks, or code.

Key Responsibilities

• Assess existing SQL Server data warehouses, data marts, integrations, and data flows.
• Define current-state and target-state architecture.
• Provide architecture guidance across Microsoft Fabric and SQL Server environments.
• Design solutions using OneLake, Lakehouse, Warehouse, and Fabric integration patterns.
• Support modernization and rationalization of legacy data platforms.
• Develop/review HLDs, LLDs, architecture diagrams, data flows, and integration designs.
• Apply conceptual, logical, physical, and dimensional data modeling.
• Provide guidance around integration, governance, security, data quality, and MDM.
• Troubleshoot architecture/design issues and guide technical teams through implementation.
• Work independently with business and technical stakeholders in a lean environment.

Required Experience

• 8 10+ years of Data Architecture/Data Warehouse experience.
• Strong SQL Server, enterprise data warehouse, and data mart background.
• Current Microsoft Fabric experience required.
• Experience with OneLake, Lakehouse/Warehouse, and data integration patterns.
• Legacy/on-prem to cloud modernization and migration experience.
• Strong data modeling and enterprise data integration experience.
• Working SQL/T-SQL knowledge for design reviews and troubleshooting.
• Experience producing HLDs, LLDs, and data-flow/architecture diagrams.
• Understanding of data governance, security, MDM, and data quality.

Nice to have

Broader Enterprise Architecture and Azure data platform experience.