Senior Data Warehouse Architect – Microsoft Fabric

Loyal Source Government Services; Orlando (FL); On-site; USD 117,000 - 143,000; Full time

Job summary

Loyal Source Government Services seeks a Data Warehouse Architect to design and govern the enterprise data warehouse architecture in Microsoft Fabric, enabling metadata-driven, layered data products from Bronze to Gold for analytics and Power BI consumption.

The architect will establish scalable ingestion, transformation, modeling, orchestration, security, data quality, lineage, and operational support patterns and collaborate with data engineering, BI, security, and business stakeholders,

Qualifications

• Bachelor's degree in a technical field or equivalent experience.
• 7+ years of progressive data architecture/BI experience.
• Strong Microsoft Fabric and SQL-based data warehouse design.

Responsibilities

• Architect the Fabric data warehouse and lakehouse environment (workspace, capacity, data domains, medallion layers).
• Design enterprise data models (dimensional modeling, conformed dimensions, facts).
• Define Bronze/Silver/Gold architecture and data governance standards.
• Guide metadata-driven ingestion/transformation using Fabric tools.
• Collaborate with Power BI developers for performant analytics.
• Own source-to-target architecture, data dictionaries, and design docs.

Skills

Microsoft Fabric

SQL

Data Modeling

Azure DevOps

Power BI

Data Governance

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field

Tools

OneLake

Lakehouse

Data Factory

Notebooks

Git

CI/CD

Job description

Loyal Source Government Services seeks a Data Warehouse Architect to design and govern the enterprise data warehouse architecture in Microsoft Fabric, enabling metadata-driven, layered data products from Bronze to Gold for analytics and Power BI consumption.

The architect will establish scalable ingestion, transformation, modeling, orchestration, security, data quality, lineage, and operational support patterns and collaborate with data engineering, BI, security, and business stakeholders,