Senior Analytics Engineer (DBT) Job at Oh Polly (Wirral)

Senior Analytics Engineer (DBT)

Oh Polly

Location:
United Kingdom , Wirral

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

Not provided

Save Job

Apply Position

Job Description:

We are looking for a Senior Analytics Engineer (DBT) to take full ownership of the DBT project that powers our Common Data Model (CDM) and business-critical insights. This role exists because our data models underpin decision-making across Finance, Ecommerce, Operations, and Leadership. We need someone who treats dbt as a production-grade system, not just a transformation layer. You will be responsible for building, maintaining and governing trustworthy, well-documented and reliable data models that the business can depend on.

Job Responsibility:

Ownership of the Common Data Model
Own the DBT project end-to-end that powers the CDM
Be accountable for model correctness, grain, and semantic consistency
Ensure models behave predictably for downstream users (Finance, Ecommerce, Operations)
Own all DBT snapshot logic (SCDs, check vs timestamp strategies)
Ensure snapshots run reliably and on schedule
Validate historical changes are correct, auditable, and complete
Prevent silent failures or unnoticed gaps in historical data
Design and maintain robust dbt tests, including: Primary key and uniqueness tests, Accepted values and enums (e.g. brand, lifecycle states), Relationship and grain integrity, Snapshot invariants
Introduce data contracts and guardrails where appropriate
Proactively identify and resolve data quality issues before they reach stakeholders
Ensure DBT runs are observable, debuggable, and reliable
Detect and respond to: Failed or skipped snapshots, Unexpected row count changes, Schema drift
Partner with platform engineers to improve monitoring and alerting
Manage changes to business logic (e.g. brand rules, lifecycle definitions) in a controlled and documented way
Partner closely with Finance, Ecommerce, and Operations to translate requirements into durable data models
Review upstream source changes (e.g. Airtable, Shopify, WMS) for downstream impact
Act as the point of contact for all Common Data Model–related questions

Requirements:

Strong, hands-on experience running DBT in production
Deep understanding of DBT snapshots and SCD patterns, Incremental models, Refactoring models without breaking downstream dependencies
Advanced SQL skills (Snowflake preferred)
Experience supporting high-trust reporting use cases, particularly Finance
Comfortable improving and refactoring existing dbt projects
Experience with data observability tools
Familiarity with systems such as Airtable, Shopify, or operational platforms
Experience designing, owning, or evolving a Common Data Model
Strong opinions on analytics engineering best practices - and the ability to explain and defend them

What we offer:

50% discount on Oh Polly and Bo+Tee products
An extra day off for your birthday
Learning and development opportunities
Company pension
Regular company social events
Competitive Salary
Enhanced Holiday Entitlement
Your Birthday Off
50% Discount on Company Products
Flexible Working Options
Enhanced Company Pension
Corporate Gym Membership
Enhanced Maternity/Paternity Leave
Personal Development Plan
Cycle to Work Scheme
Company Sick Pay
Bright Modern Open Plan Offices
Employee Assistance Programme
Employee Rewards Platform

Additional Information:

Job Posted:
January 26, 2026

Oh Polly - All Job Offers

Job Link Share: