Reporting Specialist

Who we are?

The Primary Construction Team consists of ACCIONA Infrastructure Canada Inc. (ACCIONA) and Amico Major Projects Inc. (Amico), as Trillium Guideway Partners (TGP).

The Ontario Line ("OL") is a fully integrated, stand‑alone, rapid transit system that connects Ontario Science Centre to the Exhibition and Ontario Place grounds. The Northern Civil, Stations and Tunnel ("NC") project consists of approximately 7 km of underground subway and elevated guideway, with stations along the segment providing connections to surface bus and streetcar routes. The NC project has been divided into two main progressive design‑build contracts: the Elevated Guideways and Stations Contract ("EGS") and the Pape Tunnel and Underground Station Contract ("PTUS"), with supporting Early Works.

The Reporting Specialist will be responsible for developing, maintaining, and enhancing Power BI dashboards; establishing data dictionaries and KPI logs to improve data accuracy; and delivering reliable insights for informed decision‑making.

• Develop, maintain, and enhance Power BI dashboards and reports
• Ensure data quality, consistency, and integrity across reporting solutions
• Prepare monthly and weekly report submissions in accordance with project requirements
• Lead and coordinate the reporting team to meet the requirements of project stakeholders and discipline teams

• 3–5 years of experience in Power BI dashboard development and data modeling
• Robust skills in Power BI (DAX, Power Query) and building reliable reports
• Experience with data dictionaries, KPI tracking, and data validation
• Proficiency in Python (Pandas, Num Py, PySpark)
• Experience integrating data from SharePoint, Excel, and SQL
• Proficiency in EVM and project controls concepts
• Ability to provide leadership, guidance, and management support to team members

We are committed to creating an accessible and barrier‑free recruitment process and workplace.