Support Engineer, Data & Analytics Operations

Jobtailor; Toronto; On-site; CAD 70,000 - 110,000; Full time

Job summary

Jobtailor in Canada seeks a data operations specialist to support on-premise and cloud environments. You will safeguard client data, monitor systems, and improve operational efficiency while analyzing data consumption and troubleshooting data discrepancies.

Strong SQL, ETL, and BI reporting skills are essential. The role requires 2+ years of experience with mainframe tools and data warehousing, with practical Informatica Cloud and AWS Glue expertise.

Qualifications

• 2+ years experience in data operations and BI
• Experience with mainframe: TSO, ZEKE, JCL, COBOL
• Proficiency with Informatica Cloud and AWS Glue in data pipelines
• Ability to write complex SQL queries, joins and stored procedures
• Knowledge of data warehouses and data integration concepts
• Familiarity with ITIL incident and change management processes

Responsibilities

• Provide operational support on premise and in the Cloud
• Safeguard client data and ensure data security best practices
• Monitor environments and implement operational improvements
• Analyze data consumption issues by understanding code logic
• Write complex SQL queries and optimize data retrieval
• Build and support ETL processes and data pipelines
• Design, analyze and format BI reports for clients

Skills

SQL query writing

ETL process development

BI reporting

ITIL knowledge

Analytical skills

Communication skills

Tools

Informatica Cloud

AWS Glue

Crystal Reports

Universe Design

SAP Tools

Master Data Management

Job description

• 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