Senior Business Intelligence Performance Analyst - Metrolinx

The opportunity

Metrolinx is dedicated to connecting communities across the Greater Golden Horseshoe, operating GO Transit, UP Express, and the PRESTO fare payment system. As an agency of the Government of Ontario, Metrolinx is also actively building new rapid transit, including GO Expansion, Light Rail Transit routes, and major expansions to Toronto’s subway system, to enhance travel for everyone. At Metrolinx, equity, diversity, and inclusion are integral to their values of serving with passion, thinking forward, and playing as a team.

The Finance Business Intelligence and Innovation team is seeking a Senior Business Intelligence Performance Analyst. In this crucial role, you will be responsible for delivering essential business intelligence, comprehensive reporting, automation solutions, and data-driven insights that provide vital support to Finance teams throughout the organization. This position acts as a trusted advisor to Finance stakeholders, offering dependable insights, automating manual processes, improving reporting efficiency, and advancing the adoption of BI, Automation, and AI capabilities to drive continuous improvement across the Finance Division.

Your impact

As a Senior Business Intelligence Performance Analyst, your contributions will directly enhance Metrolinx's operational efficiency and strategic decision-making. You will leverage data and advanced tools to identify trends, optimize processes, and provide actionable recommendations that improve overall performance.

• 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.
• Utilize Python and SQL for data transformation, modeling, and optimization, and leverage GitHub for version control and collaboration.
• Build scripts/bots for repetitive tasks, such as journal entry checks.
• 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 the Executive Leadership team.

Requirements

To succeed in this Senior Business Intelligence Performance Analyst role, you will bring a strong foundation in data analysis, business intelligence tools, and a proven ability to translate complex data into actionable insights that drive performance.

• 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 such as Power BI (preferred) or Tableau.
• Expertise with Python, SQL, GitHub, Power Apps, and Power Automate.
• Experience with Databricks is considered 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.

Metrolinx encourages all interested individuals to apply, even if your past experience doesn’t perfectly align with every qualification listed. They are always seeking great talent to join their team and welcome applications from members of equity-deserving communities.