Data Platform Engineer

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 similartransformation 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 ofyour 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.
#J-18808-Ljbffr