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 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
- Advanced level of English and French required for Quebec applicants - interactions with English-speaking customers or partners

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

**What’s in it for you?**
- Fitness and wellness programs that help you

  • Business Integration Manager

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

  • Supervisor, Quality Assurance

    4 weeks ago

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

  • Integration Management- M&A

    5 days ago

    Waterloo, Canada Descartes Systems Group Full time

    Descartes Unites the People and Technology that Move the World The need for efficient, secure, and agile supply chains and logistics operations has become ever more critical and complex. By combining innovative technology, powerful trade intelligence and the reach of our network, Descartes helps get goods, information, transportation assets, and people...

  • Sales Consultant

    4 weeks 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...

  • EDI Consultant

    1 month ago

    Waterloo, Canada CB Canada Full time

    EDI Consultant Procom is seeking an EDI Consultant for our large enterprise client in the software space.EDI Consultant Job DetailsThe EDI Consultant team member will work on for-fee product implementations, upgrades, or integration projects. Expertise and work efforts are entirely focused on proprietary software products. Duties may be performed remotely...

  • EDI Consultant

    4 weeks ago

    Waterloo, Canada CB Canada Full time

    EDI Consultant Procom is seeking an EDI Consultant for our large enterprise client in the software space.EDI Consultant Job DetailsThe EDI Consultant team member will work on for-fee product implementations, upgrades, or integration projects. Expertise and work efforts are entirely focused on proprietary software products. Duties may be performed remotely...

  • Jira Consultant

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

  • Career Consultant Ii

    2 weeks ago

    Waterloo, Canada Wilfrid Laurier University Full time

    **Date**:Apr 23, 2024 **Location**: Waterloo, CA **Company**:Wilfrid Laurier University **Department**: Office of the VP Teaching&Learning **Job Type**: Limited Term **Full-time/Part-time**: Full Time (>=1249 hrs/year) **Campus**: Waterloo **Reports to**:Associate Director, Career Development & External Relations **Employee Group**:...

  • Epicor Implementation Consultant

    3 weeks ago

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

  • Infrastructure Data Integration Support

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

  • Immigration Consultant

    1 month ago

    Waterloo, Canada University of Waterloo Full time

    Overview Term: 18 Months and 12 months The Immigration Consultant is accountable to the Manager, Immigration Consulting, for the delivery of professional legal advising with a focus on Immigration, Refugees and Citizenship Canada (IRCC)’s International Student Program (ISP) for international students and their spouses, partners, and dependents....

  • Immigration Consultant

    4 weeks ago

    Waterloo, Canada University of Waterloo Full time

    Overview Term: 18 Months and 12 months The Immigration Consultant is accountable to the Manager, Immigration Consulting, for the delivery of professional legal advising with a focus on Immigration, Refugees and Citizenship Canada (IRCC)’s International Student Program (ISP) for international students and their spouses, partners, and dependents....

  • Immigration Consultant

    2 weeks ago

    Waterloo, Canada University of Waterloo Full time

    Overview Term: 1 year The Immigration Consultant is accountable to the Manager, Immigration Consulting, for the delivery of professional legal advising with a focus on Immigration, Refugees and Citizenship Canada (IRCC)’s International Student Program (ISP) for international students and their spouses, partners, and dependents. The primary role...

  • Change Management Consultant

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

  • Business Analyst Consultant

    2 weeks ago

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

  • HR Consultant II

    3 weeks ago

    Waterloo, Canada Compunnel Full time

    Description The Global HR Employee Experience Design team is seeking a highly skilled and experienced Senior HR Technologist to join our team. Seeking candidates that have a well balanced previous work experience with Workday configuration (4 plus years). Reporting to the Director, Global Experience Solutions team, the Senior HR Technologist will oversee...

  • Luxury Sales Consultant

    3 weeks ago

    Waterloo, Canada Raffi Jewellers Inc. Full time

    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 MOMENTS. Our Sales Consultants...

  • Luxury Sales Consultant

    4 weeks ago

    Waterloo, Canada Raffi Jewellers Inc. Full time

    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 MOMENTS. Our Sales Consultants...

  • Underwriting Consultant

    2 weeks ago

    Waterloo, Canada Manulife Full time

    We are a leading financial services provider committed to making decisions easier and lives better for our customers and colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. To help us stand out, we help you step up, because when colleagues are healthy, respected and...

  • Bilingual Proposal Consultant, Group Benefits

    2 weeks ago

    Waterloo, Canada Manulife Full time

    **_We are a _**_leading financial services provider committed to making decisions easier and lives better for our customers and _**_colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. _**_To help us stand out, we help you step up, because when colleagues are healthy,...