Reporting Specialist

Trillium Guideway Partners; Toronto; On-site; CAD 65,000 - 110,000; Full time

Job summary

Trillium Guideway Partners is seeking a Reporting Specialist to develop, maintain, and enhance Power BI dashboards for the NC project. You will establish data dictionaries and KPI logs to support data accuracy and informed decision‑making.

The role requires 3–5 years of Power BI dashboard development, data modelling, and experience with Python (Pandas, NumPy, PySpark); familiarity with SharePoint, Excel, SQL and EVM concepts; leadership to guide the reporting team.

Qualifications

• 3–5 years of experience in Power BI dashboard development and data modelling.
• Strong proficiency in DAX, Power Query and reliable reporting.
• Experience with data dictionaries, KPI tracking, and data validation.

Responsibilities

• Develop, maintain, and enhance Power BI dashboards and reports.
• Ensure data quality, consistency, and integrity across reporting solutions.
• Prepare monthly and weekly report submissions per project requirements.
• Lead and coordinate the reporting team to meet stakeholder needs.

Skills

Power BI dashboard development

DAX & Power Query

Python (Pandas, NumPy, PySpark)

Data dictionaries & KPI tracking

SharePoint / Excel / SQL

EV M & project controls concepts

Leadership / mentoring

Tools

Power BI

SharePoint

Excel

SQL

Job description

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

What is the project?

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 kms 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: (1) the Elevated Guideways and Stations Contract(“EGS”) and the Pape Tunnel and Underground Station Contract(“PTUS”), with supporting Early Works.

What is the Opportunity?

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.

Responsibilities

• 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.

You’ll bring to the Team (Knowledge, Skills, Competencies)

• 3–5 years of experience in Power BI dashboard development and data modeling


• Strong skills in Power BI (DAX, Power Query) and building reliable reports


• Experience with data dictionaries, KPI tracking, and data validation


• Proficiency in Python (Pandas, NumPy, 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. If you need any accommodation through the process, please email [e-mail]