Integration Consultant

Sun Life; Kitchener; Hybrid; CAD 54,000 - 91,000; Full time

Job summary

A leading financial services provider located in Waterloo seeks an Integration Consultant to manage client projects and enhance data solutions. The ideal candidate will possess advanced Excel skills, coding knowledge in procedural languages, and strong customer service abilities. This role offers a salary range of CAD 54,000 to CAD 91,000 and flexible hybrid work options.

Benefits

Recognition as a 2024 Best Workplace in Canada

Mental health and well-being certification

Financial security benefits

Opportunities for digital innovation

Qualifications

• Knowledge of Group Retirement products and processes.
• Understanding of plan setup and member administration.
• Experience with software development lifecycle and methodologies.
• Bilingualism (French and English) required for Quebec.

Responsibilities

• Work with clients to understand demographic and payroll file requirements.
• Coordinate data extracts and transfers with clients' representatives.
• Apply project management techniques throughout the software development lifecycle.

Skills

Customer service skills

Advanced Microsoft Excel skills

Collaborative approach

Analytical skills

Coding skills in C/Java

Tools

IBM Sterling B2B Integrator

SQL

XML and parsers

Job description

Join to apply for the Integration Consultant role at Sun Life.

2 days ago Be among the first 25 applicants.

Join to apply for the Integration Consultant role at Sun Life.

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 clients and internal business partners to understand plan design and document requirements related to demographic, contribution, and/or payroll files.
• Identify gaps between client requests and Sun Life’s standards.
• Coordinate data extracts and transfers with client’s technical representatives.
• Apply project management techniques: create plans, lead meetings, influence stakeholders, document progress, and provide updates.
• Troubleshoot client file issues with internal support.
• Build data file maps using IBM Sterling B2B Integrator.
• Lead data file implementation through all software development lifecycle stages.

Production support (15%)

• Support internal teams with data file inquiries.
• Act as subject matter expert for data file troubleshooting.

Best practices and team development (10%)

• Collaborate to improve processes and documentation.
• Train team members on new or updated processes.
• Follow team workflows and standards.

What do you need to succeed?

• Knowledge of Group Retirement products and processes.
• Understanding of plan setup and member administration.
• Experience with software development lifecycle and methodologies.
• Advanced Microsoft Excel skills.
• Strong customer service skills.
• Understanding of the impact of work on other teams.
• Ability to work under pressure.
• Collaborative, analytical, solutions-oriented approach.
• Coding skills in procedural languages (e.g., C, Java).
• Knowledge of XML and parsers.
• Bilingualism (French and English) required for Quebec.

Assets

• Experience with internet technologies (FTP, web).
• Knowledge of database schemas, SQL, ETL.
• Experience with IBM Sterling B2B Map Editor and data formats (EDI, XML).

What’s in it for you?

• Recognition as a 2024 Best Workplace in Canada.
• Certification for mental health and well-being.
• Development aligned with our purpose: helping clients and employees.
• Financial security benefits.
• Opportunities for digital innovation.

The salary range is CAD 54,000 to CAD 91,000, depending on location and experience. Sun Life offers flexible hybrid work options. We value diversity and inclusion, welcoming applicants from all backgrounds. Persons with disabilities may request accommodations during the application process. Only shortlisted candidates will be contacted.

Application deadline: August 20, 2025.