Metrolinx connects communities across the Greater Golden Horseshoe, operating GO Transit, UP Express, and the PRESTO system. They are also building new rapid transit infrastructure, including GO Expansion and Toronto's subway system, to enhance public transportation. Metrolinx is an agency of the Government of Ontario.
Equity, diversity, and inclusion are central to Metrolinx’s values of serving with passion, thinking forward, and playing as a team.
This is an in-office position, five days a week, located at their downtown Toronto office. The HR team is highly collaborative, benefiting from in-person co-creation, relationship-building, and hands-on partnership across the organisation.
The Capital Projects Group (CPG) is seeking a Data & Reporting Specialist for Workforce Planning. This role supports data-driven decision-making across CPG, blending advanced analytics, data engineering, and workforce planning. A strong emphasis is placed 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. They will also support workforce planning activities such as demand forecasting, capacity planning, and resourcing analysis.
What You'll Do
Design and implement data management strategies, including building and maintaining ETL pipelines to extract, transform, and load data from multiple systems such as HR, finance, project systems, and 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 comprehensive data analysis using SQL, Python, and advanced Excel features like Power Query and Power Pivot.
Translate complex datasets into clear visual insights through dashboards, charts, and executive presentations.
Support workforce planning initiatives, including headcount forecasting, demand planning, and scenario modelling.
Analyse workforce metrics such as capacity, utilisation, attrition, and hiring trends to identify potential risks and opportunities.
Liaise with internal stakeholders to gather business requirements and translate them into effective technical and analytical solutions.
Provide subject matter expertise in data interpretation, reporting, and workforce analytics.
What You'll Bring
Completion of a degree in Engineering, Business Analytics, Computer Science, Information Systems, or an equivalent combination of education, training, and experience.
Demonstrated experience in a Data Analyst, BI Analyst, or similar role, with exposure to workforce or operational analytics.
Solid knowledge of relational database concepts, database management software, and tools.
Proficiency in computer applications including MS Office Excel (Pivot tables, Power Pivot, Power BI, Power App) and SQL queries.
Foundational experience in workforce planning, capacity modelling, or forecasting.
Strong analytical and problem-solving skills, enabling the collection, organisation, analysis, and dissemination of significant amounts of information with strict attention to detail and accuracy.
Ability to translate business needs into actionable resourcing and forecasting insights.
Excellent interpersonal and relationship management skills to liaise effectively with stakeholders and business units, identifying and managing data and information requirements.
Strong verbal and written communication skills to prepare reports, update and brief management, and provide technical explanations to a range of internal stakeholders.
Our Commitment
Metrolinx values the unique skills and experiences each person brings and is committed to creating and maintaining an inclusive and accessible environment.
The organisation encourages applications from members of equity-deserving communities, including those who identify as Indigenous, Black, racialised, women, people with disabilities, and people with diverse gender identities, expressions, and sexual orientations.
Metrolinx is committed to the requirements of the Accessibility for Ontarians with Disabilities Act. If accommodation is required during the hiring process, candidates are encouraged to contact the Recruitment team.
