Data Platform Engineer

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

We currently have an opening for a permanent, full-time Data Platform Engineer in our Corporate Business Intelligence department. This role will report to the Manager, Business Intelligence and will be based out of our Edmonton office.

In this role, the successful candidate will build and operate Peace Hills’ modern data platform. Working with in-house architects, analytics engineers and BI developers, this role supports production environments, security and access model, and data-quality, testing and monitoring framework, and contributes to ingestion, delta extraction and orchestration. The successful candidate will ensure the platform is safe, trusted and auditable, enabling regulatory submissions and the data products the business relies on.

What You’ll Do:

• 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.

What You’ll Bring:

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

• CDMP, dbt or data engineering certifications are an asset but not required;

• 5+ years of experience in data engineering, including 2+ years building and operating production pipelines on a modern data stack;

• Strong Python for data pipelines and automation;

• Orchestration experience with Airflow, Dagster or similar;

• dbt or similar transformation tooling, with solid working SQL;

• Git, CI/CD, and promoting code through Dev/Test/Prod Environments;

• Has built automated data testing and monitoring for a production environment;

• Experience implementing platform security: SSO, secrets management, role-based access;

• PostgreSQL, including advanced SQL and performance tuning;

• Incremental/delta loading (CDC, watermarking);

• Docker and Linux;

• Experience in a highly regulated industry, financial services or insurance; Guidewire / CDA experience;

• Exposure to multiple ETL tools and databases (e.g. SAP BODS, Oracle, Postgres).

What You'll Experience:

• Competitive base pay with annual bonus eligibility;

• Healthy work-life balance including a day off every 4 weeks;

• Matching contributions to your Registered Pension Plan;

• Personal insurance reimbursement;

• Social events held throughout the year;

• Celebration of your team’s achievements each year with an annual staff appreciation event;

• A career in a stable and essential industry, at a company with an exceptional corporate culture and opportunities for professional development and advancement.

Why Peace Hills:

Peace Hills General Insurance Company has been serving Western Canada since 1982 with home, auto and business insurance products. Our head office is in Edmonton, Alberta, with branch offices in Calgary and Vancouver. We currently employ over 300 staff who work withmore than 1,000 broker offices across British Columbia, Alberta, Saskatchewan, Manitoba, the Northwest Territories, Nunavut and Yukon Territory.

Peace Hills is proudly owned by the Samson Cree Nation, and it is through Wahkôtowin – a Cree word that means “kinship” and the interconnectedness of all beings – that we are and continue to be a respected insurer that provides creative and responsive solutions.

This job posting will remain open until a suitable candidate is found.