Data Analyst (New Grad)
Sun Life Financial
Waterloo, ON
At Sun Life, we work together, share common values and encourage growth and achievement. We offer many career paths that attract a wide variety of talent and skills. Follow a path that lets your talents shine.

Job Description:
We are currently looking for a Data Analyst (New Grad) with a passion for turning disparate streams of data into organized and actionable analytics services and insights. As a Data Analyst on the Data Science, you will be joining a group of savvy innovators who has made it their mission to find new ways to glean value out of rapidly increasing volumes of insurance data.

To be considered for this position, you are required to complete two steps in the application process. You will need to submit an online job application and complete an online assessment

Role Summary:
Working within a diverse and motivated team of analytics professionals, you will lead the development of efficient data capture and transformation processes and complex data models that form the core of a new generation of analytics services and self-serve solutions for our customers in Individual Insurance.

What will you do?

Create effective ETLs/ELTs to move large volumes of data from various operational systems to dimensional data models for analytics consumption
Acts as a key contributor to all phases of the design and development lifecycle of analytic applications utilizing various BI technology platforms such as Power BI and Power Pivot, Tableau
Ability to work in a collaborative team environment
Excellent written and verbal communication skills and ability to express ideas clearly and concisely in good grammatical form, as well as effectiveness of expression in individual and group situations
Support quantitative analysts and data scientists with data discovery and rapid assembly of large data sets from disparate sources
What do you need to succeed?

University degree in Computer Science, Software Engineering, or equivalent.
Solid skills in SQL, is required.
Experience in any one of the following is required : Python, R, VBA or other languages used in data manipulation
What will be nice to have?

Experience with Tableau, Power BI, Power Pivot is nice to have
Experience with development of ETL processes is nice to have
Proficiency in Microsoft SQL Server tools and technologies such as SSIS is nice to have
What's in it for you?

Competitive salary and bonus structure influenced by market range data
A friendly, collaborative and inclusive culture
Being part of our Analytics community, where we share best practices and broaden skill-sets
Interested in applying? Submit a job application by clicking “Apply” and complete an online assessment within 24 hours of submitting your job application using the link below.

Click on this link: to complete the online assessment after you submit your application. You will need to register with our partner Career Spark, using the same e-mail address used for your job application. If you complete this assessment before submitting your job application then you must return to this job posting again to complete your online job application by clicking “Apply”.

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

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range:
46,900/46 900 - 76,800/76 800

Job Category:
Advanced Analytics

Posting End Date: