Integration Consultant

Sun Life Québec

Montreal

Offre publiée le 2025-07-21

Postuler

Join to apply for the Integration Consultant role at Sun Life Québec

1 day ago Be among the first 25 applicants

Join to apply for the Integration Consultant role at Sun Life Québec

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.

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

Seniority level

Not Applicable

Employment type

Full-time

Job function

Engineering and Information Technology

Industries

Financial Services and Insurance

Referrals increase your chances of interviewing at Sun Life Québec by 2x

Senior Consultant / Manager, Workday - Integration

International Recruitment : SAP Functional Analyst (SD, PM, FICO, EWM) - Bilingual

SAP BTP Integration Suite (Architect / Developer)

Senior Technical Consultant / Manager, Microsoft - Power Platform

Montreal, Quebec, Canada PKR110,000.00-PKR140,000.00 2 weeks ago

Senior Murex Integration Developer (Contract - Canada)

EDI & ERP Integration Specialist - 2-Year Contract

Robotics Deployment Engineer – Linux & Hardware Integration (Hybrid | Montreal)

Senior Technical Consultant / Manager, Senior ServiceNow Developer

Senior Software Engineer, Full Stack - Integration Squad

Senior Full Stack Developer - Vehicle Grid Integration (Quebec)

Montreal, Quebec, Canada $140,000.00-$170,000.00 1 day ago

Show Control and Video Project Engineer (Réf : 19-13 S)

St-Bruno-de-Montarville, Quebec, Canada 11 months ago

Montreal

2025-08-17

https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQUmyBnNmW5TAn6UsZ-5snSLmlALv8TOClYnm1rtsMK6rP4re8hvUUhkbdehgo&s