Data & Analytics Operations Support Engineer

Data & Analytics Operations Support Engineer Get AI-powered advice on this job and more exclusive features. 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 The Sun Life Application Operation Services organization’s (AOS) focus is to provide a positive digital user experience that is seamless, available, and valuable for our Canadian and global business partners and clients by delivering the support and quality that ensures our technologies are fully functional, secure, resilient, and highly stable. This Support Engineer role is on the Data & Analytics Operations team and is responsible for maintaining and supporting Sun Life’s data in multiple Data Warehouses as well as creating reports and universes for our business partners using different BI applications and support the ingestion processes in several data integration applications. The candidate must work well within a dynamic environment and have an ability to understand applications and handle multiple requests and priorities. We value collaborative team players who will use their problem solving and analytical skills to maintain and improve application stability and performance to satisfy client and business objectives. In this role, the candidate will join a 24/7 team which will require them to be on call on a rotational basis overnight. As a condition of the role, the successful candidate must obtain a Government of Canada Reliability Status security clearance through Sun Life. Responsibilities We are looking for a candidate with deep curiosity, a passion for analytics to not only resolve issues, but to prevent them from happening in the future. Support several Data Warehouses (DW), from data ingestion to data consumption Candidate must 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 Mainframe skills TSO, ZEKE, JCL, COBOL Informatica skills ETL PowerCenter, IDMC (Informatica Cloud) Master Data Management (MDM) Business Intelligence (BI) solutions Support existing reporting and universes as well as creating or enhancing new reports which requires a background/experience in SQL writing Experience with SAP Tools (Crystal, Universe Design) Respond to incident, problem and change management policies and processes Knowledge of ITIL is an asset Create and maintain superb technical documentation that will help support our poly-skilled team Work collaboratively with Project Teams, Operation teams and vendors to schedule implementation of changes to meet overall schedule of the project and mitigate risk of customer experience impacts due to changes Monitor our environments to identify and implement operational improvements Participate in rotational on-call 24/7 operational support, including after hours support on a rotational basis Preferred Skills Computer Science degree or certificate, or equivalent, supplemental training 3–5 years hand‑on experience working as an IT Application/Technical support analyst 3+ years working in a DW/BI environment Mainframe development experience using TSO, ZEKE, JCL, COBOL Experience with Business Intelligence (BI) solutions: SAP Tools Knowledge of Business Objects Universe Designer and Web Intelligence Experience with change management and incident management processes Experience in On‑call support and troubleshooting Experience with Databases: Microsoft SQL Server, Oracle, DB2, flat files A drive to understand our business partners, clients and the business direction Demonstrated level of initiative and judgment in order to organize and prioritize tasks, workload and projects Ability to work as part of a virtual team to achieve tangible results, and ability to manage and resolve conflict Written communication is clear and concise Experience working in a team-oriented, collaborative environment Salary Range 65,000/65 000 - 105,000/105 000 Job Category IT - Technology Services Posting End Date 23/11/2025 Seniority level Not Applicable Employment type Full-time Job function Information Technology Industries Financial Services and Insurance 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 thebrightside@sunlife.com. 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 thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted. Referrals increase your chances of interviewing at Sun Life by 2x Get notified about new Operations Support Engineer jobs in Kitchener, Ontario, Canada. #J-18808-Ljbffr