About the role
You will design the pipelines and storage that turn raw data from our systems into clean, tested and secure data for reporting, finance and AI. You will make data reliable and easy to use, and protect personal data.
What you will do
- Build and maintain ELT pipelines
- Model data with dbt and maintain the data warehouse
- Orchestrate jobs with Airflow, Dagster or Prefect
- Test, document and monitor data quality
- Control access to personal data under UK GDPR
- Support analysts, finance and AI engineers
Minimum qualifications
- Bachelor's degree in Computer Science, Engineering or a related field, or equivalent practical experience
- 5+ years in data engineering
- Advanced SQL and Python in production
- dbt models and an orchestrator (Airflow, Dagster or Prefect) you built
- A data warehouse you designed (PostgreSQL, BigQuery or Snowflake)
- Personal data handled under UK GDPR (access control, retention)
- English at CEFR C1 or above (IELTS 7.0 or equivalent)
Expert knowledge
- Dimensional modelling: star schemas, slowly changing dimensions and data contracts
- Incremental pipelines: idempotent loads, change data capture and backfills
- Data quality: dbt tests, freshness checks and lineage
- Warehouse performance: partitioning, clustering and cost control
Preferred qualifications
- dbt Analytics Engineering certification
- Google Professional Data Engineer or Azure DP-203
- Streaming with Kafka
- Data from ERP or billing systems
Before any offer we verify your certificates, qualifications, references and right to work in the UK. Security roles also need background screening (BPSS) and may need security clearance.
SOWTK is an equal opportunity employer. We welcome applicants of every background and do not discriminate on any characteristic protected by the Equality Act 2010.