Senior Microsoft Fabric Architect / Data Warehouse Architect (Lead)

Job Description On behalf of our public sector client, Affinity is seeking a Senior Microsoft Fabric Architect / Data Warehouse Architect (Lead) to architect, design, and build a centralized enterprise data warehouse on Microsoft Fabric from scratch, implementing CI/CD, environment promotion, capacity management, monitoring, and governance. They will deliver end-to-end enterprise Fabric production capabilities in support of data modernization and analytics initiatives. They will work closely with internal engineers, stakeholders, and nearshore resources to ensure successful technical delivery, operational readiness, and knowledge transfer. Responsibilities Architect, design and build a centralized enterprise data warehouse on Microsoft Fabric from scratch (implement Bronze / Silver / Gold layers). Create Fabric workspaces and capacity configuration; design capacity allocation and implement monitoring and alerting for spiking/consumption. Implement CI/CD for Fabric artifacts (notebooks, pipelines, semantic models, datasets, reports) and deployment promotion (Dev → Test → Prod). Build semantic models (Power BI / Fabric semantic layer) and govern semantic layer design/performance. Integrate Fabric with existing systems (Azure, Databricks, Synapse, CRM/GMS interfaces) and create batch/sync processes where required. Produce documentation, deployment runbooks, operational playbooks, and knowledge transfer to internal staff and nearshore resources. Mentor/lead internal engineers; act as single point of contact for technical delivery and risk mitigation. Qualifications Hands-on, recent, demonstrable Microsoft Fabric architect experience (production deployments). Proven enterprise data warehouse design using Bronze/Silver/Gold patterns on Fabric or equivalent. CI/CD experience for Fabric/Power BI artifacts; ability to design automated promotion processes across environments. Experience with Fabric capacity planning, monitoring, cost control, and performance tuning. Strong Azure data platform skills (ADF, Synapse, Databricks familiarity desirable). Experience migrating or modernizing Synapse/Databricks → Fabric strongly preferred. Excellent stakeholder communication and leadership; track record of delivering low-risk production solutions. Prior client engagements focused on Microsoft product stacks (Power Platform, Azure). Experience coordinating with nearshore/offshore teams and establishing overlapping work windows. Familiarity with grants management or financial systems integration (bonus for MyTax Plus/finance context). Senior architect / lead (5–10+ years, with specific recent Fabric experience). Client requires a “no-risk” hire — prefer candidates with proven track records as architects on Fabric or Synapse→Fabric migrations. Able to consult on architecture decisions and be hands-on implementing key components. Available to start interviews within 1–2 weeks; reasonably available to start work within ~2–3 weeks after offer. Affinity Earn Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/ About Affinity Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need. For more information on Affinity, please visit www.affinity-group.ca Job Number: 13867

Architect and build a centralized enterprise data warehouse on Microsoft Fabric from scratch, including the implementation of Bronze, Silver, and Gold layers. Establish CI/CD pipelines, capacity management, and governance while mentoring internal engineers and coordinating with nearshore resources.

Requires extensive hands-on experience with Microsoft Fabric production deployments and enterprise data warehouse design. Candidates must have strong Azure data platform skills and a proven track record of leading migrations from Synapse or Databricks to Fabric.

• Power BIPreferred
• CI/CDPreferred

Identified from the job description. Confirm important requirements above.

• Microsoft Fabric
• Data Warehouse Architecture
• CI/CD
• Power BI
• Azure Data Factory
• Azure Synapse
• Azure Databricks
• Capacity Management
• Semantic Modeling
• Data Modernization
• Governance
• Bronze Silver Gold Architecture
• Stakeholder Communication
• Technical Leadership
• ETL Pipelines
• Performance Tuning

• Data & Analytics
• Technology
• Consulting
• Government & Public Sector
• Software

Minimum experience

5+ years

Apply by

Sep 23, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Mid-Senior level