BI Analyst

Role Overview

Data Engineering and Pipeline Delivery

• Build and maintain Microsoft Fabric pipelines to standards set by the Manager, Data & Innovation.
• Ingest and archive raw data from Autodesk Construction Cloud, BambooHR, and other source systems into a permanent Bronze layer.
• Transform and link disparate data in the Silver layer and create optimized Gold datasets for reporting.
• Monitor pipeline runs, investigate failures, correct data quality issues, and document lineage and source dependencies.
• Use governed connections, service accounts, and approved secret storage rather than individual credentials.

BI Development and Visualization

• Build interactive Power BI dashboards, semantic models, measures, and KPI definitions.
• Automate client monthly and contractual reporting, including Schedule J and Schedule B.
• Maintain refresh schedules, resolve failures, apply visual standards, and publish through governed workspaces.
• Retire duplicate reports and deliver Power BI, paginated reports, extracts, Power Apps, or direct feeds as appropriate.
• Build integrations to other platforms, including geospatial systems.

Applied AI and Governance

• Prepare governed datasets for Microsoft Copilot and AI agents, including descriptions, relationships, and permission scope.
• Contribute to AI agents that let stakeholders query program data and test generated output against source data.
• Prototype Microsoft Fabric, Power Platform, and AI capabilities as directed.
• Validate published figures, apply workspace and row-level security, and support access review evidence.
• Keep dataset and report documentation current.

Stakeholder Engagement and Support

• Gather reporting requirements from business owners and subject matter experts.
• Demonstrate reports, gather feedback, and agree changes with stakeholders and leadership.
• Explain data and methodology to non-technical audiences and provide dashboard guidance.
• Provide second-line support for report and dashboard issues through the IT helpdesk.
• Coordinate with SharePoint and Azure 365 administrators on data sources, connections, and access.

Working Conditions

• The position is based at the Mississauga, Ontario office, with visits to the Airport site as required.
• The schedule is Monday to Friday during regular office or site hours, with occasional work outside those hours when operationally necessary.
• Employees must complete a criminal background check and attain a Restricted Access Identity Card.

Desired Skills and Qualifications

• Two to four years of hands-on business intelligence or data analyst experience delivering production reporting.
• Power BI, Microsoft Fabric or equivalent platform, SQL, Power Query, DAX, data integration, and data quality experience.
• Post-secondary education in information technology, data analytics, engineering, or a related discipline, or equivalent practical experience.
• Construction, engineering, major capital program, Microsoft certification, Power Platform, AI, GIS, and API experience are assets.

Key Deliverables