Data Analyst, HR Reporting

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 10 hours ago

Vacancies: 1 Vacancy

Job Summary

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

Dont Meet Every Requirement

If youre excited about working with Metrolinx but your past experience doesnt 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: or email @.

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

#LI-MM3

Required Experience:

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