Data Analyst HR Reporting

Metrolinx; Canada; On-site; CAD 60,000 - 80,000; Full time

Job summary

A significant transit authority in Canada seeks an individual for data management, focusing on developing strategies, analyzing complex datasets, and creating dashboards. Ideal candidates will have experience with Power BI and a strong command of Excel. We value diversity and inclusion and welcome individuals from various backgrounds to apply. This is an exciting opportunity to contribute to vital transit projects while ensuring data integrity and supporting evidence-based decisions.

Qualifications

• Basic to intermediate experience using Power BI for reporting.
• Working knowledge of Power Query for data transformation.
• Proficiency in Microsoft Excel, including PivotTables.

Responsibilities

• Develop data management strategies and collection systems.
• Analyze and interpret trends in complex data sets.
• Present data in dashboards and reports for management.

Skills

Power BI

Power Apps

Power Query

Microsoft Excel

Verbal communication

Written communication

Job description

Job Description

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.

What will I be doing?

• Develops and implements data management strategies and data collection systems including the design and development of relational databases for information management and retrieval that optimize statistical efficiency, data quality and supports evidence based decision making.
• Imports, cleans, transforms, validates and models data to improve data quality and ensure data is accurate and relevant and fosters understanding of operational, business and system issues/trends while advising on data issues which includes quality, availability and usability.
• Identifies, analyses, and interprets trends or patterns in complex data sets using Data Definition Language or Data Manipulation Language commands for data gathering and analysis activities; produces ongoing and ad hoc reports and dashboards that identify issues, provide insight into results and outline recommendations for process improvements to resolve operational, business and system issues.
• Presents data in dashboards, charts, graphs and/or tables by building, designing and maintaining online applications such as data input/data collection screens to capture and present meaningful information/data for reporting, analysis and presentation purposes for use by management, internal business units and stakeholders in identifying and implementing process improvements.
• Develops and maintains a comprehensive and up-to-date knowledge of internal and external data sources relevant to operational, business and systems data to design and build meaningful databases that centralizes data for internal stakeholders to access.

What Skills and Qualifications Do I Need?

• Basic to intermediate experience using Power BI to create reports and dashboards, including data visualization and simple data models.
• Exposure to Power Apps (Canvas apps) to support data collection and basic business processes.
• Working knowledge of Power Query for data cleaning and transformation.
• Understanding of relational data concepts and experience working with structured data from Excel, SharePoint, or SQL-based sources.
• Proficiency with Microsoft Excel, including formulas, PivotTables, and basic data analysis.
• Ability to analyze data, identify patterns or trends, and support reporting requirements with attention to detail.
• Willingness and ability to learn new tools and technologies, particularly within the Microsoft Power Platform.
• Ability to follow requirements and collaborate with team members and stakeholders to support reporting and application needs.
• 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.
• Exposure to Power Automate, SQL, or basic scripting is an asset.

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 experience 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 [e-mail].

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.

For Internal applicants, with the recent implementation of the Internal Mobility Policy, the internal recruitment process has changed for non‑union roles. Candidates must be in their current role for 12 months prior to applying for another role and each applicant must be in good standing (not participating in a Performance Improvement Plan). Please review all provisions of the policy before submitting your application.

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.