Senior Business Intelligence Performance Analyst
- Location
- Toronto
- Workplace
- On-site
- Employment
- Full-time
About this role
Metrolinx's Innovation and Information Technology group supports female team members via "Go Tech Women" an affinity group for women in Information Technology, led by our Chief Information Officer.
If you enjoy technology and innovation, value diversity, appreciate work/balance and are looking for an opportunity to make a better world via public service, Metrolinx would like to hear from you!
Our Metrolinx I&IT Business Intelligence Office is looking to hire a Senior BI Performance Analyst to play a key role in the development of Metrolinx Payments (PRESTO)’s 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.
- Conducting or participating in analytics projects which enhance PRESTO’s 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.
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.
Metrolinx is an equal opportunity employer and committed to a diverse and inclusive workforce. We are also committed to offering reasonable accommodation to job applicants in accordance with applicable legislation. If you require assistance or an accommodation at any point during the hiring process, please contact us at: 416-202-5601 or email [email protected].
#LI-MM3
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Ask your AI about this role
Connect Clera once, then ask if it fits you.
Ask about this role
Read the Senior Business Intelligence Performance Analyst listing at Metrolinx (https://www.getclera.com/jobs/metrolinx/senior-business-intelligence-performance-analyst-q06le1m6qeaz) and tell me whether it fits my profile. Save it for me if it does.
Not connected yet? Takes a minute
https://mcp.getclera.comSign in with your Clera account. MCP docs