Data Engineer

Peace Hills Insurance; Edmonton; On-site; CAD 70,000 - 100,000; Full time

Job summary

A leading insurance company is seeking a Data Engineer to join their Information Technology team in Edmonton. The successful candidate will be responsible for developing and maintaining data pipelines, ensuring data quality, and collaborating with various IT professionals. This is a fantastic opportunity for individuals with a background in computing science and experience in data management, particularly within insurance or financial sectors.

Qualifications

• 1-5+ years of Software Development.
• Experience with ETL processes.
• Experience working with financial data an asset.

Responsibilities

• Develop and maintain data pipelines for ETL processes.
• Design and optimize data storage solutions.
• Ensure data quality and integrity.

Skills

Analytical Skills

Problem-Solving Skills

Communication

Education

B.Sc in Computing Science

Technical Diploma Specializing in Programming

Tools

Oracle SQL

Postgres SQL

SAP Data Services - BODS

Guidewire Data Hub

Guidewire Data Platform

AWS

IBM Cognos

Job description

We currently have a position available for a Data Engineer in our Information Technology department. This role is based in the Edmonton office. Reporting to the Director Digital and working within adynamic team of IT development professionals, this role is responsible for the support and development of our applications, mainly related to our Guidewire data system. More specifically :

Primary Duties and Responsibilities :

• Developing and maintaining data pipelines for efficient data extraction, transformation, and loading (ETL) processes.
• Designing and optimizing data storage and solutions, including data warehouses and data lakes.
• Ensuring data quality and integrity through data validation, cleansing, and error handling.
• Collaborating with data analysts, data architects, and software engineers to understand data requirements and deliver relevant data sets (e.g., for business intelligence, actuarial).
• Implementing data security measures and access controls to protect sensitive information.
• Automating and improving data processes and workflows for scalability and efficiency.
• Monitoring data infrastructure for performance and reliability to address issues promptly.
• Documenting data pipelines, processes, and best practices for knowledge sharing.

Required Qualifications :

• B.Sc in Computing Science, Technical Diploma Specializing in Programming, or equivalent.
• 1-5+ years of Software Development.
• Proficient with Oracle / Postgres SQL.
• Proficient with SAP Data Services - BODS (Business Object Data Services).
• Experience with Guidewire DH (Data Hub) and IC (Info Center).
• Experience with Guidewire Data platform (Guidewire data lake implementation) an asset.
• Experience / understanding of database design principles and ability to apply said knowledge
• Experience / understanding of data warehousing / data lake principles and ability to apply said knowledge.
• Experience working with financial data an asset.
• IBM Cognos knowledge, in particular framework manager, an asset.
• Experience with ETL processes.
• Familiarity with cloud platforms (AWS).
• Experience in automation of processes.

Strong analytical and problem-solving skills.

Proven ability to be flexible and work hard, both independently and in a team environment.

Excellent oral and written communication skills.

Previous experience in insurance or financial institutions is an asset.