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:

About Client Data Solutions

Client Data Solutions (CDSS) in Group & Wealth Operations supports both Group Benefit and Group Retirement Services clients with all of their plan member data needs.

We specialize in:

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

What will you do?

Client project management (75%)

• Work with Client’s and internal business partners to understand plan design and document requirements related to demographic, contribution and/or payroll files
• Identify gaps which exist between a Client’s request and Sun Life’s standards
• Work with the Client’s technical representatives to coordinate extracts and transfer of plan member data from and/or to the appropriate Sun Life systems
• Apply project management techniques to ensure client initiatives are on track: create project plans; set up and lead regular touch-points with clients; influence client and internal partners to meet deadlines; document project status, minutes and key decisions made; provide progress updates to Manager
• Troubleshoot client file issues, with the support of internal business partners
• Build data file maps using IBM Sterling B2B Integrator software
• Lead data file implementation through all stages of the software development lifecycle: requirements, solution design, development, testing, deployment and monitoring

Production support (15%)

• Provide support to internal business partners with respect to existing demographic, contribution or payroll file related inquiries
• Act as a subject matter expert when working with internal business partners to troubleshoot data file issues

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
• Create documentation of business processes and provide training on new or enhanced processes, when required
• Adhere to the team processes and workflow management

What do you need to succeed?

• Knowledge of Group Retirement products and processes is required
• Knowledge of plan setup and member administration
• Knowledge of software development lifecycle: requirements gathering, solution design, development, testing, deployment and monitoring as well as software development methodologies (Agile, Iterative, Waterfall)
• Advanced level of skills in Microsoft Excel
• Strong customer service skills
• Understanding of the “big picture” and downstream impact of work on other Operations teams
• Ability to work under pressure and meet quick turnaround times
• Collaborative, analytical and solutions-oriented
• Coding Skills with any procedural programming languages (C, C++, Java, Pascal, BASIC)
• Good understanding of XML structure, capabilities, XML parsers
• 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.

Assets

• Experience with Internet-based technologies (e.g. FTP, secure web-sites etc.)
• Good understanding of database schemas and related concepts; SQL scripting; ETL – Extract, Transform, Load methodology
• Translation mapping experience with IBM Sterling B2B Integrator Map Editor to map documents in the following data formats: Electronic Data Interchange (EDI), positional, variable-length-delimited, Extensible Markup Language (XML)

What’s in it for you?

• We are proud to be on the 2024 Best Workplaces in Canada list by Great Place to Work.
• We are thrilled to be recognized by Excellence Canada with their top-level certification, the Canada Order of Excellence for Mental Health at Work®, for prioritizing employee well-being, fostering a positive work culture, and achieving excellence in mental health.
• Work and professional development that is united by our Purpose: to help Clients and Employees achieve lifetime financial security and live healthier lives
• Pension, stock and savings programs to help build and enhance your future financial security
• Be part of our continuous improvement journey in developing the next greatest digital enterprise experience.

#LI-Hybrid

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.

We are proud to be a hybrid organization that offers our employees the choice and flexibility to work from both the office and virtually based on the needs of the business, our Clients and you! Several 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:

Job Category:

Posting End Date: