Integration Consultant

Profile insights
Here’s how the job qualifications align with your profile.
Skills

XML

Waterfall

Software development
+ show more

Do you have experience in XML?
Languages

French

Bilingual

English

Do you know French?
 
Job details
Here’s how the job details align with your profile.
Pay

$54,000–$91,000 a year
 
Location
Toronto, ON M5J 2H7•Hybrid work
 
Full 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:

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:

54,000/54 000 - 91,000/91 000
Job Category:

Business Analysis - Process
Posting End Date:

25/07/2025 Read more