RQ00223 - Systems Analyst - Senior

S M Software Solutions Inc; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

Metrolinx is seeking a Senior Systems/Performance Analyst to design and maintain Power BI dashboards, data models, and reports that empower leadership and business users to self-serve data. The role requires SDLC mastery, requirements gathering, data integration, testing, deployment, and production support.

You will work across enterprise systems, applying SQL, Azure Data Lake, and data governance practices to translate complex reporting needs into scalable solutions.

Qualifications

• Experience designing and delivering BI dashboards and reports.
• Ability to translate business requirements into technical specifications.
• Strong data modelling and dimensional modelling knowledge.
• Hands-on experience with Power BI Service, DAX, and Power Query.
• Familiarity with data governance and data quality practices.

Responsibilities

• Design, develop, and maintain Power BI dashboards, KPIs, and trend analyses for leadership and users.
• Gather, translate, and document business requirements into reporting specifications.
• Collaborate with PMO, Finance, IT, data teams and stakeholders to integrate reporting requirements.
• Implement and manage security, access controls, and RLS in Power BI environments.
• Troubleshoot data refresh, DAX, and data model issues in production.
• Provide ongoing maintenance, support, and enhancements for reporting solutions.

Skills

SDLC

Power BI

SQL & modelling

Data governance

DAX/Power Query

Stakeholder mgmt

Excel advanced

RLS security

Azure data

RAD method

Job description

Performance Analyst / Systems Analyst – Senior

Client: Metrolinx

Requisition: RQ00223

Job Title: Systems Analyst – Senior

Work Location: 277 Front Street West, 4th Floor, Toronto, ON, Canada

Work Arrangement: Hybrid – 3 days in office, with the possibility of 5 days onsite

Start Date: September 28, 2026

End Date: March 26, 2027

Estimated Contract Duration: 130 business days

Hours: 7.25 hours per day

Public Sector Experience: Nice to Have

Role Overview

We are seeking a Senior Performance Analyst / Systems Analyst with strong expertise in Power BI development, data modelling, SQL, Excel, business analysis, and performance reporting.

The successful candidate will be responsible for designing and maintaining intuitive, dynamic, and scalable dashboards and reporting solutions that enable leadership and business users to effectively understand and self-serve their data.

This role requires a strong understanding of the Systems Development Life Cycle (SDLC), requirements gathering, data integration, solution development, testing, deployment, production support, and continuous improvement.

The ideal candidate will be a business-minded data specialist who can bridge the gap between business requirements and technical implementation, work with data from multiple enterprise and third-party systems, and transform complex or ambiguous reporting requirements into practical, scalable, and decision-ready solutions.

Key Responsibilities

