Senior Data Engineer - MS Fabric Administrator

The Senior Data Engineer – MS Fabric Administrator is the primary technical owner of OTG's Microsoft Fabric platform and Power BI ecosystem. This role covers end-to-end platform administration, data engineering (pipelines, notebooks, Spark, Dataflows), and advanced Power BI development — all in support of one of Canada's largest transit infrastructure projects, the Ontario Line.
The ideal candidate combines deep hands-on Fabric experience with strong Power BI skills and a genuine interest in driving AI-augmented workflows across the team. They are self-directed, documentation-focused, and comfortable operating in a fast-paced, cross-functional environment.

Key Responsibilities:

MS Fabric Administration & Data Engineering

• Administer the Fabric tenant: workspaces, capacity, security, governance, and tenant settings.
• Design and maintain Lakehouse architecture using the Bronze / Silver / Gold medallion storage pattern.
• Build and maintain data pipelines for ingestion, transformation, and orchestration across Fabric.
• Develop Python and PySpark notebooks for data processing and automation.
• Configure and manage Dataflows Gen2 using M Code and Power Query transformations.
• Implement API connections, User Data Functions, and Spark Jobs for custom data access.

Power BI Development

• Design and maintain advanced semantic models using DAX, parameters, and TMDL.
• Build polished, user-friendly reports applying UI/UX best practices and accessibility standards.
• Manage deployment pipelines, dataset lineage, and workspace governance across the tenant.
• Maintain model documentation and support self-service analytics across project teams.
  

AI Integration & Enablement

• Lead adoption of Fabric Copilot, Data Agents, and AI Functions in notebooks.
• Integrate AI tooling with the Fabric platform via MCP Servers (Power BI MCP, Fabric MCP).
• Champion the use of Claude Cowork and Cursor for AI-assisted development and automation.
• Document patterns and support team upskilling on AI-augmented workflows.

Qualifications:

• Bachelor's in Computer Science, Data Engineering, Information Systems, or a related field.
• Master's degree or post-grad specialization in Data Engineering / Cloud Computing is an asset.
  
• Microsoft Fabric Analytics Engineer Associate (DP-600) — certified or actively in progress.
• 4–6 years of experience in data engineering, BI development, or a related function.
  
• Demonstrated hands-on experience administering Microsoft Fabric or an equivalent platform (Azure Synapse, Databricks).
• Proven track record delivering production-grade data pipelines and Power BI semantic models.
• Experience in large infrastructure, construction, or transit project environments is an asset.
  
• PL-300 (Power BI Data Analyst), DP-203 (Azure Data Engineer), or other MS certifications would be an asset.
• Strong analytical mindset with the ability to architect scalable, maintainable data solutions.
• Clear communicator — able to translate complex technical concepts for non-technical stakeholders.
• Comfortable with DevOps and CI/CD practices for data (git-based TMDL deployments).

• Team leadership or mentoring experience is an asset.