Integration Consultant

2 weeks ago

Ottawa, Canada Sun Life 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 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.

Client Data Solutions (CDSS) in Group & Wealth Operations supports both Group Benefit and Group Retirement Services 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
- Work with internal partners across the business and IT
- Participate as part of the client’s Sun Life implementation team
- 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 your 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
- As this position is posted in several locations, we specify that bilingualism (French, English, both oral and written) is required **for Quebec only** for the frequent interactions with English and French-speaking colleagues or internal partners across Canada or worldwide.

**What would be nice to have?**
- 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

**What’s in it for you?*

  • MECM/SCCM Integrator

    3 days ago

    Ottawa, Canada Hamilton Barnes Associates Limited Full time

    Are you ready to be part of an extraordinary digital transformation journey?You'll have the opportunity to join a prominent French IT Consultancy as an MECM/SCCM Integrator, contributing to a 7-year program that is revolutionizing the network infrastructure of a valued client.This initial 6-month contract comes with the potential for long-term extensions,...

  • MECM/SCCM Integrator

    2 days ago

    Ottawa, Canada Hamilton Barnes Associates Limited Full time

    Are you ready to be part of an extraordinary digital transformation journey?You'll have the opportunity to join a prominent French IT Consultancy as an MECM/SCCM Integrator, contributing to a 7-year program that is revolutionizing the network infrastructure of a valued client.This initial 6-month contract comes with the potential for long-term extensions,...

  • MECM/SCCM Integrator

    2 days ago

    Ottawa, Canada Hamilton Barnes Associates Limited Full time

    Are you ready to be part of an extraordinary digital transformation journey?You'll have the opportunity to join a prominent French IT Consultancy as an MECM/SCCM Integrator, contributing to a 7-year program that is revolutionizing the network infrastructure of a valued client.This initial 6-month contract comes with the potential for long-term extensions,...

  • Integrated Health Care

    1 week ago

    Ottawa, Canada Pinecrest Queensway Community Health Centre Full time

    Integrated Health Care - Director of Integrated Healthcare 1365 Richmond Rd, Ottawa, ON K2B 6R7, Canada Req #154 Tuesday, May 7, 2024 Position Title: Director, Integrated Healthcare Employment Type: Regular Full Time Pay Scale: $ 52.820 to $62.141 per hour Job Summary:The Director, Integrated Healthcare, in partnership with the senior leadership team,...

  • Manager, Esg Integration

    7 days ago

    Ottawa, Canada Canada Post - Postes Canada Full time

    Job Requisition Id: 167894 Business Function: Corporate and Government Affairs Primary City: Ottawa Other Location(s): Anywhere in Canada Province: Ontario Employment Type: Full-Time Employment Status: Permanent Language Requirement: English Essential Employee Class and Level: CPMGA02 Number of Vacancies 1 Job Closing Date (MM/DD/YYYY): 04/27/2023 Reporting...

  • Integrated Health Care

    1 week ago

    Ottawa, Canada Pinecrest Queensway Community Health Centre Full time

    Job Summary : The Director, Integrated Healthcare, in partnership with the senior leadership team, leads and oversees the Primary Health Care team, Mental Health and new health care programs that are aligned with the health equity and the social determinants of health. The Director of Integrated Healthcare is responsible for working with teams to...

  • Senior Eam Consultant

    4 days ago

    Ottawa, Canada 21Tech, LLC Full time

    21Tech, LLC. is seeking a **Senior EAM Consultant** to join our company. Our Team has broad experience implementing and maintaining Hexagon/Infor EAM solution in public sector. 21Tech, LLC is the key go-to partners of Hexagon/Infor in Public Sector across US and Canada. 21Tech's consultants are not just experts in the field of Asset Management, but they are...

  • Director of Integrated Healthcare

    2 days ago

    Ottawa, Canada Pinecrest Queensway Community Health Centre Full time

    1365 Richmond Rd, Ottawa, ON K2B 6R7, Canada Req #154 Tuesday, May 7, 2024 Position Title: Director, Integrated Healthcare Employment Type: Regular Full Time Pay Scale: $ 52.820 to $62.141 per hour Job Summary:The Director, Integrated Healthcare, in partnership with the senior leadership team, leads and oversees the Primary Health Care team, Mental...

  • Director of Integrated Healthcare

    2 days ago

    Ottawa, Canada Pinecrest Queensway Community Health Centre Full time

    1365 Richmond Rd, Ottawa, ON K2B 6R7, Canada Req #154 Tuesday, May 7, 2024 Position Title: Director, Integrated Healthcare Employment Type: Regular Full Time Pay Scale: $ 52.820 to $62.141 per hour Job Summary: The Director, Integrated Healthcare, in partnership with the senior leadership team, leads and oversees the Primary Health Care team,...

  • Director of Integrated Healthcare

    23 hours ago

    Ottawa, Canada Pinecrest Queensway Community Health Centre Full time

    1365 Richmond Rd, Ottawa, ON K2B 6R7, Canada Req #154 Tuesday, May 7, 2024 Position Title: Director, Integrated Healthcare Employment Type: Regular Full Time Pay Scale: $ 52.820 to $62.141 per hour Job Summary: The Director, Integrated Healthcare, in partnership with the senior leadership team, leads and oversees the Primary Health Care...

  • Integrated Health Care

    6 days ago

    Ottawa, ON, Canada Pinecrest-Queensway Community Health Centre Full time

    Integrated Health Care - Director of Integrated Healthcare 1365 Richmond Rd, Ottawa, ON K2B 6R7, Canada Req #154 Tuesday, May 7, 2024 Position Title: Director, Integrated Healthcare Employment Type: Regular Full Time Pay Scale: $ 52.820 to $62.141 per hour Job Summary: The Director, Integrated Healthcare, in partnership with the senior...

  • Project Manager

    3 weeks ago

    Ottawa, Canada Smith + Andersen Full time

    Role: Project Manager - Intelligent Integrated Systems Location: Ottawa, ON Job Type: Hybrid – WFH + In Office Who We Are Smith + Andersen is a trusted, Canadian, multi-disciplinary engineering firm with ten office locations in five provinces and approximately 700 employees. At Smith + Andersen our employees contribute to some of the most...

  • Senior Security Engineer

    2 days ago

    Ottawa, Canada Hamilton Barnes Associates Limited Full time

    Ever dreamt of shaping the future of IT security?You'll have the opportunity to lead as a Senior Security Engineer, contributing to the development and implementation of cutting-edge IT security concepts, with a specific focus on infrastructure and perimeter security.You'll:You'll be at the forefront of consulting, conceptualizing, and implementing...

  • Senior Security Engineer

    2 days ago

    Ottawa, Canada Hamilton Barnes Associates Limited Full time

    Ever dreamt of shaping the future of IT security? You'll have the opportunity to lead as a Senior Security Engineer, contributing to the development and implementation of cutting-edge IT security concepts, with a specific focus on infrastructure and perimeter security. You'll: You'll be at the forefront of consulting, conceptualizing, and implementing...

  • Integration Specialist

    3 weeks ago

    Ottawa, Canada Emtec Full time

    Position Description The Integration Consultant must have a wide range of knowledge with ITSM applications. Emtec is placing an emphasis on quality soft skills, particularly around communication and generating a sense of confidence with new or existing clients. Emtec has a collaborative environment and you are encouraged to work with your colleagues...

  • Jewellery Consultant

    3 days ago

    Ottawa, Canada Peoples Jewellers Full time

    Peoples Jewellers is a people-first company, and we recognize that our jewellery consultants are every bit as dynamic and brilliant as the jewellery we offer. They are the reason Peoples Jewellers has become the largest retailer of fine jewellery in Canada, with nearly 150 locations from the Maritimes to British Columbia. Peoples Jewellers is part of Signet...

  • Sales Consultant

    3 weeks ago

    Ottawa, Canada HairClub Full time

    As a Sales Consultant, you are the first face-to-face contact in the Centers with our potential members to help them find the right solution that fits their needs and lifestyle. By building rapport and asking the right questions in a consultative setting, you can help many people with a hair solution that fits their wants and needs. We provide a consistent...

  • Cost Consultant

    2 weeks ago

    Ottawa, Canada Turner & Townsend Group Full time

    Do you want to be part of our successful Real Estate team supporting top clients forTurner & Townsendin Ottawa?We are hiring an ambitious and forward thinking Cost Consultantto support a client on a major Program in OttawaAt Turner & Townsend we’re passionate about making the difference. That means delivering better outcomes for our clients, helping our...

  • Cost Consultant

    2 weeks ago

    Ottawa, Canada Turner & Townsend Group Full time

    Do you want to be part of our successful Real Estate team supporting top clients forTurner & Townsendin Ottawa?We are hiring an ambitious and forward thinking Cost Consultantto support a client on a major Program in OttawaAt Turner & Townsend we’re passionate about making the difference. That means delivering better outcomes for our clients, helping our...

  • Cost Consultant

    2 weeks ago

    Ottawa, Canada Turner & Townsend Group Full time

    Do you want to be part of our successful Real Estate team supporting top clients forTurner & Townsendin Ottawa?We are hiring an ambitious and forward thinking Cost Consultantto support a client on a major Program in OttawaAt Turner & Townsend we’re passionate about making the difference. That means delivering better outcomes for our clients, helping our...