Senior Business Intelligence Systems Solution Analyst

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.

The Capital Insights Team, in their support of the Capital Projects Group (CPG), is looking for someone to provide technical skill and be accountable for the design, enhancements and support of Data Insights & Business Intelligence solutions.

The incumbent will bring a strong background in Microsoft Power Platform development, Master Data Management (MDM) and data-as-a-service self-serve analytics.

The Senior BI systems solution analyst will play a critical role in designing, developing, and implementing cutting-edge data products and BI solutions in support of CPG’s strategic and operational data and BI objectives that empower data-driven decision making across the division.

What will I be doing?

• Provides subject matter technical expertise in design, development, and implementation of innovative BI and data analytics solutions using Data analytics and BI technology stack, including Power Platform, Microsoft Fabric, and other BI tools
• Develops and tests proof of concepts, pilots, and production builds for business cases and prioritized roadmap using stakeholder feedback, industry best practices knowledge, and insights on BI trends
• Leads new solutions design or enhance existing BI solutions per business needs, including discovery and analysis, configuration, programming, testing and deployment, support and continuous improvement
• Defines and implements BI and data insights best practices, ensuring BI solutions adhere to data security and privacy standards, maintaining data confidentiality and compliance with relevant regulations
• Implement data quality measures and business data validation rules to maintain the integrity and reliability of master data
• Assist management in Strategic Planning, understanding their long-term data insights goals, and help develop a strategic roadmap for BI initiatives and opportunities for BI expansion and enhancements to align with business objectives
• Analyze and evaluate use of external RESTful APIs, JSON data exchange services, JavaScript and TypeScript to enhance the functionality and user experience of Power Apps / Pages through scripts and code extensions
• Participate in further developing Data Insights and BI solutions lifecycle management practice, including version control, environment management, and solution deployment strategies
• Guide junior team members and conduct knowledge-sharing sessions for delivery partners to maximize the utilization of BI and analytics tools
• Stay up-to-date with the latest trends and best practices in BI, data analytics, data management, and incorporate them into the organization's BI strategy.

Explore and pilot advanced analytics techniques, such as predictive modelling, machine learning algorithms, and artificial intelligence, to enhance CPG data insights.

What Skills and Qualifications Do I Need?

• Completion of a degree in Computer Engineering, Computer Science, Information Technology or a related discipline or a combination of education, training and experience deemed equivalent
• Demonstrated experience in BI solution designing, Data-as-a-service delivery, BI developer / engineer, Analytics and Business Intelligence.
• Microsoft’s role based BI and data analytics, power platform and RPA certification preferred.
• Relevant certifications in Microsoft Power Platform or related areas are highly desirable
• In-depth understanding of database management systems, cloud data storage / retention, analytical processing, and ETL / ELT (Extract, transform, load / Extract, load, transform) framework
• Proficiency in applying BI data orchestration to support centralized data repository, a strong understanding of data platform architecture principles, and familiarity with cloud infrastructure (.

MS Fabric, Power Platform)

• Technical knowledge of data pipelines (Dataflow, Power Query, DAX) to perform data transformation, data cleaning, and data enrichment tasks while connecting to various data sources
• Strong agile solution delivery skills and the ability to manage multiple initiatives simultaneously
• Analytical and problem-solving skills to analyze problems, detect root causes, and resolve issues
• Understanding of Data Management Body of Knowledge (DMBoK) including data storage, privacy and security and data Classification (Reference, Master, Transactional, and Metadata)

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