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.
CPG’s workforce is made up of driven and dedicated professionals who care deeply about working together to deliver infrastructure and make a positive impact in our communities. Join us as we build a knowledgeable and collaborative team that courageously changes how transit projects will be delivered.
This role is accountable for the end-to-end design and development of Business Intelligence (BI) solution and data analytics that support CPG’s strategic goals and promote a data-driven culture. Combining strong application development skills—particularly within the Microsoft Power Platform—with advanced capabilities in dashboard design, complex visual storytelling and data modeling, this role translates business needs into scalable, user-centric BI tools. A customer-focused and consultative approach is essential to ensure solutions are aligned with business needs, continuously improved based on feedback, and support informed decision-making at all levels of the organization. This position reports to the Manager, BI Performance & Analytics.
What will I be doing?
Partner with business units to gather, understand and translate complex business requirements into actionable and scalable architectural solution designs.
Develop and test BI prototypes, proof of concepts, pilots and production builds for business improvement plans and business cases that aim to understand and improve on the performance and success metrics through the analysis, processing and reporting of data that is collected through business processes and systems.
Lead the design, development, and continuous enhancement of Business Intelligence (BI) solutions using Microsoft Power Platform (Power BI, Power Apps, Power Automate), Microsoft Fabric, and other BI tools to support strategic and operational goals through scalable, cloud-based analytics solutions.
Optimize BI solution design through data profiling and architecture review. Perform data preparation, including cleansing, transformation, staging, and aggregation, to ensure data accuracy, consistency, and readiness for reporting. Design and deliver insightful visualizations and interactive reports tailored to business needs.
Identify and resolve BI product performance bottlenecks such as slow load times, inefficient queries, and inaccurate insights. Apply best practices in DAX code optimization, Power Query performance tuning, and semantic model design to streamline calculations and improve responsiveness and efficiency.
Develop and maintain comprehensive technical design documentation for BI solutions. Maintain clean and well-organized workspaces, proactively addressing technical debt and ensuring alignment with governance standards. Apply best practices for report storage, retention, and cataloging, including version control and archival strategies.
Explore and apply advanced analytics techniques, including forecasting, predictive modeling, and machine learning to support data-driven innovation and operational intelligence.
Proactively stay current with evolving trends in Business Intelligence, data platforms, and analytics technologies to continuously advance the team’s technical capabilities. Evaluate and implement emerging tools, methodologies, and best practices to drive innovation, scalability, and efficiency in BI solution delivery.
What Skills and Qualifications Do I Need?
Completion of a degree in Computer Science, Computer Engineering, Information Technology, Data Science, or a related STEM discipline — or an equivalent combination of education, training, and professional experience.
Demonstrated experience in Business Intelligence, data analytics, data engineering, or data science. Demonstrated expertise in end-to-end enterprise-level BI solution design and development.
Proficiency in applying BI data orchestration to support CPG’s centralized data repository, a strong understanding of data platform architecture principles, and familiarity with cloud infrastructure (e.g., MS Fabric, Power Platform)
In-depth understanding of database management systems, data modeling, cloud data storage/retention, analytical processing, and ETL/ELT (Extract, transform, load/Extract, load, transform) framework
Demonstrated ability to troubleshoot complex BI issues, analyze root causes, and optimize performance across data models, reports, and queries.
Strong Agile delivery skills with the ability to manage multiple initiatives concurrently while maintaining a high standard of quality and collaboration.
Excellent problem-solving and critical thinking capabilities, combined with a proactive mindset and continuous improvement orientation.
Strong communication skills, with the ability to craft and deliver high-impact presentations to diverse audiences, including senior leadership.
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.
For Internal applicants, with the recent implementation of the Internal Mobility Policy, the internal recruitment process has changed for non-union roles. Candidates must be in their current role for 12 months prior to applying for another role and each applicant must be in good standing (not participating in a Performance Improvement Plan). Please review all provisions of the policy before submitting your application.
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.
