Talent.com
Integration Consultant
Integration ConsultantSun Life • Ottawa, ON, CA
No longer accepting applications
Integration Consultant

Integration Consultant

Sun Life • Ottawa, ON, CA
7 days ago
Job type
  • Full-time
Job description

Overview

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

Client Data Solutions (CDSS) in Group & Wealth Operations supports Group Benefit clients with all their plan member data needs. We specialize in :

  • Inbound automated feeds from our clients into Sun Life (e.g. demographic data loads, GB HRIS feeds, etc.)
  • Outbound data files from Sun Life to our clients (e.g. payroll deduction files, etc.)

The team is currently growing our scope of services, building new partnerships with internal teams, and increasing our client-facing capabilities. We are looking for new team members with a drive to further strengthen this industry-leading team.

A major business objective is to change, optimize and improve the way we process and deliver data services to all lines of business. The evolution of Client Data Solutions (CDSS) is a fundamental shift in the way we view data as a valuable corporate asset. With that main objective in mind, the strategy is to build a service-oriented, center of excellence model, which focuses on client (internal and external) service, recognizing the importance of all stakeholders and a centralized data management strategy. Key drivers to this strategy are the resources and staffing model we put in place to execute and implement our plan. The focus is on resources who possess a combination of business knowledge and the ability to directly communicate and consult with our clients during new business implementations, client presentations and production support inquiries.

