Integration Consultant
Sun Life
full-time
Posted on:
Location Type: Hybrid
Location: Waterloo • Canada
Visit company websiteExplore more
Salary
💰 CA$58,000 - CA$93,000 per year
About the role
- 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
Requirements
- 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
- 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.
Benefits
- Access to short-term assignments or ‘Gigs’ across the organization, to help you develop new skills and connections.
- A collaborative and interactive team environment
- Charitable giving through our You Give, We Give program lets you give back to your community – and in many cases, we’ll match your contributions.
- Care Days available for self-care or care of others (i.e., family or others you may support) and Sick Days to support your well-being.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
advanced Excelpivot tablesVLOOKUPfile formatsxmlcsvtxtproject managementintegration development lifecycletranslation mapping
Soft Skills
client focused mindsetcustomer serviceself-motivatedproblem-solvingadaptabilityattention to detailquality focusteam playerrelationship buildingcommunication skills