Systems Analyst - Senior (HYBRID) JP223

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.