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

Sun Life • Waterloo, ON

7d • CA$90,000 - CA$140,000 • Hybrid

About The Position

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.

Requirements

• 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

Nice To Haves

• 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

Responsibilities

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed