Integration Consultant - Waterloo, Canada - Sun Life

Sun Life

Verified Company

Waterloo, Canada

3 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

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 transferin 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 solutionsoriented
Selfstarter, 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 Internetbased technologies (e.g. FTP, secure websites 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, variablelengthdelimited, 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/ ,400/87 400

Job Category:

Business Analysis - Process

Posting End Date:

16/11/2023