Metrolinx→
Data Scientist II at Metrolinx in Toronto, Ontario, CA
ExperiencedOn-siteFull-timeToronto, Ontario, CA
Skills
sqlpythonpysparketlpower bimicrosoft azuredatabricks
Job 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 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.
This role is an in‑office position (5 days per week) based at our Bay St. location. Our team is highly collaborative, and much of our work benefits from in‑person co‑creation, relationship‑building, and hands‑on 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.
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 (event/sport/marketing performance, B2B/B2C sales, GTM strategy, etc). 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.
- Analyze, categorize and forecast special events/sports/sales partnership performance
- Leads the model creation, development and execution process from beginning to end
- Lead analytical initiatives to quantify ridership and revenue impacts of customer-focused business opportunities, including new service introductions, capital infrastructure investments, and customer programs.
- Partner closely with Sales and Marketing to deliver actionable insights on Go-To-Market strategies, sports and special event ridership performance, and concert/event demand. Leverage advanced spatial analytics and data science techniques to inform decision-making and drive measurable business outcomes.
- 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
- Perform data engineering, including ETL, data integration, data contextualization and aggregation, to enable data science work
- Conducts data extraction from relational databases (using SQL/Python), environments
- Crafts raw data and analysis into well-written and persuasive content, establishing recommendations and actions that will support business objectives.
- Develops recommendations and oversees the implementation of the recommendations that enhance data governance, data quality and related policies
- 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
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 experience in data mining, statistical analysis, and/or predictive analytics. Experience with establishing revenue models in a progressive environment.
- Advanced knowledge and working experience with SQL, Python, PySpark /ETL, Power BI with distributed databases and complex data sets
- Statistical analysis (hypothesis testing, A/B Test analysis, etc)
- Predictive and prescriptive modeling (understanding the future / forecasting / advice on possible outcomes)
- Knowledge/experiences with cloud (Microsoft Azure, Databricks, GCP)
- Experience with applied machine learning and modeling
- Proficient in leveraging Microsoft Azure for data handling, analysis and visualization
- Proficient in integrating large and disparate datasets using python
- 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
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.
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