Senior Systems Analyst – Hybrid

Jobtailor

Toronto

On-site

CAD 90,000 - 120,000

Full time

2 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Jobtailor is seeking a BI/Reporting Specialist to design and maintain Power BI dashboards and data models for leadership and business users. You will translate requirements into technical specs, implement data governance, and collaborate across PMO, Finance and IT.

The role focuses on building scalable reporting solutions, optimizing performance, and ensuring data quality across multiple sources. Strong emphasis on security, UAT and ongoing reporting enhancements is required.

Qualifications

Strong Power BI development, Excel, data modelling and analytical skills.
Ability to build intuitive, dynamic dashboards.
Ability to optimize existing reports and data solutions.
Ability to develop new reporting capabilities.
Ability to ensure data accuracy and meaningful presentation.
Experience with data from multiple enterprise and third-party systems.
Collaborate with Finance, IT, data teams and business units.
Experience with SQL, Azure Data Lake and APIs as required.
Experience implementing RLS and security controls.

Responsibilities

Create and maintain end-user and developer guides for BI solutions.
Design and maintain Power BI dashboards, KPIs and trend analysis for leadership.
Develop ad-hoc analyses and recurring reports to support decisions.
Collaborate with PMO, Finance, IT and other stakeholders on data requirements.
Design, develop and optimize data models and semantic layers.
Implement security and access controls, troubleshoot refresh issues.
Source data from enterprise and third-party systems and ensure data quality.
Support migrations, UAT and post-production validation of reports.

Skills

Power BI Development

DAX

Data Modelling

SQL

Data Quality

Tools

ServiceNow

EcoSys

Jira

Azure Data Lake

Dataverse

Job description

Create and maintain end-user documentation, technical documentation and developer guides
Establish 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 Power BI dashboards, KPIs and trend analysis for leadership and business users
Develop ad-hoc analysis and structured recurring reports to support decision‑making
Partner with PMO, Finance, I&IT and other stakeholders to understand and integrate data requirements
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 reports, datasets and models for performance, usability and scalability
Implement RLS, workspace security and access controls
Troubleshoot data refresh, model, DAX and reporting issues
Analyze enterprise and third‑party source systems and design data structures and integration approaches
Collaborate with data engineers, application developers and BI teams to source and exchange data
Identify data quality issues and implement appropriate controls
Support existing applications, reports, data models and business processes
Investigate production issues, identify root causes and implement sustainable solutions
Automate manual processes, improve data quality and enhance performance
Maintain and enhance reporting solutions
Analyze source and target data structures and develop data mapping, migration strategies and templates
Support migration of reporting data and processes during application or platform changes
Validate migrated data and maintain business reporting requirements during transitions
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

Requirements

Strong Power BI development, Excel, data modelling and analytical skills
Ability to build intuitive, dynamic and engaging dashboards
Ability to optimize existing reports and data solutions
Ability to develop new reporting capabilities
Ability to ensure data is accurate, reliable and meaningfully presented
Experience working with data from multiple enterprise and third‑party systems
Ability to collaborate with Finance, I&IT, data and application teams
Business‑minded data specialist and problem solver able to bridge business requirements and technical implementation
Ability to understand underlying processes and data and create practical, scalable, decision‑ready solutions
Experience with Power BI, DAX, Power Query/M, data modelling and semantic models
Experience with dimensional modelling / star‑schema principles
Experience implementing RLS, workspace security and access controls
Ability to troubleshoot data refresh, model, DAX and reporting issues
Experience with enterprise and third‑party applications such as ServiceNow, EcoSys and Jira
Experience analyzing source systems and designing data structures and integration approaches
Experience with SQL, Azure Data Lake, Dataverse and APIs as required
Experience identifying data quality issues and implementing controls
Experience supporting existing applications, reports, data models and business processes
Experience investigating production issues, identifying root causes and implementing sustainable solutions
Experience developing data mapping, migration strategies and templates
Experience developing and executing UAT, regression and production validation scenarios

Core Competencies

Demonstrates expertise in Power BI development, data modeling, and analytical skills to create intuitive dashboards and optimize reporting solutions. Capable of bridging business requirements with technical implementation while ensuring data accuracy and reliability.

Highest‑signal resume keywords