Data Analyst (VBA,SQL) - Jobs in Toronto, ON

Job Description

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. Youll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, youll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.Role SummaryDo you have a passion for data Do you enjoy influencing business decisions that impact our employees, clients and financial outcome If you are both analytical, business savvy who also thrives on executing results, we need you to join our high performing team to deliver exceptional value through analytics and insights that will support and execute a Client for Life outcome.Join our Analytics & Insights Team Today!Reporting to the Manager, CSC (Client Solutions Centre) Analytics and Insights as a Data Analyst you will focus on supporting our high growth business segment in accelerating the growth and application of analytics in driving value. S/He will leverage practical experience in applying varied data analysis techniques & offering advice/inputs to help with solving complex business problems.What will you do

• Support and successfully execute end-to-end Sales Incentive Plan (SIP) for our Financial Services Consultants and Retirement Consultants
• Support and provide subject matter expertise to business partners on leads management analytics tools and processes
• Monitor and maintain critical leads management analytics tools and support the development of new analytics tools
• Provide insights on sales performance metrics, key drivers and present findings to Leaders to support decision making
• Manage scope and timelines for the sales incentive plan process to ensure all commitments are met
• Become a subject matter expert in understanding critical business needs and data requirements that feeds into modelling and quarterly sales incentive plan execution
• Remain organized and proactive under conditions with multiple tasks and tight deadlines that may change to reflect current priorities
• Work with minimal supervision; exercise sound judgment during planning, testing, and production of CSC metrics.
• Perform calculations and develop forecasts to communicate responses and recommendations to specific inquiries from CSC Management team

What do you need to succeed

• The role requires an experienced analyst (2+ years) with diverse analytical and business-focused skills
• Intermediate to Advanced user of Microsoft Excel, Microsoft Access, VBA and SQL
• Proven ability to work well independently, but also function in a team environment with frequent contact with people at all levels of the SLF Canada organization.
• Must be able to effectively communicate complex results to a business audience not familiar with complicated data and analytics.
• Able to think with agility in meeting business partners demanding deadlines.
• Well-developed communication and interpersonal skills (collaborating, questioning, listening, writing, observing), with an ability to influence change through thoughtful recommendations

• Excellent planning, organizational and time management skills
• Comfortable learning new applications and processes quickly with minimal direction
• Attention to detail and ability to quickly find alternate solutions to challenges
• Proven balance of analytical and creative problem-solving skills.
• Comply fully with all privacy, confidentiality, do not contact, SLF Code of Business Conduct, data security, and other requirements related to client data.

Unique Requirements

• Must be able to attain Canadian Reliability Security Clearance (administered by submitting fingerprints to the RCMP, who then conduct min. 5 year history checks)

What will be nice to have

• Bachelor’s degree in Mathematics, Computer Science or Computer Engineering
• Experience in Sales Incentive plan compensation and modelling
• Experience in a blended call centre sales environment
• Experience with a structured management operating system
• Siebel CRM service and/or sales experience; and other call centre knowledge
• Financial services / product experience and knowledge
• Understanding of Group Benefits; Individual Insurance and Investments; Group Retirement Services businesses

What’s in it for you

• Competitive salary influenced by market range data
• 15 days vacation per year
• Remote work/ Hybrid Work environment
• Flexible Benefits from the day you join to meet the needs of you and your family
• Fitness and wellness programs that help you balance work and life and enjoy a healthier lifestyle
• Being part of our Analytics community, where we share best practices and broaden skill-sets

The Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results.Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.Persons with disabilities who need accommodation in the application process or those needing job postings in an alternative format may e-mail a request to thebrightside@sunlife.com.At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.Sun Life is committed to the health and safety of all those in our workplaces and our communities. In accordance with Sun Life’s Vaccination Policy (Canada):

• Employees permitted to work remotely are required to be fully vaccinated against COVID-19 in order to attend a Sun Life office, Financial Centre or offsite location where activity related to Sun Life business occurs.
• Employees whose job duties require them to attend a Sun Life office, Financial Centre or offsite location for Sun Life business must be fully vaccinated against COVID-19 effective May 1st.
• Employees whose regular workplace is a Financial Centre and SLFD field leaders must be fully vaccinated against COVID-19 or participate in Sun Life’s Rapid Screening Program to attend a Financial Centre or an offsite event.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.Salary Range:50,100/50 100 - 81,900/81 900Job Category:Advanced AnalyticsPosting End Date:15/05/2022Quick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job

Stay Connected