Support Engineer, Data & Analytics Operations
About The Position
Bring us your passion for digital or data analytics, and we’ll put you to work on exciting initiatives that answer the challenge: "How can we do that better?” Working with a dedicated team of energetic, forward-thinking innovators, you’ll stretch your imagination and sharpen your skills on the leading-edge projects that are keeping Sun Life Financial ahead of the curve. You want more than a job; you want a career - a career with a company that encourages learning and personal growth. You want to be “one of the best”. 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.
Requirements
- Mainframe development experience is required.
- Knowledge and experience with 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 code logic to analyze and troubleshoot data consumption issues.
- Ability to fix or enhance code on a daily basis.
- Ability 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.
- 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.
- Excellent communication skills to support Project Teams, Operation teams and vendors.
- 2+ years experience developing in Mainframe: TSO, ZEKE, JCL, COBOL.
- 2+ years experience developing in ETL: Informatica, IDMC (Informatica Cloud), Master Data Management (MDM), AWS Glue.
- 2+ years experience developing in Business Intelligence (BI): SAP Tools (Crystal, Universe Design).
- 2+ years experience developing in AI: GitHub Copilot.
- Must obtain a Government of Canada Reliability Status security clearance through Sun Life.
- Requires 24x7 support on a rotational basis.
- Subject to Over Time.
Nice To Haves
- AWS experience or certifications.
- DevOps tools.
- Hands on learning in Amazon Web Services (AWS) - AWS Glue, Lambda, Redshift, and Python/R.
- Hands on learning in DevOps - BitBucket, CICD Pipeline, Ansible, Jenkins.
- Hands on learning in Generative AI.
- Hands on learning in Agentic AI.
Responsibilities
- Maintain and support processes in multiple Data Warehouses, Business Intelligence, Data Integration applications.
- Provide operational support in Cloud technologies, utilizing AWS for Enterprise Data Lake (EDL).
- Safeguard client’s data by providing superior operational support both on premise and in the Cloud.
- Analyze and troubleshoot data consumption issues for Sun Life clients.
- Fix or enhance code on a daily basis.
- Design, analyze, and format reports for clients.
- Manage Batch Operations including schedulers, failures and recovery.
- Resolve complex data discrepancies or job failures.
- Perform incident, problem, and change management according to ITIL policies and processes.
- Create and maintain technical documentation.
- Continuously monitor environments to identify and implement operational improvements.
- Possess an owner’s mindset.
Benefits
- Competitive salary and bonus structure influenced by market range data.
- Pension, stock, and savings programs.
- An environment of continuous learning and improvement.
- Hybrid work.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
