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. You'll 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, you'll 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.
Job Description:
The successful candidate will implement and manage Global Data Mining projects and support reporting functions requiring technical skills with latitude in approach and analysis. This person will participate in defining the objectives, scope, and requirements of assigned activities, analyze issues and problems and determine the best approach and methodology to address them.
The main objective of the job is to translate client (internal/external) requirements into ETL data flows from source to target. Other major activities may include, but are not limited to, support marketing research, statistical analysis, ad-hoc reporting and the implementation of necessary system and operational controls, to ensure data integrity and compliance with industry legislation and/or internal company policies.
What Will You Do?
Assist in defining requirements, plans, and implement projects which are complex, analytical, and very technical in nature
Analyze operational and system problems and suggest solutions on how to address them
Design, implement, and maintain system applications to support Actuarial Studies, Financial Reporting, Marketing Research, and Management Information reporting
Implement system and operational controls to ensure data integrity of reports and analyses produced in the department
What Do You Need To Succeed?
University degree in Computer Science, Mathematics, or Statistics or College diploma in Information Technology or Computer Programming
Communicates effectively to a wide variety of diverse audiences at all organizational levels
Demonstrates responsibility for own results and commits to learning and self-improvement through education and feedback
Asks the right questions to analyze and distinguish relevant facts in order to problem solve and improve work practices
3+ years experience in designing ETL solutions and packages in SSIS
3+ years experience with Visual Basic or C#
3+ years experience with SSMS and SQL queries
3+ years experience with SSAS
3+ years experience in data analysis
Experience with SSRS and Tableau
Strong knowledge of MS Excel and MS Access including VBA
Assets
Understanding of Life Insurance and/or Segmented Funds
Knowledge of projects and systems development methodologies
Problem solving methodologies
Unique Requirements
What's In It For You?
Great Place to Work® Certified in Canada and the US - 2022
Great Place to Work® award for Best Workplaces for #HybridWork - 2022
Named “Best Places to Work” by Glassdoor - 2021
Canada Award for Excellence for Mental Health at Work - 2021
Flex hours and Flexible hybrid work model including in-country work-from-home if you prefer. #LI-Hybrid
Competitive salary and bonus structure influenced by market range data
Pension, stock and savings programs to help build and enhance your future financial security
A friendly, collaborative, and inclusive culture
Be part of our continuous improvement journey in developing the next greatest digital enterprise experience.
Work and professional development that is united by our Purpose: to help Clients and Employees achieve lifetime financial security and live healthier lives
A common sense dress code, where you decide how you dress based on your day
The opportunity to move along a variety of career paths with amazing networking potential
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 [email protected].
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.
We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.
Salary Range:
58,700/58 700 - 93,900/93 900
Job Category:
IT - Application Development
Posting End Date:
13/07/2023
