Integration Consultant

3 weeks ago


Waterloo, 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 of 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, custom reports, 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 manner in which we process and deliver data services to all lines of business. The evolution of Client Data Solutions (CDSS) is a fundamental shift in the manner in which 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 personalized 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** software
- Design "big picture" strategic data processing solutions and flows that solve business challenges
- Lead your data file implementation through all stages of the software development lifecycle: requirements, solution design, development, testing, deployment and monitoring
- Identify gaps which exist between a client request and Sun Life's standards
- Offer alternatives and 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
- Interpret risks to conclude the impacts to the success of the implementation
- 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 XML structure, capabilities, XML parsers is required
- Thorough understanding of Group Benefits business processes and systems (OASIS and CHESS) is preferred
- Knowledge of Software development lifecycle: requirements gathering, solution design, development, testing, deployment and monitoring as well as Software Development Methodologies (Agile, Iterative, Waterfall)
- 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
- Coding Skills with any procedural programming languages (C, C++, Java, Pascal, BASIC)
- 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
- Successfully solve client issues thorough an understanding of data management standards
- Coordinate action plans and major decisions with the leadership team
- Advanced level of English and French required for Quebec applican



  • Waterloo, Ontario, Canada ROSS Full time

    At ROSS, a team of People Specialists helping companies align their People Strategy with their business growth, we are seeking a skilled Technical Integration Consultant to join our team. This exciting opportunity will allow you to utilize your knowledge of software and industry-standard protocols to successfully implement and integrate healthcare...


  • Waterloo, Canada Region of Waterloo Full time

    **Our Story**: Committed to fostering opportunities for current and future generations, the Region of Waterloo is an inclusive, thriving and sustainable region of connected rural and urban communities with global reach. Our mission is to serve, engage and inspire, by delivering quality services to a diverse population of 630,000+, while creating a healthy,...

  • Sales Consultant

    8 months ago


    Waterloo, Canada Parkway Ford Full time

    **Parkway Ford **is seeking a **Sales Consultant** to join our team of customer focused professionals within our high volume and process-driven dealership. **Purpose/Summary of Position**: This role is responsible for providing a consistently exceptional customer experience, following established processes and procedures for their role and achieving...

  • Consultant

    5 days ago


    Waterloo, Canada Open Text Corporation Full time

    **Consultant**: - Req id: 32389- Waterloo, ON, CA Richmond Hill, ON, CA**OPENTEXT - THE INFORMATION COMPANY** As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management. The Opportunity: You...

  • Sales Consultant

    2 weeks ago


    Waterloo, Canada Parkway Ford Full time

    If you enjoy interacting with people and working in a fun, fast-paced, performance driven environment, we would like to talk to you! A career in sales can be very rewarding, the average income for a Sales Consultant at Parkway Ford was $110,000K last year. Parkway Ford is growing and is looking for full-time Sales Consultants to join our team! Parkway Ford...

  • Sales Consultant

    2 months ago


    Waterloo, Canada Forbes GM Full time

    **Forbes GM **is seeking a **Sales Consultant** to join our team of customer focused professionals within our high volume and process-driven dealership. **Purpose/Summary of Position**: The Sales Consultant serves as a guide to facilitate the customer vehicle buying experience. They conduct the interview to discover customer preferences, needs, and buying...

  • IT Consultant

    4 months ago


    Waterloo, Canada PeaceWorks Full time

    **About Us** PeaceWorks Technology Solutions is not your typical technical organization. We're a unique blend of strong technical expertise and unwavering commitment to social justice, community, and integrity. As proud B Corp pioneers in Canada, we operate as a worker-owned cooperative, emphasizing the value of staff and clients as crucial partners in our...


  • Waterloo, Canada TeccWeb Full time

    **TeccWeb **is growing and looking for both part-time and full-time Epicor Consultants. **Epicor Implementation Consultant** TeccWeb is an Epicor Service Partner comprised of a team of experts in Epicor ERP, Information Technology, Database Development, Program Customization, SSRS, Crystal Reports, Business Re-engineering and Employee Training providing...


  • Waterloo, 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...


  • Waterloo, Canada TeccWeb Full time

    **Job** Description** TeccWeb is an Epicor Service Partner comprised of a team of experts in Epicor ERP, Information Technology, Database Development, Program Customization, SSRS, Crystal Reports, Business Re-engineering and Employee Training providing enterprise resource planning (ERP) solutions to mid-market companies around the world. Our experts come...


  • Waterloo, Canada TeccWeb Full time

    **TeccWeb **is growing and looking for both part-time and full-time Epicor Consultants. TeccWeb is an Epicor Service Partner comprised of a team of experts in Epicor ERP, Information Technology, Database Development, Program Customization, SSRS, Crystal Reports, Business Re-engineering and Employee Training providing enterprise resource planning (ERP)...

  • Sales Consultant

    2 weeks ago


    Waterloo, Canada Raffi Jewellers Inc. Full time

    **Job description** Raffi Jewellers is home to the most prestigious luxury brands in the world. Whether commemorating a special event, expressing love or admiration, or building a personal collection, our guests come to us for the perfect piece. We are honoured to play a small role and do everything we can to assist our clients in these DEFINING...

  • Sales Consultant

    4 months ago


    Waterloo, Canada Raffi Jewellers Inc. Full time

    **Job description** Raffi Jewellers is home to the most prestigious luxury brands in the world. Whether commemorating a special event, expressing love or admiration, or building a personal collection, our guests come to us for the perfect piece. We are honoured to play a small role and do everything we can to assist our clients in these DEFINING...


  • Waterloo, Canada Manulife Full time

    **_Are you looking for a supportive, collaborative workplace with great teams and inspiring leaders? You’ve come to the right place. We’re looking for ambitious people who share our values and want to make every day better for people around the world. If this sounds like you, and the career below sounds exciting, we’d like to hear from you....

  • Consultant

    3 weeks ago


    Waterloo, Canada opentext Full time

    **OPENTEXT - THE INFORMATION COMPANY** As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management. The Opportunity: You are great at: Supporting large-scale enterprise system implementations...


  • Waterloo, Canada Equitable CA Full time

    At Equitable, we realize that your work life is not just about performing a job; it's about being part of a workplace that helps you grow and reach your full potential. Within our friendly and collaborative work environment, we recognize that the key to our growth and success is a dedicated, motivated and client-responsive staff. Join Equitable...


  • Waterloo, Canada TeccWeb Full time

    **Job** Description** TeccWeb is an Epicor Service Partner comprised of a team of experts in Epicor ERP, Information Technology, Database Development, Program Customization, SSRS, Crystal Reports, Business Re-engineering and Employee Training providing enterprise resource planning (ERP) solutions to mid-market companies around the world. Our experts come...


  • Waterloo, Canada TeccWeb Full time

    **TeccWeb **is growing and looking for both part-time and full-time Epicor Consultants. TeccWeb is an Epicor Service Partner comprised of a team of experts in Epicor ERP, Information Technology, Database Development, Program Customization, SSRS, Crystal Reports, Business Re-engineering and Employee Training providing enterprise resource planning (ERP)...


  • Waterloo, Canada Plum Full time

    With our recent round of growth funding, we are looking to add a brand new Enterprise Solution Consultant to our current CX team of five. Reporting to the Director of Customer Experience, you’ll be a customer facing technical team member. You will collaborate with a variety of internal teams from Engineering, Product, Sales, and Customer Success through to...

  • Business Consultant

    3 days ago


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