Systems Analyst - Senior (HYBRID) JP223
Senior systems/performance analyst designing and optimizing Power BI dashboards, KPIs and data models (DAX, Power Query, SQL, Azure Data Lake, Dataverse) that pull from enterprise systems like ServiceNow, EcoSys and Jira to give leadership self-serve insights. Hybrid role based in-office at 277 Front St W, Toronto, partnering with Finance, PMO and I&IT.
- Compensation
- Not disclosed
- Location
- Toronto, ON, Canada
- Work setup
- Not specified
- Seniority
- Senior
- Employment
- Not specified
- Experience
- Not specified
- Category
- Business analysis
- Posted
Skills
Must have
- Strong Power BI development skills
- Strong Excel skills
- Data modelling and analytical skills
- Ability to build intuitive, dynamic, engaging dashboards for self-service
- Comfortable working with data from multiple enterprise and third-party systems
- Collaborate with Finance, I&IT, and data/application teams
- Business-minded problem solver bridging business requirements and technical implementation
- Power BI development with DAX, Power Query/M and semantic models
- Dimensional modelling / star-schema principles
Nice to have
- RLS, workspace security and access controls
- SQL
- Azure Data Lake
- Dataverse
- APIs
- Experience with ServiceNow, EcoSys or Jira data
- UAT, regression and production validation testing
- Data migration/mapping and platform transition experience
- Creating business, technical and developer documentation
Full 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.
ResponsibilitiesBusiness 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.