Job description
Henderson Drake is partnering with a leading global consultancy that specialises entirely in data, analytics and AI, to hire a Senior Data Engineer into its growing UK team.
This is a hands-on, client-facing role for someone who enjoys owning the full data lifecycle, from ingestion and modelling through to trusted, well-documented data products in production. You’ll build modern data platforms on Snowflake and dbt across a variety of client projects and industries, working alongside experienced engineers and analysts, with the chance to mentor and develop more junior team members.
What you’ll be doing
- Delivering end-to-end ETL/ELT solutions for clients, from ingestion and orchestration through to reporting-ready data
- Building modular dbt models across staging, intermediate and mart layers
- Designing data warehouse structures using dimensional modelling (star/snowflake schema) or Medallion architecture
- Translating business requirements into reusable models and consistent metrics
- Improving performance and warehouse costs through incremental models, SQL optimisation and refactoring
- Implementing dbt tests and validation checks to catch data quality issues early
- Establishing Git workflows, code reviews and CI/CD for reliable deployment
- Documenting models, metrics and lineage so client teams can maintain their data products
- Owning client relationships on both the business and technical side
- Mentoring junior engineers and contributing to team best practice
What we’re looking for
- 5+ years’ experience in data engineering, analytics engineering or data warehousing
- Hands-on experience across the entire end-to-end ETL/ELT lifecycle
- Strong proficiency in Python and SQL, including complex transformations and query optimisation
- Solid production experience with Snowflake and dbt (Core or Cloud)
- Strong data warehousing background, including snowflake schema or Medallion architecture
- Experience with Git-based workflows, code reviews and CI/CD for data
- Direct client-facing experience, with excellent communication skills and a confident, professional presence
- The ability to work independently, make sound modelling decisions and own delivery
Nice to have
- Experience mentoring or leading junior team members (a strong plus)
- Ingestion tools such as Fivetran, and working with APIs, SFTP or ERP data
- Orchestration with dbt Cloud, Prefect or similar
- BI and self-service tools such as Power BI, Tableau, Looker, Hex or Metabase
- Domain experience in finance, commercial, supply chain, procurement or product analytics
- dbt certification (e.g. dbt Fundamentals)
The package
- £50,000–£66,000, depending on location, plus bonus and benefits.
- Hybrid working: 2 days a week in the London or Milton Keynes office, 3 days remote.
- Structured career development and continuous learning.