Discussion

Support Engineer, Data & Analytics Operations

Show

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