Data Analytics Manager

PACT (Pearson Accelerator Construction Team) is a General Partnership of Alberici, Amico, Kenaidan, and Obayashi, supported by design partners Egis, Mott MacDonald, and Weston Williamson + Partners. Together, we are delivering Accelerator, a major program of Pearson LIFT (Long-term Investment in Facilities and Terminals), Toronto Pearson's infrastructure development plan. This multi-year program is designed to address immediate passenger growth demands while preparing Canada’s largest airport for the future of air travel—including critical upgrades to airfield and infrastructure, greenhouse gas reduction initiatives, modernization of Terminals 1 and 3, and the creation of a world-class passenger experience.

JOB SUMMARY

The Data Analytics Manager will lead the development and management of PACT’s data and business intelligence environment, ensuring project data is securely integrated, structured, and transformed into accurate, decision-ready reporting. This role will oversee Microsoft Fabric and Power BI, build scalable data pipelines across multiple systems, and deliver dashboards and automated reporting that support project teams, client reporting requirements, and executive decision-making. The role will also act as a key link between technical teams and project stakeholders, helping ensure data is trusted, clearly understood, and effectively used across the program.

RESPONSIBILITIES

Data Engineering & Architecture Scope

Infrastructure, Pipeline Management, and Platform Administration

• Managing the entire Microsoft Fabric data engineering platform to ensure robust capacity, performance, and security. Optimizing Microsoft Fabric capacity and managing Power BI licensing to ensure cost-effectiveness.
• Implementing a structured Bronze‑Silver‑Gold pipeline to systematically refine raw project data into high value, decision ready assets.
• Bronze Layer (Raw Archive): Building pipelines to ingest and archive raw data from sources like Autodesk Construction Cloud, creating a permanent, auditable record for forensic analysis.
• Silver Layer (Integration): Developing transformation logic to clean, standardize, and link disparate systems to create a unified operational view.
• Gold Layer (Business Intelligence): Aggregating data into optimized, business-ready datasets to serve as the high-speed foundation for reporting.
• Constructing pipelines that pull data from various systems (including BambooHR, and Autodesk Construction Cloud) into one central, secure location.
• Ensuring the environment allows for secure report sharing and collaboration while isolating project data.
• Acting as the gatekeeper for data quality to ensure that all teams are making decisions based on the same verified, trustworthy numbers.

BI Development & Visualization Scope

Dashboard Design, Automation

• Designing user friendly and interactive Power BI dashboards that allow a user to understand the project status instantly.
• Creating specific dashboards tailored to meet client monthly reporting obligations, including the automation of contractual reports (Schedule J and Schedule B).
• Managing the automated refresh schedules of all dashboards to ensure leadership has access to real-time data without manual intervention.

Leadership & Soft Skills Scope

Stakeholder Management, Mentorship, and Problem Solving

• Acting as a strategic bridge between technical data teams and construction operations to ensure non-technical stakeholders understand and trust the data.
• Attending meetings with the executive team and stakeholders to gather feedback and fully understand client and teammate requirements.
• Mentoring and guiding other Power BI developers to ensure technical excellence and adherence to data visualization best practices.
• Collaborating with the digital delivery team to develop custom solutions for complex data problems

WORKING CONDITIONS

The position will be based at our office in Mississauga, Ontario, with visits to the Airport site as required. Your work schedule will be Monday to Friday during regular office or site hours. At times, operational needs may require work outside these hours, with reasonable notice provided. All schedule or on‑call adjustments will comply with applicable employment standards legislation. It is mandatory for all employees to complete a Criminal Background check and successfully attain a Restricted Access Identity Card (RAIC) upon joining the company.

DESIRED SKILLS, KNOWLEDGE, COMPETENCIES

• Bachelor’s degree in Data Analytics, Data Science, Computer Science, Information Systems, Engineering, or a related field, or an equivalent combination of education and relevant experience
• Strong experience leading data analytics, business intelligence, or data engineering functions in a complex project or enterprise environment
• Advanced experience with Microsoft Fabric and Power BI, including platform administration, dashboard development, data modelling, automation, and report management
• Strong experience building and managing data pipelines and integrating data from multiple systems into centralized reporting environments
• Experience with layered data architecture (e.g. Bronze‑Silver‑Gold) and a strong understanding of data governance, data quality, and security
• Ability to translate complex data into clear, actionable insights for both technical and non-technical stakeholders
• Strong communication, stakeholder management, leadership, and problem‑solving skills
• Experience mentoring or guiding BI / analytics resources
• Experience in construction, infrastructure, engineering, or large‑scale capital project environments is considered an asset
• Experience with platforms such as Autodesk Construction Cloud and other enterprise systems is considered an asset
• Relevant Microsoft certifications in Fabric, Power BI, or Azure data platforms are considered an asset
• Must be eligible to obtain and maintain RAIC (Restricted Area Identity Card) clearance

Pact is an equal opportunity employer and is committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. We are committed to providing an inclusive and barrier free candidate experience and work environment. If you require accommodation to apply or if selected to participate in an assessment process, please advise Human Resources.