Microsoft Fabric Technical Architect

Tavant; Denver (CO); On-site; USD 180,000 - 240,000; Full time

Job summary

Tavant is seeking a Microsoft Fabric Technical Architect to lead the architecture, design, and implementation of modern data platform solutions on Microsoft Fabric. You will drive data ingestion, transformation, and orchestration with a focus on scalable lakehouse/warehouse design and CI/CD practices.

The role requires deep data engineering expertise, strong SQL, PySpark, and hands-on experience with Fabric or Azure Data Factory pipelines, plus experience delivering production-grade data

Qualifications

• 12+ years in data engineering / data platform roles.
• 2+ years architecting and implementing on Microsoft Fabric.
• Strong SQL skills including performance tuning and analytics-ready modeling.
• Hands-on with Azure Data Factory or Fabric pipelines.
• PySpark development for scalable transformations.
• Experience implementing CI/CD for data workloads.
• Solid data engineering fundamentals (ingestion, transformations, modeling, orchestration).
• Knowledge of Medallion/Data Vault architectures.
• Semantic layer creation and DAX basics are advantageous.
• Capacity planning and workload optimization.

Responsibilities

• Lead architecture, design, and implementation of modern data platform solutions on Microsoft Fabric.
• Drive end-to-end data ingestion, transformation, and orchestration patterns.
• Collaborate with stakeholders to translate business needs into scalable technical solutions.

Skills

12+ years data engineering

2+ years Microsoft Fabric

SQL performance tuning

Azure Data Factory / Fabric pipelines

PySpark development

CI/CD for data workloads

Data engineering fundamentals

Medallion architecture / Data Vault

Semantic layer & DAX

Capacity planning & workload opt.

Tools

Azure DevOps

GitHub Actions

Job description

We are looking for a Microsoft Fabric Technical Architect to lead the architecture, design, and implementation of modern data platform solutions on Microsoft Fabric. The role requires strong technical depth across data engineering, orchestration, scalable lakehouse/warehouse design, and CI/CD practices.

Must-Have Skills & Qualifications:

• 12+ years overall experience in data engineering / data platform roles.
• 2+ years of hands‑on experience architecting and implementing on Microsoft Fabric.
• Strong proficiency in SQL (performance tuning, complex transformations, analytics‑ready modeling).
• Hands‑on expertise with Azure Data Factory (or Fabric pipelines), including orchestration patterns and parameterized pipelines.
• Strong hands‑on development in PySpark for scalable transformation workflows.
• Experience implementing CI/CD for data workloads (Azure DevOps/GitHub, automated deployments, environment management).
• Strong understanding of data engineering fundamentals (ingestion, transformations, modeling, orchestration, testing).
• Strong knowledge of modern data architectures such as Medallion (Bronze/Silver/Gold), Data Vault, and related patterns.
• Hands‑on knowledge with semantic layer creation, report creation and DAX functions (this is listed in good‑to‑have. Should be moved to must‑have)
• Capacity planning and Workload optimization

Good‑to‑Have Skills:

• Experience with Snowflake (architecture, migration, performance).
• Experience with Microsoft Purview for cataloging, lineage, and governance.
• Strong understanding of data governance, security, and lineage within the Microsoft ecosystem (access controls, auditing, compliance).
• Exposure to Power BI and Semantic Models (DAX/modeling is a plus).
• Fabric certifications DP-600 and DP-700
• Purview and Fabric integration

Soft Skills:

• Strong stakeholder management and communication skills.
• Ability to translate business needs into scalable technical architecture.
• Ownership mindset with the ability to lead delivery and drive outcomes