Summary
The Data Warehouse Architect is responsible for designing, governing, and evolving the enterprise data warehouse architecture in Microsoft Fabric. This role provides hands-on technical leadership for a metadata-driven, layered data platform spanning Bronze, Silver, and Gold data products and supports analytics and Power BI consumption.
The architect will establish scalable patterns for ingestion, transformation, dimensional modeling, orchestration, deployment, security, data quality, lineage, monitoring, and operational support. The role works closely with data engineering, business intelligence, enterprise applications, infrastructure/security, and business stakeholders and is expected to provide architecture guidance as well as contribute directly to implementation.
Pay: $130,000 / year
Duties and Functions
• Architect the Microsoft Fabric data warehouse and lakehouse environment, including workspace, capacity, data domain, medallion-layer, and data product design patterns.
• Design enterprise data models for analytical workloads, including dimensional/star schemas, conformed dimensions, facts, semantic-ready structures, historical tracking, and appropriate data-grain standards.
• Define and enforce Bronze, Silver, and Gold architecture standards, including naming, lineage, audit fields, batch/run metadata, reconciliation, dependency handling, restartability, exception handling, and retention.
• Design and guide metadata-driven ingestion and transformation frameworks using Fabric Data Factory pipelines, notebooks, SQL, OneLake, Lakehouse, and Warehouse capabilities as appropriate.
• Establish patterns for integrating enterprise systems such as Workday, Salesforce/Bullhorn, operational databases, APIs, flat files, and other internal or external data sources.
• Create architecture standards for data quality, observability, reconciliation, logging, monitoring, alerting, operational support, and production troubleshooting.
• Partner with Power BI developers to ensure warehouse and semantic-layer designs support performant, governed reporting and analytics.
• Own source-to-target architecture, logical and physical data models, interface specifications, data dictionaries, lineage documentation, architecture decision records, and technical design documentation.
• Define security patterns for workspaces, data access, service principals/managed identities where applicable, least-privilege access, and appropriate separation of development, test, and production environments.
• Lead Azure DevOps (ADO) practices for data-platform delivery, including Git repositories, branching strategy, pull requests, work items, backlog traceability, CI/CD pipelines, release controls, and promotion across environments.
• Conduct architecture and code/design reviews, mentor data engineers and BI developers, and help establish reusable development standards and engineering guardrails.
• Evaluate performance, scalability, reliability, and cost considerations and recommend improvements to Fabric workloads and data-platform architecture.
• Collaborate with application owners, security, governance, and business teams to translate data requirements into sustainable enterprise data solutions.
• Support incident root-cause analysis and remediation for complex data warehouse, pipeline, integration, and deployment issues.
Education and Experience
Bachelor's degree in Computer Science, Information Systems, Data Engineering, Engineering, Mathematics, or a related technical field, or equivalent combination of education and relevant experience.
Extensive experience designing and delivering enterprise data warehouses, modern analytics platforms, or lakehouse architectures.
Hands-on experience with Microsoft Fabric and strong SQL-based data warehouse design and development experience.
Experience with enterprise data integration, orchestration, data modeling, data quality, and production support.
Preferred Requirements
• 7+ years of progressive experience in data…