Support Engineer, Data & Analytics Operations

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.

Job Description:

Sr Support Engineer, Data& Analytics Operations (Cloud/Data Warehouse)

Welcome to the Application Operation Services (AOS) at Sun Life, where our focus is to provide a positive digital user experience that is seamless, available, and valuable for our Canadian and global business partners and clients.

The Data &Analytics team provides support for:

• On Premise applications, to maintain and support processes in multiple Data Warehouses, Business Intelligence, Data Integration applications
• In the Cloud technologies, utilizing AWS for Enterprise Data Lake (EDL)
• We are looking for a candidate that is deeply curious and possesses the keenness to learn, develop and execute with excellence

The Support Engineer on the Data & Analytics Operations team, is responsible for safeguarding our client’s data, by providing superior operational support both on premise and in the Cloud.

Essential skills

• Mainframe development experience is required to support the transition from project implementation to operational support
• Knowledge and experience with the tools to support several Data Warehouses (DW), from data ingestion to data consumption
• Technical and analytical abilities required to design, build, and maintain centralized repositories for historical and analytical data
• Ability to understand the code logic to analyze and troubleshoot data consumption issues for Sun Life clients as well as be able to fix or enhance code on a daily basis
• Be able to write complex SQL queries, joins, and stored procedures to manipulate and analyze data.
• Experience building and supporting ETL processes, data integration and pipelines
• Good business intelligence application experience to design, analyze, and format reports for clients
• Experience with Batch Operations including schedulers, failures and recovery
• Excellent analytical skills to dive into the processes we support to resolve complex data discrepancies or job failures 
• ITIL knowledge for incident, problem and change management policies and processes
• Create and maintain superb technical documentation that will help support our poly-skilled team
• Excellent communication skills to support Project Teams, Operation teams and vendors  
• Continuously monitor our environments to identify and implement operational improvement
• Posses an owner’s mindset which is critical to the success of the team

Education

If you have a background or education in Computer or Data Science, Engineering, Software Development or IT Application/Technical support, this role may be for you.

Technical Experience required to succeed in this role:

2+ years experience developing in:

• Mainframe: TSO, ZEKE, JCL, COBOL
• ETL: Informatica, IDMC (Informatica Cloud), Master Data Management (MDM), AWS Glue
• Business Intelligence (BI): SAP Tools (Crystal, Universe Design)
• AI: GitHub Copilot

Additional Assets

• AWS experience or certifications
• DevOps tools

What is more exciting is that the candidate will get their hands on new Cloud technologies as we build a resilient support framework within our team.

This is what you could be getting hands on learning in the first year!    

• Amazon Web Services (AWS)  
• AWS Glue, Lambda, Redshift, and Python/R
• DevOps: BitBucket, CICD Pipeline, Ansible, Jenkins
• Generative AI
• Agentic AI

Unique Requirements: 

• As a condition of the role, the successful candidate must obtain a Government of Canada Reliability Status security clearance through Sun Life.
• This role requires 24x7 support on a rotational basis and is subject to Over Time.

What’s in it for you?

• Competitive salary and bonus structure influenced by market range data
• Pension, stock, and savings programs to help build and enhance your future financial security
• An environment of continuous learning and improvement
• Hybrid work.

The Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results.  

Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our Clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.

Persons with disabilities who need accommodation in the application process, or those needing job postings in an alternative format, may e-mail a request to [email protected].

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 discussed throughout the selection process depending on the role requirements and individual needs.

We may use artificial intelligence to support candidate sourcing, screening, interview scheduling.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range:

Job Category:

Posting End Date: