Metrolinx is connecting communities across the Greater Golden Horseshoe. Metrolinx operates GO Transit and UP Express, as well as the PRESTO fare payment system. We are also building new and improved rapid transit, including GO Expansion, Light Rail Transit routes, and major expansions to Toronto’s subway system, to get people where they need to go, better, faster and easier. Metrolinx is an agency of the Government of Ontario.
At Metrolinx, equity, diversity and inclusion are essential to living our values of serving with passion, thinking forward and playing as a team.
This role is an in‑office position (5 days per week) based at our downtown Toronto location. Our HR team is highly collaborative, and much of our work benefits from in‑person co‑creation, relationship‑building, and hands‑on partnership with leaders across the organization.
CPG’s workforce is made up of driven and dedicated professionals who care deeply about working together to deliver infrastructure and make a positive impact in our communities. Join us as we build a knowledgeable and collaborative team that courageously changes how transit projects will be delivered.
The Resource, Strategy and Optimization team is seeking a Data & Reporting Specialist, Workforce Planning to support data-driven decision-making across the Capital Projects Group (CPG). This role blends advanced analytics, data engineering, and workforce planning, with a strong emphasis on building scalable data solutions, automating workflows, and delivering actionable insights.
The successful candidate will work with large datasets to develop ETL pipelines, dashboards, and forecasting models, while supporting workforce planning activities such as demand forecasting, capacity planning, and resourcing analysis.
What will I be doing?
- Design and implement data management strategies, including building and maintaining ETL pipelines to extract, transform, and load data from multiple systems (HR, finance, project systems, Azure data sources)
- Develop and maintain relational databases and data models to support efficient data storage, retrieval, and reporting.
- Ensure data integrity, governance, and quality through validation, transformation, and monitoring processes.
- Perform data analysis using SQL, Python, and advanced Excel (Power Query, Power Pivot)
- Translate complex datasets into clear visual insights using dashboards, charts, and executive presentations.
- Support workforce planning initiatives including headcount forecasting, demand planning, and scenario modeling.
- Analyze workforce metrics such as capacity, utilization, attrition, and hiring trends to identify risks and opportunities.
- Liaise with internal stakeholders to gather business requirements and translate them into technical and analytical solutions.
Provide subject matter expertise in data interpretation, reporting, and workforce analytics.
-
What Skills and Qualifications Do I Need?
- Completion of a degree in Engineering, Business Analytics, Computer Science, Information Systems, or a combination of education, training and experience deemed to be equivalent.
- Experience in a Data Analyst, BI Analyst, or similar role with exposure to workforce or operational analytics.
- Knowledge of relational database concepts, database management software and tools and computer applications including MS Office Excel (Pivot tables, Power Pivot, Power BI, Power App) and SQL queries.
- Foundational experience in workforce planning, capacity modeling, or forecasting.
- Analytical and problem-solving skills to collect, organize, analyze, and disseminate significant amounts of information with strict attention to detail and accuracy.
- Ability to translate business needs into resourcing and forecasting insights.
- Interpersonal and relationship management skills to liaise with stakeholders and business units to identify/manage data/information requirements.
Verbal and written communication skills to prepare reports, update and brief management; provide information and explanations of a technical nature to a range of internal stakeholders
-
Don’t Meet Every Requirement?
If you’re excited about working with Metrolinx but your past experience doesn’t quite align with every qualification of this posting, we encourage you to apply. You just might be the right candidate for this or other roles. We are always looking for great talent to join our team.
We invite all interested individuals to apply and encourage applications from members of equity-deserving communities, including those who identify as Indigenous, Black, racialized, women, people with disabilities, and people with diverse gender identities, expressions and sexual orientations.
Accommodation:
We value the unique skills and experiences each person brings to Metrolinx and are committed to creating and maintaining an inclusive and accessible environment. We are committed to the requirements of the Accessibility for Ontarians with Disabilities Act so if you require accommodation during the hiring process, please let our Recruitment team know by contacting us at: 416-202-5601 or email
[email protected] .
Application Process:
All applicants must be legally entitled to work in Canada. Metrolinx will be using email to communicate with you for all job competitions. It is your responsibility to include an updated email address that is checked daily and accepts emails from unknown users. As we send time-sensitive correspondence, we recommend that you check your email regularly. If no response is received, we will assume you are no longer interested in pursuing the opportunity. Please be advised that a Criminal Record Check may be required of the successful candidate.
Should it be determined that any background information provided is misleading, inaccurate or incorrect, Metrolinx reserves the right to discontinue with the consideration of your application.
We thank all applicants for their interest, however, only those selected for further consideration will be contacted.
WE ARE AN EQUITABLE AND INCLUSIVE EMPLOYER.
#Li-MM3
