Data Analyst

Insight Global; Toronto; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

Insight Global is seeking a Data Analyst to join a Financial Planning Performance Management team supporting approximately 800 Financial Planners across Canada. The role blends back-end data development with front-end reporting, using SAS and SQL to prepare datasets and supporting Power BI reporting migration.

You will troubleshoot data issues, implement business logic for reporting, and contribute to ongoing maintenance and enhancements of the analytics environment.

Qualifications

• Strong SAS experience
• Experience applying business logic for reporting and data preparation
• Strong data analysis and troubleshooting capabilities
• Advanced Excel skills for reporting and analysis

Responsibilities

• Back-end data development using SAS and SQL to prepare data for reporting
• Develop and migrate reports to Power BI and maintain dashboards
• Collaborate on data analysis, issue troubleshooting, and data quality
• Support ongoing enhancements of the reporting environment

Skills

Strong SAS experience

Data extraction and transformation

Data analysis and troubleshooting

Advanced Excel

Tools

Power BI

SSRS

Python

R

Job description

Work Arrangement: 3x hybrid downtown, Toronto

We may use artificial intelligence tools to assist with the screening, assessment, or selection of potential applicants for this position.

Vacancy: Previous employee in this role was converted permanent

JOB DESCRIPTION

Insight Global is looking for a Data Analyst to join a Financial Planning Performance Management team supporting approximately 800 Financial Planners across Canada. This team is responsible for maintaining scorecard and performance reporting used to measure results and support compensation and commission calculations. The role will support both the back-end data development and front-end reporting sides of the environment. On the back end, the consultant will use SAS and SQL to extract data from source systems, apply business logic, troubleshoot data issues, and prepare accurate datasets for reporting. On the front end, the team is migrating its reporting to Power BI. This consultant will support the migration and development of Power BI reporting and, once launched, help with ongoing maintenance, enhancements, and data analysis. This is a hands‑on, data‑heavy role ideal for someone who is strong in SQL and SAS and also has Power BI experience to help modernize the team's reporting environment.

REQUIRED SKILLS AND EXPERIENCE

• Strong SAS experience
• Experience with data extraction, transformation, and applying business logic for reporting
• Strong data analysis and troubleshooting skills
• Experience maintaining and enhancing operational or performance reporting
• Advanced Excel skills

NICE TO HAVE SKILLS AND EXPERIENCE

• Experience with scorecard or performance reporting
• Experience supporting compensation or commission-related reporting
• Experience migrating legacy reporting into Power BI
• Experience supporting large, complex operational reporting environments
• Experience with SSRS Python or R experience