DBT Analytics Engineer

Oh Polly; United Kingdom; Hybrid; GBP 60,000 - GBP 80,000; Full time

Job summary

A fast-growing fashion brand in the United Kingdom is seeking a Senior Analytics Engineer (DBT) to take full ownership of the DBT project that powers the Common Data Model and critical business insights. The ideal candidate will have strong hands-on experience in running DBT in production, deep understanding of DBT snapshots, and advanced SQL skills. This role requires proactive quality assurance and collaboration with various departments to ensure data models support organizational goals. Competitive salary and benefits are offered including a product discount and additional leave.

Benefits

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, owning, or evolving a Common Data Model.

Responsibilities

• Own the Common Data Model and the DBT project end-to-end.
• Ensure snapshots run reliably and validate historical changes.
• Proactively identify and resolve data quality issues.

Skills

DBT in production

Advanced SQL skills

Data observability tools

Refactoring models

Tools

Snowflake

Airtable

Shopify

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
  You will be required in the Wirral office at least one day a week.

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.