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.

**About Client Data Solutions**

Client Data Solutions (CDSS) in Group & Wealth Operations supports both Group Benefit (GB) and Group Retirement Services (GRS) 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

**Role Summary**

**_ Client project management (75%)_**
- Work with Client’s and internal business partners to understand plan design and document requirements related to demographic, contribution and/or payroll files
- Identify gaps which exist between a Client’s request and Sun Life’s standards
- Work with the Client’s technical representatives to coordinate extracts and transfer of plan member data from and/or to the appropriate Sun Life systems
- Troubleshoot client file issues, with the support of internal business partners
- Build data file maps using **IBM Sterling B2B Integrator** software
- Lead your data file implementation through all stages of the software development lifecycle: requirements, solution design, development, testing, deployment and monitoring

**_ Production support (15%)_**
- Provide support to internal business partners with respect to existing demographic, contribution or payroll file related inquiries

**_ Best practices and team development (10%)_**
- Collaborate continuously with team members to identify and implement process improvements and best practices, in order to enhance efficiency and productivity
- Create documentation of business processes and provide training on new or enhanced processes, when required
- Adhere to the team processes and workflow management

**What will you need to succeed?**
- Knowledge of the GRS business, products and processes
- Knowledge of plan setup and member administration
- Understanding of the “big picture” and downstream impact of work on other Operations teams
- Ability to work under pressure and meet quick turnaround times
- Strong customer service skills
- Collaborative, analytical and solutions-oriented
- Self-starter, skilled in time management and prioritizing work
- Advanced level of skills in Microsoft Excel
- Good understanding of XML structure, capabilities, XML parsers is required Knowledge of Software development lifecycle: requirements gathering, solution design, development, testing, deployment and monitoring as well as Software Development Methodologies (Agile, Iterative, Waterfall)
- Coding Skills with any procedural programming languages (C, C++, Java, Pascal, BASIC)

**Unique Requirements**
- Bilingual, with verbal and written communication skills in English and French (asset)
- Hybrid workstyle: 2 days per week in office
- Experience with Internet-based technologies (e.g. FTP, secure web-sites etc.)
- Good understanding of database schemas and related concepts; SQL scripting; ETL - Extract, Transform, Load methodology
- Translation mapping experience with IBM Sterling B2B Integrator Map Editor to map documents in the following data formats: Electronic Data Interchange (EDI), positional, variable-length-delimited, Extensible Markup Language (XML)
- Reliability Status: Must be able to obtain Reliability Status through the Government of Canada before a start date can be confirmed (includes a background check with fingerprinting by the RCMP)

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

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

**Salary Range**:
53,800/53 800 - 87,400/87 400

**Job Category**:
Business Analysis - Process

**Posting End Date**:
16/11/2023



  • 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

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

  • Sales Consultant

    4 weeks ago


    Waterloo, Canada Constant Contact Full time

    At Constant Contact, we are seriously awesome people who take ownership and make an impact by operating with the mindset, integrity and courage of a small business owner. _There's something so profoundly rewarding about knowing that your work is empowering people everywhere to pursue their dreams_. Here, we all play an integral part in helping business...


  • Kitchener-Waterloo, Canada All Points Relocation Full time

    Are you passionate about Kitchener-Waterloo and its surrounding areas? Are you looking for an engaging part-time job or an appealing supplemental income? Do you have an enthusiasm for helping others? All Points Relocation is a dynamic, full-service relocation management company that provides domestic and international relocation assistance to corporate...


  • 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, ON, Canada Ontario Teachers Insurance Plan Full time

    Contract Communications Join us as we grow our way into a future that reimagines what it means to deliver meaningful benefits support and service. The Communication Program Consultant is responsible for coordinating, developing and implementing internal communication strategies and tactics such as videos, intranet content, employee emails, program...


  • Waterloo, Canada AltaML Full time

    About The The GovLab.aiWe transform the way you think about applied AI. Teams are structured around projects for the public sector, guided by the Project Delivery Manager, Product Owner, and Senior machine learning developers, to provide working models to support informed strategic decision-making around the use of key AI technologies in the public...

  • Testing Consultant

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


  • Waterloo, Canada OTIP Full time

    Company Description Who We Are With every job, there's always the question of “why”. Why join a company? Why be part of their mission? Here, the why is easy. It's because at some point, we've all needed someone there for us. At the OTIP Group of Companies (OGC), we believe that something special happens when employees feel valued for the work they do,...


  • Waterloo, Canada OTIP Full time

    Company Description Who We Are With every job, there's always the question of “why”. Why join a company? Why be part of their mission? Here, the why is easy. It's because at some point, we've all needed someone there for us. At the OTIP Group of Companies (OGC), we believe that something special happens when employees feel valued for the work they do,...


  • Waterloo, Canada OTIP Full time

    Company Description Who We Are With every job, there's always the question of “why”. Why join a company? Why be part of their mission? Here, the why is easy. It's because at some point, we've all needed someone there for us. At the OTIP Group of Companies (OGC), we believe that something special happens when employees feel valued for the work they do,...


  • Waterloo, Canada Ontario Teachers Insurance Plan Full time

    ContractDepartment: CommunicationsCompany DescriptionWho We AreWith every job, there’s always the question of “why”. Why join a company? Why be part of their mission? Here, the why is easy. It’s because at some point, we’ve all needed someone there for us.At the OTIP Group of Companies (OGC), we believe that something special happens when...


  • Waterloo, Canada Ontario Teachers Insurance Plan Full time

    ContractDepartment: CommunicationsCompany DescriptionWho We AreWith every job, there’s always the question of “why”. Why join a company? Why be part of their mission? Here, the why is easy. It’s because at some point, we’ve all needed someone there for us.At the OTIP Group of Companies (OGC), we believe that something special happens when...


  • Waterloo, Canada Ontario Teachers Insurance Plan Full time

    ContractDepartment: CommunicationsCompany DescriptionWho We AreWith every job, there’s always the question of “why”. Why join a company? Why be part of their mission? Here, the why is easy. It’s because at some point, we’ve all needed someone there for us.At the OTIP Group of Companies (OGC), we believe that something special happens when...


  • Waterloo, Canada University of Waterloo Full time

    Overview: As a member of the UWaterloolife team within the Associate Provost Students (APS) portfolio, this position is responsible for consultation, planning, implementation and evolution of communications plans with a focus on Campus Wellness (CW). Emphasis will be on collaboration both internally and externally to ensure health messages are...


  • Waterloo, Canada University of Waterloo Full time

    Overview A CTE Faculty Liaison provides expert advice to instructors, primarily in their Faculty, regarding teaching strategies, learning activities, course design, assessment methods, instructional innovations and the integration of appropriate and effective learning technologies into face-to-face and blended learning course designs. This role works...


  • Waterloo, Canada University of Waterloo Full time

    Overview: **Term: 14 Months** Reporting to the Associate Director, Marketing and Digital Sales the Content Marketing Specialist is a thought-leader and creative storyteller who plays a key role in the development and implementation of all activities associated with an integrated WatSPEED marketing and communications strategy. The incumbent is responsible...


  • Waterloo, Canada BlackBerry Full time

    Worker Sub-Type: Regular **Job Description**: BlackBerry is looking for a Security DevOps Specialist to join the Information Security Operations team. In this role, you will join an energetic group to work collaboratively to build and develop content to improve efficiency and effectiveness of our identification and detection capabilities. Your passion for...

  • Data Analyst

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


  • Waterloo, Canada Equitable Life of Canada Full time

    Senior Technology Architect, Enterprise Platforms Waterloo, ON, Canada Req #2213 Wednesday, April 17, 2024 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...