Data Platform Engineer: Build a Trusted Data Platform

Peace Hills General Insurance Company; Edmonton; On-site; CAD 110,000 - 160,000; Full time

Benefits offered by this job

Annual bonus eligibility

Registered Pension Plan matching

Personal Insurance reimbursement

Social events

Staff appreciation events

Career development opportunities

Job summary

Peace Hills General Insurance Company is seeking a Data Platform Engineer to build and operate a modern data platform from our Edmonton office. You will work with in-house architects, analytics engineers, and BI developers to support production environments, security, data-quality, and data governance, enabling regulatory submissions and trusted data products for the business.

You will contribute to ingestion, delta extraction, orchestration, and migration away from legacy data warehouses, while

Qualifications

• Post-secondary education in Computer Science, Engineering or a related field, or equivalent experience.

Responsibilities

• Stand up and maintain Dev/Test/Prod environments, including the code branching strategy and promotion between them.
• Implement the platform security and access model: SSO, secrets management and role-based access.
• Build the data-quality, testing and monitoring framework: automated tests, freshness SLAs and alerting.
• Build and maintain ingestion and orchestration pipelines, including incremental/delta loads.
• Build and maintain CI/CD pipelines for data code and deployments.
• Diagnose and resolve platform and pipeline issues, document root causes and prevent recurrence.
• Apply lineage, documentation and testing standards so every data asset has an owner, tests, lineage and an SLA.
• Support auditable, reproducible data products for regulatory and industry submissions.
• Support migration off the legacy data warehouse and help retire legacy processes.
• Write clear documentation and runbooks, and help set the engineering patterns future team members will follow.
• Various other duties as required.

Skills

Python

Airflow

dbt

SQL

PostgreSQL

Docker

Linux

CI/CD

SSO

Regulated industry

Education

Post-secondary education in CS/Engineering or related field

Tools

SAP BODS

Oracle

Job description

Peace Hills General Insurance Company is seeking a Data Platform Engineer to build and operate a modern data platform from our Edmonton office. You will work with in-house architects, analytics engineers, and BI developers to support production environments, security, data-quality, and data governance, enabling regulatory submissions and trusted data products for the business.

You will contribute to ingestion, delta extraction, orchestration, and migration away from legacy data warehouses, while