Integration Consultant
Sun Life Financial
- Montreal, QC Metcalfe, ON
- $54,300-88,300 per year
- Permanent
- Full-time
- 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.)
- 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
- Participate as part of the client’s Sun Life implementation team and work with internal partners across the business and IT
- 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 the team and processes
- Influence the team direction through participation in strategic initiatives
- 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
- As this position is posted in several locations, we specify that bilingualism (French, English, both oral and written) is required for Quebec only for the frequent interactions with English and French-speaking colleagues or internal partners across Canada or worldwide
- Bilingualism, 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
- Fitness and wellness programs that help you balance work and life and enjoy a healthier lifestyle.
- Being a member of the Sun Life family, a group of people united by our Purpose: to help Clients and Employees achieve lifetime financial security and live healthier lives
- Ongoing learning, training, and coaching to grow your career
- We are honoured to be recognized as a 2022 Best Workplaces in Canada by Great Place to Work® Canada