Integration Consultant

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 and Group Retirement Services 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

**What will you do?**

**_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 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 do you need to succeed?**
- Knowledge of Group Retirement products and processes is required
- Knowledge of plan setup and member administration
- Knowledge of software development lifecycle: requirements gathering, solution design, development, testing, deployment and monitoring as well as software development methodologies (Agile, Iterative, Waterfall)
- Advanced level of skills in Microsoft Excel
- Strong customer service skills
- Understanding of the “big picture” and downstream impact of work on other Operations teams
- Ability to work under pressure and meet quick turnaround times
- Collaborative, analytical and solutions-oriented
- Coding Skills with any procedural programming languages (C, C++, Java, Pascal, BASIC)
- Good understanding of XML structure, capabilities, XML parsers
- As this position is posted in several locations, we specify that bilingualism (French, English, both oral and written) is required **for Quebec only** as the position reports to a unilingual English-speaking manager outside Quebec.

**Assets**
- 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)

**What’s in it for you?**
- We are proud to be on the **2024 Best Workplaces in Canada list** by Great Place to Work.
- We are thrilled to be recognized by **Excellence Canada** with their top-level certification, the **Canada Order of Excellence for Mental Health at Work**®, for prioritizing employee well-being, fostering a positive work culture, and achieving excellence in mental health.
- Work and professional development that is united by our Purpose: to help Clients and Employees achieve lifetime financial security and live healthier lives
- Pension, stock and savings programs to help build and enhance your future financial security
- Be part of our continuous improvement journey in developing the next greatest digital enterprise experience.

LI-Hybrid

We are proud to be a hybrid organization that offers our employees the choice and flexibility to work from both the office and virtually based on the needs of the business, our Clients and you Several work options are available and can be discusse