• Business Analysis & Performance Reporting
• Gather, analyze, and translate business requirements into reporting and technical specifications.
• Understand business processes and identify opportunities for process improvement, automation, and reporting optimization.
• Design, develop, and maintain intuitive Power BI dashboards, KPIs, and trend analysis for leadership and business users.
• Develop ad-hoc analysis and structured recurring reports to support business decision-making.
• Establish reporting standards, KPI definitions, and data governance practices.
• Partner with PMO, Finance, I&IT, data teams, application teams, and other stakeholders to understand and integrate reporting requirements.
• Create and maintain end-user documentation, technical documentation, and developer guides.
• Power BI & Data Development
• Design, develop, and maintain Power BI reports using DAX, Power Query/M, data modelling, and semantic models.
• Build efficient reporting models using dimensional modelling, facts, dimensions, and star-schema principles.
• Optimize existing Power BI reports, datasets, and data models for performance, usability, and scalability.
• Implement and manage Row-Level Security (RLS), workspace management, security, and access controls.
• Troubleshoot data refresh, DAX, data model, and reporting issues.
• Support and enhance existing Power BI solutions in production.
• Data Integration & Solution Development
• Work with data from multiple enterprise and third-party applications, including platforms such as ServiceNow, EcoSys, Jira, and similar systems.
• Analyze source systems and design appropriate data structures and integration approaches for reporting.
• Integrate and model data from multiple systems and data sources.
• Collaborate with data engineers, application developers, and BI teams to source, exchange, and validate data.
• Work with technologies including SQL, Azure Data Lake, Dataverse, APIs, and cloud-based data services as required.
• Identify data quality issues and implement appropriate controls and remediation approaches.
• Existing Solution Support & Continuous Improvement
• Quickly understand and support existing applications, reports, data models, reporting ecosystems, and business processes.
• Investigate production issues, identify root causes, and implement sustainable solutions.
• Evaluate existing reporting and data solutions to identify opportunities for automation and performance improvement.
• Improve data quality and reduce manual reporting processes.
• Provide ongoing maintenance, support, and enhancements for reporting and automation solutions.
• Data Migration & Platform Transition
• Analyze source and target data structures and develop data mapping, migration strategies, and templates.
• Support migration of reporting data and business processes when applications or platforms change.
• Validate migrated data and ensure business reporting requirements remain intact throughout the transition.
• Identify and resolve data discrepancies associated with migration and platform transitions.
• Testing, Deployment & Documentation
• Develop and execute UAT, regression testing, and production validation scenarios.
• Support reporting releases and post-production validation.
• Collaborate with developers, business users, and technical teams throughout the solution lifecycle.
• Maintain business, technical, data, testing, and solution documentation.
• Ensure reporting solutions are accurate, reliable, secure, and aligned with business requirements.

Required Skills & Experience

Skill / Experience Requirement Systems Development Life Cycle (SDLC), including requirements gathering, solution design, development, testing, implementation, and post-deployment support Required Ability to quickly understand existing applications, data structures, reporting ecosystems, and business processes Required Advanced Power BI development, including DAX, Power Query/M, data modelling, semantic models, and Power BI Service Required Strong SQL and data modelling knowledge, including relational databases, dimensional modelling, facts, dimensions, and star-schema concepts Required Experience integrating and modelling data from multiple enterprise and third-party systems Required Business requirements gathering and translation into technical/reporting solutions Required Production support and troubleshooting of Power BI solutions Required Strong analytical and problem-solving skills Required Power BI RLS, workspace management, security, and access controls Required Power Apps and Power Automate Required Advanced Excel, including Power Query, Power Pivot, and VBA/macros where applicable Required Strong communication and stakeholder management skills Required Experience with Rapid Application Development (RAD) methodologies Required

Nice-to-Have Skills

• Experience integrating data from APIs, cloud-based data services, enterprise applications, and third-party systems.
• Experience with project and portfolio management platforms such as Asana, Microsoft Project, or similar enterprise PM systems.
• Experience with PMO, project portfolio, financial, or operational performance reporting.
• Understanding of project status, risks, financials, milestones, and resource reporting.
• Experience working across multiple BI, data, or development teams on shared reporting models, datasets, workspaces, and enterprise data sources.
• Python or other scripting experience for data analysis, automation, or data processing.
• Previous public sector experience is considered an asset.

Core Deliverables

The successful candidate will be responsible for delivering and supporting:

• Enterprise performance reporting dashboards.
• Power BI reports, datasets, and semantic models.
• Integrated datasets and data models.
• Reporting and technical requirements documentation.
• Testing and UAT artifacts.
• Data migration deliverables and validation.
• Power Automate workflows and business process automation.
• Production support and ongoing reporting enhancements.
• Data quality improvements and reporting optimization.
• Decision-ready reporting solutions for leadership, PMO, Finance, I&IT, and business stakeholders.

Candidate Profile

The ideal candidate is a Senior Systems/Performance Analyst and Power BI specialist who combines strong technical data skills with business analysis and stakeholder management capabilities.

Candidates should be able to independently analyze complex business and reporting requirements, work across multiple data sources and technical teams, troubleshoot existing solutions, and develop scalable reporting solutions that improve decision-making, automation, data quality, and operational efficiency.