Data Engineer

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 a dynamic 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.

Working at Peace Hills

Peace Hills understands that by reducing work-life struggles, individuals can enjoy a healthier lifestyle while improving productivity at work. Ensuring an appropriate work/life balance and a collegial and supportive work environment are just a couple of ways we do this.

If you are interested in this great opportunity, submit your resume to Peace Hills Insurance at hr@phgic.com.

We thank all applicants for their interest, however only those candidates shortlisted will be contacted.