Integration Consultant

2 weeks 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.

**Location**: Hybrid

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

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

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

**Reasons why should you join

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

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

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

  • Technical Integration Expert for SAP SuccessFactors

    1 week ago

    Ottawa, Ontario, Canada IBM Computing Full time

    About the RoleWe are seeking a highly skilled Technical Integration Expert to join our SAP SuccessFactors consulting practice in Canada. As part of our team, you will collaborate with top national and international clients to design, build, and test integrations between SAP SuccessFactors and various systems and 3rd party providers.Key ResponsibilitiesLead...

  • Integrated Health Care

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

  • Workplace Strategist, Integration

    2 weeks ago

    Ottawa, Canada BGIS Full time

    **Who We Are** **SUMMARY** The **Workplace Strategist, Integration **consults with clients and organizations to ensure coordination of communications, connections, direction and outcome. The workplace strategist is the connector who is poised to identify key opportunities and correlations, and acts ensure the necessary links and adjustments are made. The...

  • Integrated Testing Coordinator

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

    4 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

    4 weeks 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

    1 month 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...

  • Workplace Strategist, Integration

    2 days ago

    Ottawa, Canada BGIS Full time

    Who We Are BGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6,500 globally, we relentlessly focus on enabling innovation through the services we deliver, while actively looking for new opportunities that will enable innovation for our clients’ businesses. Globally, we manage over...

  • Workplace Strategist, Integration

    1 week ago

    Ottawa, Canada BGIS Full time

    Who We Are BGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6,500 globally, we relentlessly focus on enabling innovation through the services we deliver, while actively looking for new opportunities that will enable innovation for our clients’ businesses. Globally, we manage over...

  • Government Relations Consultant

    4 weeks 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...

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

  • 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

    6 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! ...

  • Embedded Software Integration Expert

    4 weeks 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

    6 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

    4 weeks 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,...