Data Analyst, Signals & Communications

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.
Our Signals & Communications Office is looking for a Data Analyst to provide expertise in and coordinate the development of data management strategies and data collection systems for Customer Service/Safety and Security Division. You will identify and analyze data trends/issues and make recommendations for improvement to business, operations and system processes.
What will I be doing?

• Responsible for the extraction of data from primary and secondary sources and supports the reporting and analytics of asset class and system performance to meet levels of service and Reliability, Availability, Maintainability and Safety (RAMS) targets throughout the asset lifecycle.
• Identify, analyses, and interpret trends or patterns in complex data sets using programming platforms for data gathering and analysis activities; produce 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.
• Imports, cleans, transforms, validates, and models data to improve data quality and ensure data is accurate and fosters understanding of operational, business and system issues/trends while advising on data issues which includes quality, availability, and usability.
• Work with team members in other transit and enforcement agencies to gather and share information on data management and collection strategies, operational, business together with system issues and best practices.
• Develop data management strategies and data collection systems including the design of relational databases for information management and retrieval that improve statistical efficiency, data quality and supports evidence-based decision-making.
• Build forecasting models for utility expenditure and asset performance.
• Present data in dashboards, charts, graphs, and tables by building online applications such as data input/data collection screens to capture and present meaningful information for reporting, analysis, and presentation purposes for use by management, internal departments and partners in implementing process improvements.
• Supports and implements data strategies for data modeling and analysis and the development of RAMS input data requirements for key performance metrics to assess and provide data on failure rates of the system, potential failure modes, maintenance operations, and identify hazards and their consequences for the asset class infrastructure.

What Skills and Qualifications Do I Need?

• Minimum two (2) years' experience in a Data Analyst or similar role, with a background in technology, information management, relational database design, business intelligence, data mining or statistics.
• Knowledge of data visualization software like Tableau, PowerBI, or equivalent platforms, and familiar with data visualizations such as Pareto charts, Histograms, and Treemap charts.
• Verbal and written skills to prepare reports, update, and brief management; provide information and technical explanations to a range of company partners
• Knowledge of relational database concepts, database management software and tools and computer applications including MS Office Excel (Pivot tables, Power Pivot, formulas, VBA) and SQL queries.
• University degree in Mathematics, Economics, Computer Science, Information Management, Statistics, Engineering or a related discipline, or a combination of education, training and experience deemed equivalent.
• Experience in identify trends in data and provide insight into results and outline recommendations.

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.