Systems Analyst - Senior JP223

P@thlion Staffing Careers; Toronto; On-site; CAD 70,000 - 95,000; Full time

Job summary

We are looking for a Performance Analyst to join our team in Toronto. The successful candidate will build intuitive Power BI dashboards, leverage Excel, and apply data modelling and analytical skills to enable leadership and business users to self-serve and understand their data.

The role collaborates with Finance, IT and data teams to optimize reports, ensure data accuracy, and deliver scalable reporting solutions.

Qualifications

• Self-starter with strong Power BI development, Excel, data modelling and analytical skills.
• Ability to build intuitive, dynamic dashboards for leadership and business users.
• Experience optimizing performance of reports and data solutions.
• Collaborates with Finance, IT and data teams to ensure accurate data and meaningful presentation.
• Bridges business requirements and technical implementation.

Responsibilities

• Create and maintain end-user documentation and developer guides.
• Establish reporting standards, KPI definitions and data governance.
• Gather and translate business requirements into reporting specifications.
• Design and maintain Power BI dashboards and KPI analyses for leadership.
• Develop ad-hoc analyses and structured recurring reports.

Skills

Power BI

Excel

Data modelling

DAX

Power Query

SQL

Azure Data Lake

Dataverse

APIs

RLS

Tools

ServiceNow

EcoSys

Jira

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.