Systems Analyst - Senior (HYBRID) JP223

Pathlion; Toronto; On-site; CAD 85,000 - 110,000; Full time

Job summary

Pathlion is seeking a Performance Analyst to join our Toronto team. The role focuses on designing and maintaining Power BI dashboards, data models, and KPIs to enable leadership and business users to self-serve data.

You will collaborate with Finance, IT, and data teams to integrate data from multiple sources, optimize reports, and implement data governance, access controls, and scalable reporting solutions.

Qualifications

• Experience designing and maintaining Power BI dashboards and data models.
• Ability to translate business requirements into reporting specifications.
• Strong data governance and KPI definition skills.
• Proficiency with SQL and data integration across systems.

Responsibilities

• Create and maintain end-user and developer documentation.
• Design and maintain Power BI dashboards, KPIs and trend analyses.
• Collaborate with PMO, Finance, IT and other stakeholders to integrate data requirements.
• Develop ad-hoc analyses and recurring reports for decision making.

Skills

Power BI

Excel

Data modelling

Analytics

Dashboard design

SQL

DAX

APIs

Azure Data Lake

Dataverse

Tools

Power BI

SQL

Azure Data Lake

Dataverse

APIs

Job description

We are looking for a Performance Analyst to join our team. The successful candidate will be a self-starter that has strong Power BI development, Excel, data modelling and analytical skills, with the ability to build intuitive, dynamic and engaging dashboards that enable leadership and business users to self-serve and understand their data. The role will also involve optimizing the performance of existing reports and data solutions, developing new reporting capabilities, and ensuring that data is accurate, reliable and presented in a meaningful way.

The candidate should be comfortable working with data from multiple enterprise and third-party systems and collaborating with Finance, I&IT as well as data and application teams to bring together the information required for effective performance reporting.

The ideal candidate is a business-minded data specialist and problem solver who can bridge the gap between business requirements and technical implementation. They can take an ambiguous reporting or performance challenge, understand the underlying process and data, and turn it into a practical, scalable and decision-ready solution.

This role is an in‑office position based at our 277 Front Street West, Toronto 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.

Responsibilities

Business Analysis & Performance Reporting

• Create and maintain end-user documentation, technical documentation, and developer guides for both existing and newly developed solutions.
• Establishing reporting standards, KPI definitions, and data governance practices.
• Gather and translate business requirements into reporting and technical specifications.
• Understand business processes and identify opportunities for process improvement, automation and reporting optimization.
• Design and maintain intuitive Power BI dashboards, KPIs and trend analysis for leadership and business users.
• Develop both ad-hoc analysis and structured recurring reports to support decision-making.
• Partner with PMO, Finance, I&IT and other stakeholders to understand and integrate their data requirements.

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 / star-schema principles.
• Optimize existing reports, datasets and models for performance, usability and scalability.
• Implement appropriate RLS, workspace security and access controls.
• Troubleshoot data refresh, model, DAX and reporting issues.

Data Integration & Solution Development

• Work with data from multiple enterprise and third‑party applications (such as ServiceNow, EcoSys, Jira,etc).
• Analyze source systems and design appropriate data structures and integration approaches for reporting.
• Collaborate with data engineers, application developers and other BI teams to source and exchange data.
• Work with technologies such as SQL, Azure Data Lake, Dataverse and APIs as required.
• Identifying data quality issues and implementing appropriate controls.

Existing Solution Support & Continuous Improvement

• Quickly understand and support existing applications, reports, data models and business processes.
• Investigate production issues, identify root causes and implement sustainable solutions.
• Evaluate existing solutions and identify opportunities to automate manual processes, improve data quality, and enhance performance.
• Provide ongoing maintenance and enhancement of reporting 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 processes when applications or platforms change.
• Validate migrated data and ensure business reporting requirements are maintained during transition.

Testing, Deployment & Documentation

• Develop and execute UAT, regression and production validation scenarios.
• Support reporting releases and post-production validation.
• Maintain business, technical and data documentation.
• Collaborate with developers and business users throughout the solution lifecycle.