Analytics Consultant

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

Job summary

A leading consulting firm in Toronto is seeking an Analytics Consultant to support the Financial Planning Performance Management team. This role emphasizes enhancing data processes in SQL and SAS, troubleshooting issues, and delivering accurate reporting. Ideal candidates should have strong SQL, SAS or Python proficiency, advanced Excel skills, and experience with data visualization tools such as Power BI or Tableau. The firm values diversity and is committed to an inclusive work environment.

Responsibilities

• Build and enhance data processes in SQL and SAS.
• Troubleshoot data issues.
• Deliver accurate reporting to leadership and FPs.
• Investigate data anomalies with the manager.
• Develop new features to ensure smooth reporting operations.

Skills

Strong SQL skills

SAS experience or proficiency in Python or R

Advanced Excel skills

SSRS Experience with data visualization tools (Power BI or Tableau)

Experience supporting large operational reporting environments

Job description

Job Description

Insight Global is looking for an Analytics Consultant to join the Financial Planning Performance Management team supports roughly 800 Financial Planners across Canada by producing performance reporting and calculating compensation and commissions tied to behaviour and results. This role focuses on building and enhancing data processes in SQL and SAS, troubleshooting issues, and delivering accurate reporting to both leadership and FPs. The analyst will work closely with the manager, Vera, to investigate data anomalies, develop new features, and ensure smooth reporting operations. It’s a hands‑on, data‑heavy role ideal for someone who enjoys problem‑solving and working with complex datasets.

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 opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their 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 recruiting process, please send a request to [e-mail]. To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• Strong SQL skills
• SAS experience or proficiency in Python or R
• Advanced Excel skills
• SSRS Experience with data visualization tools (Power BI or Tableau)
• Experience supporting large operational reporting environments