- 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
- Valuable 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 strong 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 (Toronto)
🏢 Jobtailor
📍 Toronto