Provide superior operational support both on premise and in the Cloud
Safeguard our client’s data
Continuously monitor our environments to identify and implement operational improvement
Ability to understand the code logic to analyze and troubleshoot data consumption issues for Sun Life clients
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
Requirements 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)
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
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
Core Competencies Demonstrates expertise in SQL query writing, ETL process development, and business intelligence reporting, with a solid focus on data integrity and operational support in both on-premise and cloud environments. Proficient in technical documentation and communication to facilitate collaboration across project and operations teams.
Highest-signal resume keywords SQL Query Writing
ETL Process Development
Business Intelligence Reporting
Mainframe Technologies
ITIL Knowledge
Hard Skills SQL
ETL
Data Integration
Data Warehousing
COBOL
JCL
Informatica
AWS Glue
SAP Tools
Master Data Management
Soft Skills Analytical Skills
Communication Skills
Industry Keywords Operational Support
Data Consumption
Data Discrepancies
Incident Management
Change Management
Tools & Technologies Informatica Cloud
Crystal Reports
Universe Design

#J-18808-Ljbffr

📌 Support Engineer, Data & Analytics Operations (Ontario)
🏢 Jobtailor
📍 Ontario