DBT Analytics Engineer

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 active wear 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.

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.

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

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

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