Senior Business Intelligence Performance Analyst

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 Business Performance & Reporting team is seeking Senior Business Intelligence (BI) Performance Analysts. In this role, you will be responsible for determining KPIs for various business units, data collection, data cleansing, data integration, and preparing performance dashboards. Reporting to the Manager, Business Performance & Reporting, you will leverage business intelligence tools to measure operational and business performance and to enable data-driven decision making across Metrolinx.    

Recruiting for multiple positions (Full time permanent and Long Term Contract – 13 months)
 

What will I be doing?

• Develop reporting dashboards and initiate proactive analysis to identify trends and data that support recommendations and innovations to improve performance across Metrolinx divisions and achieve strategic objectives.
• Establish and maintain Key Performance Indicators (KPIs) and supporting metrics to be used to track performance.
• Develop reporting requirements with business unit subject matter experts and utilize a standardized approach to performance reporting.
• Build, optimize, and maintain end-to-end data pipelines to support dashboard development.
• Depending on the portfolio the candidate supports, their primary focus will be on:
  • Develop KPIs/reporting for the Corporate Services team, with a focus on People Reporting, Commercial Management, and Governance, utilizing Python and SQL for data transformation, modeling, and optimization, and leveraging GitHub for version control and collaboration.
  • Develop KPIs/reporting for the Enterprise Performance team, with a focus on SMT Reporting and external stakeholders such as the Ministry of Transportation.
  • Develop KPIs/reporting for the Asset Management & Maintenance division utilizing knowledge of engineering metrics. Utilize engineering knowledge of Reliability, Availability, Maintainability, Safety (RAMS), and connect to the Enterprise Asset Management (EAM) system to develop KPIs for RAMS metrics.
• Liaise with business unit stakeholders to understand their needs for current and future reporting capabilities; on design functionality and interpret requirements, design, and support reporting for all internal and external customers.
• Provide business units and other internal and external customers with insights into KPIs and supporting metrics.
• Define and implement data reporting and analysis best practices (e.g. data integrity, test design, analysis, validation, and documentation).
• Review, clean, and validate data and data sources to ensure accuracy and reliability of reporting outputs.
• Participate in periodic reviews of BI tools and reports with Executive Leadership team. 

 

What Skills and Qualifications Do I Need?

• Completion of a degree in Computer Science, Data Science, Engineering, Mathematics, Statistics, Economics or a combination of education, training and experience deemed to be equivalent.
• Expertise with Business Intelligence tools Power BI (preferred), Tableau etc.
• Expertise with Python, SQL, GitHub, Power Apps, and Power Automate.
• Experience with Databricks is an asset.
• Demonstrated experience developing BI dashboards/reports using complex datasets.
• Analysis and problem-solving skills to analyze trends, performance, and develop actionable recommendations to support business units’ ability to make informed business decisions that facilitate performance improvement and achieving strategic objectives.
• Data collection/management techniques (ETL) and the development/interpretation of data to determine requirements, retrieve, analyze and deliver insights and recommendations.
• Data quality assurance processes, methodology and tools, quality assurance testing and implementation methods and practices to ensure the integrity of data.
• Strong partnership building, relationship management, and collaboration skills to work effectively with business units and stakeholders to collect data and resolve data quality issues.
• Creativity to determine the format of dashboards and to translate a range of diverse data/information into actionable results that support internal and external requirements.
• Excellent verbal, written, and presentation skills to analyze information, draft reports, and communicate effectively with stakeholders across various business units.
• Experience in one or more of the following areas: rail/transit operations, asset management and operational performance monitoring, asset information systems, financial systems.

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 hr.recruitment@metrolinx.com.   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.
 #LI-SC1