Data Scientist II (6-Month Term, Potential Extension)

MX Career Site; Toronto; On-site; CAD 69,000 - 93,000; Full time

Benefits offered by this job

Accommodation support

Job summary

Metrolinx in Canada is seeking a Data Scientist II for a 6-month term to develop and implement predictive models for ridership and revenue projections. You will train ML models, build end-to-end data pipelines, and collaborate with stakeholders to drive data-driven decisions.

The role requires advanced SQL, Python, PySpark, and Power BI skills, with experience in Azure Databricks and AI-enabled analytics. This on-site position offers a competitive hourly rate and opportunities for extension.

Qualifications

• Degree in Statistics, Applied Math, Engineering, Computer Science or equivalent combination of education, training and experience.
• Progressive experience in data mining, statistical analysis, and/or predictive analytics.
• Advanced knowledge and working experience with SQL, Python, PySpark Power BI.
• Proficiency with Microsoft Azure and Azure Databricks for data engineering, large-scale data processing and visualization.
• Expertise in prompt engineering and leveraging generative AI tools to accelerate data analysis and automate reporting.
• Experience with hypothesis testing, A/B tests, and predictive/prescriptive modeling.
• Proven applied machine learning modeling experience.
• Proficiency in MS Office tools.

Responsibilities

• Lead the analytical process to predict the impact of service levels on ridership and revenue.
• Train ML models to analyze, categorize and forecast service change impacts.
• Lead model creation, development and execution end-to-end.
• Quantify ridership and revenue impact of new services and customer programs.
• Design and implement end-to-end data pipelines and dimensional models.
• Identify opportunities aligned with KPIs and ROI; propose data-driven solutions.
• Mentor analytics staff and promote best practices across the team.
• Develop innovative data sourcing and tooling to advance modeling capability.
• Extract data from relational databases using SQL.
• Create AI/ML models to improve processes and KPI analysis.

Skills

SQL

Python

PySpark

Power BI

Azure

Azure Databricks

Prompt engineering

Generative AI

Machine learning

Statistics

A/B Testing

Education

Degree in Statistics

Degree in Applied Math

Degree in Engineering

Degree in Computer Science

Tools

SQL

Python

Power BI

Azure Databricks

Job description

Data Scientist II (6-Month Term, Potential Extension)

Canada

Trending

Job Description

Salary Range: $49.76-$67.63 per hour

Term Duration: This is a 6-month temporary position, with the possibility of an extension

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 Marketing Customer Analytics Office is looking for a Data Scientist II to join the team. This individual will be accountable for establishing the analytical methodologies and developing and implementing models for delivering and maintaining Metrolinx ridership & revenue projection under different scenarios. Model results impacts budget and subsidy plans across the company and are regularly presented to Senior Management, MTO and the Minister’s Office for evidence-based decision making.

What will I be doing?

Leads the analytical process to predict the impact of GO & UP service levels on ridership & revenue, customer acquisition, retention and loyalty.

Trains machine learning models to analyze, categorize and forecast service change impacts

Leads the model creation, development and execution process from beginning to end

Oversees work quantifying the potential ridership and revenue impact of customer-centric business opportunities, such as the introduction of new services, the impact of capital builds, and the impact of customer programs

Designs and implements end-to-end data pipelines: work closely with stakeholders to build instrumentation and define dimensional models, tables or schemas that support business processes.

Leads analytical efforts to pinpoint opportunities that align with strategic goals, targets, and key performance indicators (KPIs); recommends data-driven solutions and establishes performance metrics to measure the impact and return on investment (ROI) of identified opportunities.

Leads projects, and provides mentorship to other analytics roles throughout the organization

Ensures best practices are disseminated to the team, and oversee the implementation of innovative and creative ways to source and integrate data or tools to continually advance Metrolinx’s modeling and analytical capability

Conducts data extraction from relational databases using SQL

Create AI/ML models to improve processes within Innovation and Information Technology and lead KPI analysis that identifies service quality and efficiency of delivery

Crafts raw data and analysis into well-written and persuasive content, establishing recommendations and actions that will support business objectives.

Leads Key Performance Indicator (KPI) analysis, presented monthly to SMT, to identify drivers of ridership and fare revenue and inform strategic decisions of service planning and design

Identifying business challenges and developing AI solutions that improve efficiency, automate work, and deliver measurable business outcomes.

What Skills and Qualifications Do I Need?

Completion of a Degree in Statistics, Applied Math, Engineering, Computer Science, or a related discipline – or a combination of education, training, and experience deemed equivalent

Demonstrated progressive experience in data mining, statistical analysis, and/or predictive analytics.

Advanced knowledge and working experience with SQL, Python, PySpark Power BI

Proficient in leveraging Microsoft Azure and Azure Databricks for data engineering, large scale data processing, advanced analytics and visualization

Expertise in prompt engineering and leveraging generative AI tools and AI-powered assistants to accelerate data analysis, automate reporting, streamline business workflows, and improve operational efficiency

Statistical analysis (hypothesis testing, A/B Test analysis, etc)

Predictive and prescriptive modeling (understanding the future / forecasting / advice on possible outcomes)

Demonstrated applied machine learning modeling experience

Proficiency in MS Office (Outlook, Word, Excel, PowerPoint, etc.)

Strong problem solving and critical thinking skills

Has a passion for continuous learning, and identifies best practices to help increase ridership and revenue

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:

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 [e-mail].

Job Info

• Job Identification 117614
• Job Category Information and Technology
• Posting Date 10/23/2026, 02:09 PM
• Apply Before 11/09/2026, 04:59 AM
• Job Schedule Full Time
• Locations 10 Bay Street
• Is this a Contract Position? Yes - Short Term Contract