Data Engineer, Guidewire

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

• Sc in Computing Science, Technical Diploma Specializing in Programming, or equivalent.
• 1 to 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.

Working at Peace Hills

Along with a competitive base pay, Peace Hills understands that by reducing work-life struggles, individuals can enjoy a healthier lifestyle while improving productivity at work.  A collegial work environment and a work-life balance are just two of the ways we do this.

If you are interested in this great opportunity, submit your resume to Peace Hills Insurance to hr@phgic.com. Posting will remain until a suitable candidate is found. 

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