Dbt Analytics Engineer

OH POLLY; United Kingdom; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading fashion brand in the United Kingdom is seeking a Senior Analytics Engineer to take full ownership of the DBT project that powers their Common Data Model. The candidate will ensure the reliability of data models used for decision-making across Finance, Ecommerce, and Operations. Strong hands-on experience with DBT, advanced SQL skills, and familiarity with systems like Airtable and Shopify are essential. The role offers a competitive salary, discounts on products, and various employee benefits.

Benefits

50% discount on products

Extra day off for your 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.
• Advanced SQL skills, preferably with Snowflake.

Responsibilities

• Own the Common Data Model and ensure its accuracy.
• Manage DBT project end-to-end.
• Ensure data models behave predictably for downstream users.

Skills

Running DBT in production

Advanced SQL skills (Snowflake preferred)

Data observability tools

Refactoring models

DBT snapshots and SCD patterns

Experience with Airtable and 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

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.