Integration Consultant

6 months ago

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

Client Data Solutions (CDSS) in Group & Wealth Operations supports both Group Benefit and Group Retirement Services clients with all their plan member data needs.

We specialize in:

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

The team is currently growing our scope of services, building new partnerships with internal teams, and increasing our client-facing capabilities. We are looking for new team members with a drive to further strengthen this industry-leading team.

A major business objective is to change, optimize and improve the way we process and deliver data services to all lines of business. The evolution of Client Data Solutions (CDSS) is a fundamental shift in the way we view data as a valuable corporate asset. With that main objective in mind, the strategy is to build a service-oriented, center of excellence model, which focuses on client (internal and external) service, recognizing the importance of all stakeholders and a centralized data management strategy. Key drivers to this strategy are the resources and staffing model we put in place to execute and implement our plan. The focus is on resources who possess a combination of business knowledge and the ability to directly communicate and consult with our clients during new business implementations, client presentations and production support inquiries.

**What will you do?**
- 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
- Work with internal partners across the business and IT
- Participate as part of the client’s Sun Life implementation team
- 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 your team and processes
- Influence the team direction through participation in strategic initiatives

**What do you need to succeed?**
- 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

**What would be nice to have?**
- 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

**What’s in it for you?**

  • Integration Consultant

    5 months ago

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

  • Automation Integrator

    3 weeks ago

    Ottawa, Canada Hamilton Barnes Associates Limited Full time

    Are you ready to be part of an extraordinary digital transformation journey?You'll have the opportunity to join a prominent French IT Consultancy as an MECM/SCCM Integrator, contributing to a 7-year program that is revolutionizing the network infrastructure of a valued client.This initial 6-month contract comes with the potential for long-term extensions,...

  • Workday Consultant

    2 months ago

    Ottawa, Canada MGIS Full time

    **Overview**: **Roles Available**: - **Workday HCM Consultants**: Experts in implementing and supporting Workday Human Capital Management modules such as Core HCM, Benefits, and Time Tracking. - **Workday Financial Management Specialists**: Specialists with deep knowledge in Workday Financials, including General Ledger, Accounts Payable/Receivable,...

  • Integrated Health Care

    5 months ago

    Ottawa, Canada Pinecrest Queensway Community Health Centre Full time

    **Position Title**: Director, Integrated Healthcare **Employment Type**: Regular Full Time **Pay Scale**: $52.820 to $62.141 per hour **Job Summary**: The Director, Integrated Healthcare, in partnership with the senior leadership team, leads and oversees the Primary Health Care team, Mental Health and new health care programs that are aligned with the...

  • IT Security Consultant

    7 months ago

    Ottawa, Canada Convergence Networks Full time

    IT Security Consultant SECURITY CONSULTING AND ASSESSMENT OTTAWA- Hybrid, on site and client visit Convergence Networks is one of North America’s leading managed service and managed security providers. We are a service company focused on helping clients leverage technology as a strategic tool and proactively protecting their business. We are fueled by...

  • Integrated Testing Coordinator

    5 months ago

    Ottawa, Canada AtkinsRéalis Full time

    **Integrated Testing Coordinator** **_ Are you looking for a company that works on major engineering projects all over the world? Do you want to make a difference by improving the daily lives of communities worldwide? Are you seeking to join an inclusive and diverse team that you can truly count on? You’ve come to the right place!_** **Come join us in...

  • Consult (IT)

    3 months ago

    Ottawa, Canada Cygnus Professionals Inc Full time

    Headquartered in New Jersey (U.S), Cygnus Professionals Inc. is a next generation global information technology Solution and Consulting company powered by strong management and leadership team with over 30 person years of experience. We strive to extend our presence across industries and geographies with our industry-focused business excellence.Cygnus’s...

  • Consulting - Junior Consultant Ottawa

    5 days ago

    Ottawa, Canada ATIS Elevator Inspections, LLC Full time

    The ATIS Group, with ATIS in the US and KJA in Canada, are the premier elevator and escalator consulting, management, and inspection businesses operating across North America. Our inspection services cover the US with more than 185 Qualified Elevator Inspectors (QEI). Our global team of industry veteran elevator and escalator consultants spans all of North...

  • Auto Sales Consultant

    3 weeks ago

    Ottawa, Canada Jim Keay Ford Full time

    **Join the Jim Keay Ford Lincoln Family as a Sales Consultant!** Jim Keay Ford Lincoln, a family-owned dealership with over 40 years in the Ottawa market, is looking for a motivated and results-driven **Sales Consultant** to join our high-performing team. If you’re passionate about cars and love helping customers find their perfect vehicle, we want to...

  • Government Relations Consultant

    6 days ago

    Ottawa, Canada StrategyCorp Inc. Full time

    StrategyCorp Ottawa is looking for a new **Government Relations Consultant **to join our team. **WHO WE ARE?** StrategyCorp is a consulting firm focussed on delivering integrated government relations, strategic communications, and management consulting strategies. From its offices in Toronto and Ottawa, StrategyCorp services clients across Canada and...

  • Service Consultant

    6 months ago

    Ottawa, Canada People Corporation Full time

    We are seeking a Service Consultant to join our team in Ottawa. The Service Consultant serves as the main point of contact between People Corporation and our clients. The Service Consultant will play an integral role in managing the implementation of new clients as well as providing top notch support to our existing clients. **The Service Consultant...

  • Integrated Testing Coordinator

    5 months ago

    Ottawa, Canada AtkinsRéalis Full time

    Job Description Integrated Testing Coordinator Are you looking for a company that works on major engineering projects all over the world? Do you want to make a difference by improving the daily lives of communities worldwide? Are you seeking to join an inclusive and diverse team that you can truly count on? You’ve come to the right place! ...

  • Senior Eam Consultant

    6 months ago

    Ottawa, Canada 21Tech, LLC Full time

    21Tech, LLC. is seeking a **Senior EAM Consultant** to join our company. Our Team has broad experience implementing and maintaining Hexagon/Infor EAM solution in public sector. 21Tech, LLC is the key go-to partners of Hexagon/Infor in Public Sector across US and Canada. 21Tech's consultants are not just experts in the field of Asset Management, but they are...

  • Beauty Consultant

    4 weeks ago

    Ottawa, Ontario, Canada Hudson's Bay Full time

    About the Role:We are seeking a skilled Beauty Consultant to join our team at Hudson's Bay. As a Beauty Consultant, you will be responsible for providing exceptional customer service and product knowledge to our clients.Key Responsibilities:Initiate service consultations by asking open-ended questions to learn the customer's preferences and needsBuild...

  • Embedded Software Integration Expert

    7 days ago

    Ottawa, Ontario, Canada QNX Software Systems Full time

    Job Summary:The Embedded Software Integration Expert role at QNX Software Systems involves delivering professional integration services and solutions for all QNX products. In this position, you will resolve complex technical issues and utilize innovative thinking in the development and delivery of solutions for customer issues.The Embedded Software...

  • Integration Specialist

    5 months ago

    Ottawa, Canada Emtec Applications Services Inc., a Bridgenext company Full time

    Company Overview: Bridgenext is a global digital consultancy that helps clients innovate with intention and realize their digital aspirations by creating digital products, experiences, and solutions around what real people need. Our global consulting and delivery teams facilitate highly strategic digital initiatives through digital product engineering,...

  • Building Systems Integration Specialist

    7 days ago

    Ottawa, Ontario, Canada EllisDon Full time

    Job DescriptionAs a Building Systems Integration Specialist at EllisDon, you will play a critical role in the design, procurement, implementation, and commissioning of building systems. This includes but is not limited to: Building Automation, Structured cabling, Converged networks, Digital Lighting, Access Control, CCTV, Intercoms, Power Metering,...

  • Data Consultant

    5 days ago

    Ottawa, Canada Assent Full time

    **Company Description** Assent is the leading solution for supply chain sustainability tailored for the world’s top-tier, sustainability-driven manufacturers. Hidden risks riddle supply chains, many of which weren't built with sustainability in mind. That's where we step in. With insights from experts, Assent is the tool manufacturers trust for...

  • Data Consultant

    5 months ago

    Ottawa, Canada Assent Full time

    Job DescriptionThe Data Consulting team specializes in ensuring customer success through effective communication and problem-solving to implement clean client data into our products and systems. Data Consultants play an integral role as trusted advisors, setting the foundation for program success through expert data consultation and knowledge...

  • Project Manager

    4 weeks ago

    Ottawa, Ontario, Canada Smith + Andersen Full time

    Job Title: Project Manager - Intelligent Integrated SystemsAbout the Role:We are seeking a highly skilled Project Manager to join our Intelligent Integrated Systems team at Smith + Andersen. As a Project Manager, you will be responsible for leading complex projects from initiation to completion, ensuring timely delivery, and exceeding client expectations.Key...