Duration: 6 Month contract to start, no end date & 2-year max rule. Can be there theoretically forever if you are good. Location: Mississauga, ON- 3 days on site Interviews: 2 rounds

Introduction The purpose of this document is to define two Power BI roles within Advanced Analytics team: a Lead Power BI Developer and a Power BI Developer. Both roles support the business-facing reporting layer between Microsoft Fabric data products and operational and leadership users. Both roles require strong Power BI and Microsoft Fabric experience. Both must also be comfortable picking up ad-hoc requests and turning them around quickly without compromising accuracy.

Position Details: Roles: Lead Power BI Developer; Power BI Developer Function: Advanced Analytics / Airport AI Reports to: Manager, Advanced Analytics Platform: Microsoft Fabric on Azure (Power BI, OneLake, Lakehouse/Warehouse, Direct Lake) *****Common requirement: Strong Power BI and Fabric experience; comfortable with ad-hoc requests

Power BI Developer The Power BI Developer builds and maintains trusted reports and supporting models for airport operations under the lead's standards. This person is detail-oriented, comfortable taking clear direction, and comfortable picking up ad-hoc requests and turning them around. Strong Power BI and Fabric experience is required.

What You Will Own Report development Build clear, accurate operational and business reports on shared semantic models. Measure development Write and maintain DAX measures consistent with agreed definitions. Validation Reconcile report outputs to source/curated data before business review. Fabric consumption Consume governed Fabric tables and views with correct grain and refresh behavior. Ad-hoc requests Pick up and deliver ad-hoc data and reporting asks reliably and on time.

Key Responsibilities Build and maintain Power BI reports and supporting model logic to the team standard. Write DAX measures that match agreed metric definitions. Validate report numbers against Fabric and source data, not only visual inspection. Pick up ad-hoc and exploratory requests and deliver them quickly and accurately. Document measures, assumptions, and refresh/support steps. Support refresh, UAT, and business questions with evidence. Escalate definition or data-quality gaps rather than hiding them in report logic.

Required Experience Three or more years in Power BI report and model development. Solid DAX and data modelling, including grain and filter context. Practical Microsoft Fabric experience (Lakehouse/Warehouse, OneLake, refresh). Working SQL — able to validate report numbers against source tables. Detail-oriented, organized, and comfortable taking clear direction. Comfortable handling ad-hoc requests under changing priorities.

Preferred Experience Power BI Service refresh, workspaces, and basic row-level security. Power Query / Dataflows and an understanding of when logic belongs upstream. Operational or time-series reporting, such as interval-based capacity or demand data. Exposure to deployment pipelines or version-controlled BI assets.

Shared Expectations and Success Measures The following expectations apply to both roles. Power BI + Fabric: Strong Power BI and practical Microsoft Fabric experience are required for both roles. Trusted numbers: Reports reconcile to source; definitions are documented; freshness and limitations are visible. Ad-hoc readiness: Both roles are comfortable picking up ad-hoc requests and delivering quickly without sacrificing accuracy. Supportability: BI assets are documented and supportable by more than one person. Communication: Discrepancies and limitations are explained clearly to non-technical stakeholders.

Success Measures Shared semantic models and documented measures are trusted across reports and teams. Report numbers reconcile to Fabric and source data with repeatable evidence. Ad-hoc requests are turned around quickly and accurately. BI ownership is not dependent on any single individual. Operational and leadership users understand data freshness, assumptions, and limitations.