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.

Skills and Requirements
Strong SQL skills
Strong SAS experience
Power BI experience, including reporting/dashboard development
Experience with data extraction, transformation, and applying business logic for reporting
Solid data analysis and troubleshooting skills




Experience maintaining and enhancing operational or performance reporting
Advanced Excel skills
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
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day.

We are an equal employment opportunity/affirmative action employer that believes everyone matters.

Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances.

If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].

📌 Data Analyst (Toronto)
🏢 Insight Global
📍 Toronto