Sun Life

Data Production Analyst

28 March 2024
Apply Now
Deadline date:
£37000 - £70000 / year

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. 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:

Location: Hybrid

The Client Data Solutions (CDSS) team’s major business objective is to change, optimize and improve the manner in which we process and deliver data services to our group business lines – Group Benefits (GB) and Group Retirement Services (GRS). Our strategy is to build a service-oriented center of excellence model, which focuses on client (internal and external) service and recognizes the importance of all stakeholders and its impact to a centralized data management strategy. We specialize in:

  • Inbound bulk data files and automated feeds from our clients into Sun Life (e.g., demographic data loads, asset transfer-in files, GRS enrolment and contribution feeds, etc.)
  • Data loads, transfers, analysis and reporting to support client implementations, revisions, and ongoing service

This role specifically is on the CDSS Group Benefits (GB) Production team, which is responsible for handling large data loads to our systems based on our GB Clients’ needs. A key driver to the success of our team is finding people that possess a great mix of business knowledge, data manipulation skills and the ability to communicate well with our business partners to prioritize our clients’ needs.

Reporting to the Manager, Client Data Solutions, the Data Production Analyst is responsible for the coordination and execution of client data transfers to the appropriate Sun Life systems, with emphasis on accuracy and efficiency. This may involve working directly with Sun Life Service Representatives in Business Development, Implementation Project Managers, Plan Setup and Member Specialists in Operations.

Data manipulation will be required at the time of new business implementations or major amendments to existing customer plan designs, as well as ongoing maintenance of existing client data.

What will you do?

Production support inbound (processing various member data files from plan sponsors) (90%)

  • Manipulate and reformat data files from the client’s format to a compatible Sun life format
  • Coordinate with Sun Life’s Business Projects and Solutions and IT teams to ensure data is mapped accurately to plan set up
  • Perform compares between two or more data files to identify discrepancies
  • Responsible for claim history load transfers
  • Create pre-populated enrolment forms, interim pay direct drug cards, and partial loader templates for plan members.
  • Provide timely and accurate data file management support to Implementation Project Managers, Plan Setup and Member Specialists in Operations

Best practices and team development (10%)

  • Collaborate continuously with team members to identify and implement process improvements and best practices, in order to enhance efficiency and productivity
  • Document business processes and provide training on new or enhanced processes, when required.
  • Adhere to quality, audit and time tracking checking functions within the team.
  • Provide coaching to peers and Data Specialists on the team
  • Support Manager with organizing and leading training sessions

What do you need to succeed?

  • Advanced Excel skills (formulas, VLOOKUP, IF statements, pivot tables) is required
  • Detail-oriented and analytical skills with an ability to work with large sets of data
  • Organization, time management and prioritization skills to be able to work under pressure and meet quick turnaround times
  • Collaborative, solutions-oriented and customer service skills
  • As this position is posted in several locations, we specify that bilingualism (French, English, both oral and written) is required for Quebec only as the position reports to a unilingual English-speaking manager outside Quebec.

What will be nice to have?

  • Experience with VBA macro or SQL.
  • Knowledge of the Group Benefits businesses, products, and processes.
  • Knowledge of plan setup and member administration on the OASIS and CHESS systems

Reasons why should you join us under the sun

  • We’re proud to be recognized as a company with a 2023 Most Trusted Executive team by Great Place to Work® Canada!
  • Opportunities to own your career development with programs to continuously learn, build skills, grow through coaching and more.
  • Being part of our journey in developing the next greatest digital experience.
  • Working together, sharing common values, and encouraging growth & achievement
  • Time off giving you the flexibility to focus on the moments that matter. 15 days’ vacation per year.
  • Flexible Benefits from the day you join to meet the needs of you and your family.
  • Pension Plan participation starts immediately, and you are automatically enrolled. We help you save more with Sun Life automatic and matching contributions and by including both your salary and bonus when making contributions.


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:

53,800/53 800 – 87,400/87 400

Job Category:

Business Analysis – Process

Posting End Date: