Senior BI Performance Analyst

Metrolinx

Job Location:

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 15 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.

This role is an inoffice position (5 days per week) based at our 20 Bay St. location. Our team is highly collaborative and much of our work benefits from inperson cocreation relationshipbuilding and handson partnership with leaders across the organization. We offer flexibility in start and end times while maintaining core business hours for shared availability across the team.

PRESTO is an electronic transit fare payment system in the Greater Toronto Hamilton and Ottawa areas that eliminates the need for tickets passes and cash. PRESTO serves more than 5 million customers across 11 transit agencies and processes over $2.5 billion in fares through 67 million boardings per month (pre-pandemic). Today PRESTO offers one of the most globally advanced fare payment systems in the world having delivered new ways to pay for customers including real time PRESTO Contactless with credit and Interac debit and PRESTO in Mobile Wallet across its transit agency clients including the Toronto Transit Commission (TTC). Enhancing the customer experience through continuous improvement while working with our transit agency clients to support their needs and maintaining a system that performs exceptionally continue to drive PRESTO toward making transit better for all.

Our Payments (PRESTO) Business Intelligence Office is looking to hire a Senior BI Performance Analyst to play a key role in the development of PRESTOs Business Intelligence (BI) platform by conducting or participating in analytics projects to enhance understanding of business activity deliver actionable insights into operational and financial areas and provide reports that meet the needs of PRESTO operations management executives and client Transit Agencies. This position reports into the Sr. Manager Business Intelligence.

What will I be doing

Conducting or participating in analytics projects which enhance PRESTOs understanding of business activity deliver actionable insights into operational and financial areas.
Designing and developing reporting tools to allow customers to make informed business decisions and facilitate usage growth and improved support to transit agencies.
Interfacing with customers (Transit Agencies and Metrolinx) to understand current and future needs for reporting capabilities and to provide insight into ridership and device behavior.
Supporting self-serve capabilities of the BI system and the training of BI users and power users.
Adopting best practices in reporting and analysis: data integrity test design analysis validation and documentation.
Performing analysis using all available data (BI other internal financial and non-financial data as well as external data) to identify performance improvement revenue completeness transit service provider settlement acceleration and cost savings opportunities.
Support the design and delivery of automated standardized and self-serve BI solutions that reduce manual reporting improve data quality and enable scalable efficient access to insights across the business.
Developing advanced analytical solutions including predictive trend segmentation and anomaly detection analyses to proactively identify operational risks customer behavior patterns revenue leakage and service improvement opportunities.
Leading root cause analysis and data investigations related to operational incidents transaction anomalies customer trends device performance and settlement or reconciliation discrepancies.
Driving continuous improvement and modernization of BI capabilities through automation dashboard optimization data visualization best practices and implementation of scalable reporting architectures.
Designing and optimizing enterprise-grade data models KPI frameworks and semantic layers to ensure consistent scalable and trusted reporting across operational financial customer and executive dashboards.

What Skills and Qualifications Do I Need

Completion of a diploma in a related discipline (Statistics Computer Science Engineering Mathematics Analytics) or an equivalent combination of education training and experience.
Experience using Azure analytics and data platforms such as Azure Synapse Analytics Azure Databricks Azure Data Factory (ADF) Azure SQL Azure Data Lake and Power BI to support enterprise reporting advanced analytics data integration and scalable BI solutions
Demonstrated work experience in advanced analytics business intelligence statistical modeling/analysis data engineering and/or data warehousing and solving complex quantitative business challenges.
Experience with using and generating reports from Business Intelligence (BI) systems
Analysis and problem-solving skills to analyze trends card usage system performance and develop actionable recommendations to support Transit Agencies ability to make informed business decisions that facilitate usage and overall service growth for the PRESTO fare card
Advanced skills in MS Excel and familiarity with BI tools for both query and visualization (i.e. SQL Python Power BI Power Automate etc.)
Excellent oral and written communication skills with a demonstrated ability to build positive productive interpersonal relationships with stakeholders.

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

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:

Senior IC

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