What will you do?

  • Meet with clients to review their data and system needs
  • Create Client specific data file feed solutions to help clients integrate with Sun Life systems
  • Participate as part of the client’s Sun Life implementation team and work with internal partners across the business and IT
  • Build data file maps using IBM Sterling B2B Integrator Map Editor software
  • Project Management : lead your data file implementation through all stages of the integration development lifecycle : requirements, solution design, development, testing, deployment, and monitoring
  • Identify gaps which exist between a client request and Sun Life's standards
  • Offer and influence alternative solutions that make sense from a business process and cost standpoint
  • Anticipate potential impacts to plan design, scope, process, timelines, and requirements which impact data solutions
  • Identify risks through client meetings and conversations relating to the processes, requirements, or group system capabilities
  • Resolve issues through suggesting options or negotiating with the parties involved to get to a compromised solution that meets our clients needs and still allows for accuracy of solutions, while keeping costs in check
  • Engage in the continuous improvement of the team and processes
  • Influence the team direction through participation in strategic initiatives
  • What do you need to succeed?

  • Advanced Excel skills (pivot tables, VLOOKUP formulas) is required
  • Good understanding of file formats (xml, .csv, .txt etc)
  • Project Management knowledge of integration development lifecycle : requirements gathering, solution design, development, testing, deployment and monitoring
  • Client focused mindset with superior customer service experience
  • Self-motivated with a strong work ethic and high degree of integrity
  • Continuous learner with problem-solving skills and the ability to adapt to change
  • Detailed, thorough and focused on quality while maintaining a high degree of accuracy
  • Team player, with high interest in building relationships and working in a cross-functional team environment
  • Excellent communication and presentation skills with ability to communicate with clients in both technical and non-technical terms
  • Coordinate action plans and major decisions with the leadership team
  • Assets

  • Bilingualism, with verbal and written communication skills in English and French (outside of Quebec)
  • University degree with at least 3 years of experience or an equivalent combination of education and experience
  • Understanding of Group Benefits, business processes and systems (OASIS)
  • Translation mapping experience with IBM Sterling B2B Integrator Map Editor
  • Reasons why should you join us under the sun

  • We’re proud to be recognized as a company with a 2025 Most Trusted Executive team by Great Place to Work® Canada
  • Access to short-term assignments or ‘Gigs’ across the organization, to help you develop new skills and connections.
  • A collaborative and interactive team environment
  • Charitable giving through our You Give, We Give program lets you give back to your community – and in many cases, we’ll match your contributions.
  • Care Days available for self-care or care of others (i.e., family or others you may support) and Sick Days to support your well-being.
  • 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 may use artificial intelligence to support candidate sourcing, screening, interview scheduling.

    We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

    Salary Range : 58,000 / 58 000 - 93,000 / 93 000

    Job Category : Business Analysis - Process

    Posting End Date : 12 / 02 / 2026

    #J-18808-Ljbffr

    Create a job alert for this search

    Integration Consultant • Ottawa, ON, CA

    Similar jobs
    Integration Consultant

    Integration Consultant

    Sun Life • Ottawa
    Full-time
    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 f...Show more
    Last updated: 7 days ago • Promoted
    Associate Dentist

    Associate Dentist

    Blooming Smile Dental • Kemptville, Canada
    Full-time +2
    Our Dental family is growing -We are seeking a dedicated associate dentist to join our dental practice.The ideal candidate will provide high-quality dental care to patients while working collaborat...Show more
    Last updated: 1 day ago • Promoted
    Data Integration Consultant for Client Solutions

    Data Integration Consultant for Client Solutions

    Sun Life • Ottawa
    Full-time
    A leading financial services company in Ottawa is seeking a Data Solutions Analyst to drive improvements in client data processing. This role involves meeting clients to assess their data needs, cre...Show more
    Last updated: 7 days ago • Promoted
    Senior Consultant, Cloud, Security & Infrastructure

    Senior Consultant, Cloud, Security & Infrastructure

    MNP • Ottawa H2B, ON, Canada
    Full-time
    Senior Consultant, Cloud, Security & Infrastructure.Join to apply for the Senior Consultant, Cloud, Security & Infrastructure role at. What do you think of when you hear the name MNP? We are more th...Show more
    Last updated: 30+ days ago • Promoted
    Travailleur.euse social.e pour le programme d'aide aux employés

    Travailleur.euse social.e pour le programme d'aide aux employés

    Servirplus • Val-des-Monts, Quebec, Canada
    Permanent
    Tu recherches un emploi dynamique rempli de défis stimulants ? Servirplus, entreprise privée spécialisée dans les services de santé et services psychosociaux, est l'entreprise idéale pour mettre to...Show more
    Last updated: 30+ days ago • Promoted
    Bilingual Technical Consultant (remote anywhere in Canada)

    Bilingual Technical Consultant (remote anywhere in Canada)

    SolidCAD • ottawa, ON, ca
    Remote
    Full-time
    Position Title : Bilingual Technical Consultant – Building Information Modeling (BIM) – (remote anywhere in Canada) FR translation below Show more
    Last updated: 13 hours ago • Promoted • New!
    IELTS Private Tutoring Jobs Chelsea

    IELTS Private Tutoring Jobs Chelsea

    Superprof • Chelsea, Canada
    Full-time +1
    Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more
    Last updated: 30+ days ago • Promoted
    Information Technology Private Tutoring Jobs Chelsea

    Information Technology Private Tutoring Jobs Chelsea

    Superprof • Chelsea, Canada
    Full-time +1
    Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more
    Last updated: 30+ days ago • Promoted
    Associate Director / Senior Consultant (Cost Planning), Infrastructure | Cost Consultancy | Ott[...]

    Associate Director / Senior Consultant (Cost Planning), Infrastructure | Cost Consultancy | Ott[...]

    Outpost Recruitment • Ottawa H2B, ON, Canada
    Full-time +1
    Leading cost, project management, risk advisory, and software firm has an immediate opening for several Associate Directors within the Cost Planning division in Toronto, Ottawa, and Vancouver.Assoc...Show more
    Last updated: 30+ days ago • Promoted
    Drawing Private Tutoring Jobs Chelsea

    Drawing Private Tutoring Jobs Chelsea

    Superprof • Chelsea, Canada
    Full-time +1
    Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more
    Last updated: 30+ days ago • Promoted
    Conseiller en architecture technologique spécialisé OpenShift

    Conseiller en architecture technologique spécialisé OpenShift

    freelance.ca • Gatineau, Canada
    Full-time
    Nous croyons fermement en une gestion saine et humaine, où la confiance, la compétence, et le plaisir de réussir ensemble sont au centre de nos valeurs. Nous vous offrons bien plus qu’un simple empl...Show more
    Last updated: 30+ days ago • Promoted
    Integration Specialist

    Integration Specialist

    Pivot + Edge • Outaouais
    Full-time +1
    Frequentis Group with headquarters in Vienna is an international supplier of communication and information systems for control centres with safety-critical tasks. Mission-critical control centres ar...Show more
    Last updated: 15 days ago • Promoted
    Hybrid Solutions Analyst : IT Integrations & Innovation

    Hybrid Solutions Analyst : IT Integrations & Innovation

    Norton Rose Fulbright • Ottawa
    Full-time
    A global law firm in Ottawa seeks an experienced Solutions Analyst to bridge the gap between business needs and technical solutions. This hybrid role involves analyzing requirements, designing IT so...Show more
    Last updated: 17 days ago • Promoted
    Enrollment Consultant

    Enrollment Consultant

    Right Management • gatineau, QC, ca
    Full-time +1
    The Enrollment Consultant is responsible for engaging and enrolling candidates into their Right Management service benefit program by providing a ‘best in class’ customer service ...Show more
    Last updated: 23 days ago • Promoted
    D365 CE Lead Consultant | Hybrid Malta | Relocation Support

    D365 CE Lead Consultant | Hybrid Malta | Relocation Support

    Black Pen Recruitment • Ottawa H2B, ON, Canada
    Full-time
    A leading recruitment agency seeks a Dynamics 365 Consultant to manage client delivery and provide innovative solutions.Ideal candidates will have robust experience in Microsoft Dynamics CRM, stron...Show more
    Last updated: 30+ days ago • Promoted
    VMS Implementation Consultant - Contingent Workforce Solutions - ottawa

    VMS Implementation Consultant - Contingent Workforce Solutions - ottawa

    SimplifyVMS • ottawa, on, ca
    Full-time
    Vendor Management System (VMS) solutions.AI, automation, and advanced workforce analytics.Global Head of Marketing & Demand Generation. SimplifyVMS as a market leader in.SimplifyVMS is seeking a dyn...Show more
    Last updated: 30+ days ago • Promoted
    Consultant

    Consultant

    Wellington Dupont Public Affairs • gatineau, qc, ca
    Full-time
    Our team is growing! Wellington Dupont Public Affairs (WD) is seeking a highly motivated, dynamic member to join our team as a. Executive Vice President of Federal Government Relations, this positio...Show more
    Last updated: 10 days ago • Promoted
    Independent Contractor - Shopper and Delivery Driver

    Independent Contractor - Shopper and Delivery Driver

    Instacart Shoppers • kemptville, ON, CA
    Part-time
    Start earning money fast and be your own boss.Instacart is a leading retail enablement platform that works with grocers and retailers to transform how people shop. Instacart’s platform helps people ...Show more
    Last updated: 6 days ago • Promoted