DBT Analytics Engineer

Oh Polly; Wirral; On-site; GBP 60,000 - 80,000; Full time

Job summary

A fast-growing fashion brand in the UK is seeking a Senior Analytics Engineer to take full ownership of the DBT project powering their Common Data Model. This role requires strong DBT production experience, advanced SQL skills, and a deep understanding of data quality issues. You will collaborate with Finance, Ecommerce, and Operations to translate requirements into reliable data models. Company perks include a competitive salary, product discounts, and opportunities for professional development.

Benefits

Salary: £DOE

50% discount on products

Extra day off for birthday

Learning and development opportunities

Company pension

Regular company social events

Qualifications

• Strong, hands-on experience running DBT in production.
• Deep understanding of DBT snapshots and SCD patterns.
• Experience designing and evolving a Common Data Model.

Responsibilities

• Ownership of the Common Data Model.
• Manage changes to business logic in a controlled way.
• Ensure DBT runs are observable, debuggable, and reliable.

Skills

DBT production experience

Advanced SQL (Snowflake preferred)

Data observability tools

Experience with Airtable

Strong opinions on analytics engineering best practices

Job description

About Oh Polly

Founded in 2015, Oh Polly is a fast-growing, social first fashion brand that creates trend driven, high quality premium products. With a focus on innovation, global responsibility, and ethics. We’ve built a combined social following of over 10 million across our brands, including Bo+Tee; our activewear line. Operating across multiple global offices, we are a dynamic team offering ambitious individuals the chance to thrive, grow, and take their careers to the next level.

The Role

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.

Key Responsibilities

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

Snapshots & Historical Data

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

Model Quality & Testing

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

Observability & Reliability

• 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

Change Management & Collaboration

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

Skills & Experience

• 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’s on Offer

• Salary: £DOE


• 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

This Company is an equal opportunities employer Oh Polly job positions are open to all suitably qualified candidates, regardless of age, disability, gender reassignment, marriage or civil partnership, pregnancy or maternity, race, religion or belief, sex or sexual orientation.