Job Description

Senior Microsoft Fabric & Power BI Architect

1 year initial contract term (with extension options) – Hybrid role.

We are seeking an elite Senior Microsoft Fabric & Power BI Architect to lead a multi-year modernization initiative for a major Housing Division. This is not just a development role; you will be the visionary architecting a high-impact, scalable ecosystem. Your mission will be to unify siloed systems (Excel, SharePoint, the HOME system, Partner Portal, and Find Housing) into a single, seamless, and trusted data journey.

Core Architectural & Delivery Focus

1. Scalable Architecture & Medallion Standards

You will design and manage sustainable data products within Microsoft Fabric, providing skilled guidance on choosing the right tool for each stage of the data lifecycle.

- Ingestion & Transformation: Build robust, automated ETL/ELT processes utilizing Fabric Pipelines and Dataflows.
- Storage Strategy: Deploy a clear Medallion Architecture (Bronze, Silver, Gold) within Fabric Lakehouses and Warehouses to organize organizational data by maturity.
- Semantic Layering: Design highly optimized, report-ready semantic models that drive high-performance Power BI insights.

2. End-to-End Report Development

Bring deep, proven methodologies focused on data accuracy, exceptional User Experience, and optimal performance across two key areas.

- Interactive Dashboards: End-to-end development of dynamic, modern Power BI dashboards.
- Paginated Reports:



Advanced expertise in designing and deploying pixel-perfect reports using SSRS Report Builder for formal corporate reporting.

3. Best Practices, Training & Change Management

Bridge the gap between complex technical deployments and broad business adoption by deploying a versatile training toolkit.

- Advanced Technical Training: For engineering and technical users navigating backend Fabric structures, Notebooks, and data layers.
- Functional Literacy Training: For business stakeholders requiring foundational guidance on interacting with and interpreting reports.

4. Requirements Elicitation & Optimization

- Act as the ultimate translator between business needs and complex data solutions.
- Work closely with non-technical stakeholders to untangle complex workflows, proactively identifying opportunities to streamline, deduplicate, and consolidate overlapping reporting efforts.

Required Qualifications

- 5+ years of expert-level proficiency in Power BI, including complex DAX, Power Query, and Paginated Reports (SSRS).
- 3+ years of heavy, hands-on experience in data modeling and architecture specifically using Microsoft Fabric (Dataflows, Notebooks, Pipelines, Warehouses, and Lakehouses).
- 3+ years designing and implementing certified datasets and strict data governance frameworks.

Education

- Degree in Computer Science, Mathematics, Statistics, or a related quantitative field.

Certifications (Highly Preferred)

- Microsoft Certified: Fabric Data Engineer Associate (DP-700)
- Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)

#J-18808-Ljbffr

📌 Senior Microsoft Fabric & Power BI Architect (Edmonton)
🏢 Trident Staff
📍 Edmonton