Data Engineer

Oh Polly; Manchester; On-site; GBP 50,000 - 55,000; Full time

Benefits offered by this job

Discounts

Birthday off

Flexible hours

Wellbeing benefits

Cycle to Work

Pension

Learning & development budget

Job summary

Oh Polly is seeking a data engineer to join the Manchester tech team. You will build and maintain pipelines moving data from operational systems into Snowflake, and develop data models for reporting using Python services that connect Shopify, NetSuite, 3PL, returns, and PIM on AWS with Terraform.

You will work across SQL, Python, APIs and AWS, collaborating with Operations, Merchandising and Trading to translate requirements into reliable data solutions.

Qualifications

• Strong SQL and Python skills.
• 3+ years of experience building data pipelines.
• Experience with a cloud data warehouse, ideally Snowflake.
• Experience consuming REST APIs and vendor API docs.
• Ability to translate unclear requirements into tech solutions.
• Experience with dbt for data transformation and modelling.
• Experience with AWS Lambda and Terraform.
• Power BI experience for analytics.
• Ecommerce data exposure (Shopify, ERP, WMS, 3PL).
• Familiarity with APIs and webhooks between SaaS platforms.
• Interest in AI-assisted development tools.

Responsibilities

• Build and maintain pipelines from third-party and operational systems into Snowflake.
• Develop integrations between systems using Python, AWS Lambda and Terraform.
• Design and maintain the transformation layer and data models for reporting.
• Collaborate with the data team on Snowflake structure and direction.
• Work with Operations, Merchandising and Trading to turn requirements into data solutions.
• Improve data consistency with definitions, validation and quality checks.
• Investigate data issues across sources and pipelines.
• Provide ad hoc analysis and quick business insights.
• Contribute to experiments with AI-assisted development in the data platform.

Skills

SQL

Python

Data pipelines

REST APIs

Data integration

Analytical mindset

API documentation

AI tooling

AWS

Tools

Snowflake

dbt

Terraform

AWS Lambda

Power BI

Shopify

NetSuite

Job description

About Oh Polly
Oh Polly is a fashion brand founded in 2015, with more than 10 million followers across Oh Polly and Bo+Tee, our activewear brand.
We design and sell our own products and operate across ecommerce, warehousing and global fulfilment. That gives the data team exposure to a wide range of operational and commercial systems.

The Role

You’ll join a small data team within Tech, working on the pipelines and integrations that move data between our operational systems and Snowflake. The role covers both data engineering and integration work.
You’ll build and maintain data models used for reporting and analytics, as well as Python services that connect systems including Shopify, NetSuite, our 3PL, returns platform and PIM. These services run on AWS, with infrastructure managed through Terraform.
The work is a mix of building new solutions and improving existing ones. Depending on the work underway, you might spend more time in Snowflake and SQL, or more time working with Python, APIs and AWS.
We’re also starting to experiment with AI tooling and agentic workflows across the data platform. This is still an emerging area for the team, so there’s an opportunity to help explore where these tools can genuinely improve how we build, operate and use our data systems.

Key Responsbilities

• Build and maintain pipelines that bring data from third-party and operational systems into Snowflake

• Build and support integrations between operational systems, primarily using Python, AWS Lambda and Terraform

• Develop and maintain the transformation layer and data models used for reporting and analytics

• Work with the wider data team on the structure and direction of the Snowflake warehouse

• Work directly with teams including Operations, Merchandising and Trading to understand requirements and turn them into reliable data solutions

• Improve consistency between systems by introducing clear definitions, validation and data quality checks

• Investigate data issues and trace problems across source systems, integrations and warehouse models

• Provide ad hoc analysis and reporting when the business needs an answer quickly

• Contribute to experiments with AI-assisted development and agentic tooling where it can improve data engineering workflows

Skills and Requirements

• Strong SQL and Python skills

• 3+ years of experience building data pipelines, integrations or similar production data systems

• Experience working with a cloud data warehouse, ideally Snowflake

• Experience consuming REST APIs and working from vendor API documentation

• Comfortable investigating unfamiliar systems and understanding how data moves between them

• Able to take an unclear business requirement and turn it into a practical technical solution

• Experience with dbt for data transformation and modelling

• WS, particularly Lambda

• PowerBi experience

• Terraform or other infrastructure-as-code tooling

• Ecommerce or retail data, such as Shopify, an ERP, WMS or 3PL

• Experience working with APIs and webhooks between SaaS platforms

• Experience using AI-assisted development tools or agentic workflows

What's on offer?

• 50% discount on Oh Polly and Bo+Tee products

• 25 days annual leave plus your birthday off

• Flexible working hours around a Monday to Friday core of 9:00–17:30

• £50,000 - £55,000

• Wellhub subscription, with access to gyms, fitness classes and wellbeing apps

• Cycle to Work scheme

• Company pension

• Learning and development budget

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.