At a Glance
- Tasks: Analyze data and support performance reporting for financial planners across Canada.
- Company: Join a dynamic team in a leading financial services firm.
- Benefits: Hybrid work model, competitive salary, and opportunities for professional growth.
- Other info: Exciting opportunity for hands-on data enthusiasts in a collaborative environment.
- Why this job: Make an impact by modernizing reporting with Power BI and enhancing data analysis.
- Qualifications: Strong skills in SAS, SQL, and Power BI; data analysis experience required.
The predicted salary is between 85500 - 104500 $ per year.
Work Arrangement: 3x hybrid downtown, Toronto.
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
Data Analyst employer: Insight Global
At Insight Global, we pride ourselves on fostering a dynamic and inclusive work culture that empowers our employees to thrive. As an In-House Commercial Counsel in Mississauga, you will benefit from competitive compensation, comprehensive benefits, and ample opportunities for professional growth while working alongside innovative teams in a fast-paced environment. Join us to make a meaningful impact in the e-commerce and ad tech sectors, where your expertise will be valued and your contributions recognized.
