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

Sun Life Financial, Inc.

$90K — $140K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 4+ years experience in Datawarehouse and Business Intelligence environments
  • Proficient with ETL tools, specifically Informatica PowerCenter and IDMC
  • Familiar with mainframe technologies such as TSO, ZEKE, JCL, and COBOL
  • Experience with databases like Microsoft SQL Server, Oracle, and DB2
  • Knowledge in both Windows and Unix operating systems
  • Strong SQL scripting capabilities
  • Exposure to SAP technologies including Universe Designer and Crystal Reporting

Responsibilities

  • Provide 24x7 operational support on a rotational basis
  • Collaborate with stakeholders to implement operational improvements
  • Lead operations support for project transitions
  • Monitor application performance and troubleshoot discrepancies
  • Drive operational enhancements and manage defect resolutions
  • Deliver technical documentation and communicate with stakeholders
  • Foster a collaborative support engineering community

Benefits

  • Pension, stock, and savings programs for financial security
  • Environment focused on continuous learning and improvement
  • Flexible work hours and occasional remote work options
Full Job Description
Job Description:

The Sr 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.

This role requires 24x7 support on a rotational basis and is subject to Over Time.

We are looking for a candidate that is deeply curious and possesses the keenness to learn, develop and execute with excellence.

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

4+ Years of experience with the following Datawarehouse & Analytics technologies is required:

  • Datawarehouse (DW) and Business Intelligence (BI) environments
  • ETL Tools: Informatica PowerCenter/Informatica Intelligent Data Management Cloud (IDMC)
  • Mainframe technologies; TSO, ZEKE, JCL, COBOL
  • Databases: Microsoft SQL Server, Oracle, DB2, flat files
  • Knowledge/Experience in Windows and Unix
  • SQL Scripting
  • SAP technologies: Universe Designer, Web Intelligence, Crystal Reporting
  • Experience using GitHub Copilot


As we transform our internal business support model in Data & Analytics Operations, new employees will have the requirement to learn and support the following tools and platforms therefore, these skills are a definite asset:

  • Big Data solutions experience preferably using Amazon Web Services (AWS) or equivalent Public Cloud
  • AWS or equivalent Cloud Certifications
  • AWS Glue, Lambda, Redshift, and Python/R
  • DevOps: BitBucket, CICD Pipeline, Ansible, Jenkins
  • Generative AI
  • Agentic AI


What you will do on a day to day basis:

Operations Lead Support:
  • Work with stakeholders, business leaders to influence, impact, and deliver on operational improvements, incidents, assignments & solutions that are complex and strategic in nature.
  • Act as Operations Lead working with project development teams to ensure transition of operational support


Day to Day Competencies:
  • Maintain and support end-to-end application operations
  • Monitor and support jobs and application performance
  • Use excellent analytical skills to dive into the processes we support to resolve complex data discrepancies or job failures
  • Lead, monitor, identify and implement operational improvements
  • Develop an understanding of the business applications supported as well as the business direction
  • Ensure compliance with Incident, Problem and Change Management policies and processes
  • Deploy enhancements to production jobs using DevOps tools
  • Ensure appropriate prioritization and resolution of defects in accordance with agreed upon SLA
  • Provide on-going communication to key stakeholders to ensure they are aware of significant changes in a timely manner
  • Provide technical documentation that includes design and operational support documentation
  • Deliver innovative solutions by leveraging data and technology
  • Engage, influence and work collaboratively with Project Teams, Operation teams and vendors
  • Proactively share knowledge and coach others to build the support engineering community


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
  • Flexible hours and periodic work from home options


This role requires Reliability Status Clearance. In addition to a law enforcement inquiry and a credit check, as part of your application, the Government of Canada will ask if you lived or travelled outside of Canada for 6-consecutive months during the last 5 years, and you must account for all activities during this time.

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.

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:
90,000/90 000 - 140,000/140 000

Job Category:
IT - Technology Services

Posting End Date:
10/07/2026

Similar Jobs

More Jobs at Sun Life Financial, Inc.

More Information Technology Jobs

Find similar Sr. Support Engineer; Data & Analytics Operations (Cloud/Data Warehouse) jobs: