Senior Data Engineer – DBT, AWS (native), AWS DMS, ETL, Warehouse Architecture, Redshift, IaC (Terraform) in York

Senior Data Engineer – DBT, AWS (native), AWS DMS, ETL, Warehouse Architecture, Redshift, IaC (Terraform) in York

York Temporary 95000 - 100000 £ / year (est.) Home office (partial)
Smart Sourcer

At a Glance

  • Tasks: Architect and deliver a cloud-native data platform while leading the adoption of modern data practices.
  • Company: Rapidly modernising SaaS platform with a focus on AI engineering and innovative data solutions.
  • Benefits: Competitive salary, flexible remote work, and opportunities for professional growth.
  • Other info: Join a dynamic team and enjoy a collaborative environment with excellent career prospects.
  • Why this job: Shape the future of data platforms and influence strategic decisions across the business.
  • Qualifications: Deep experience with AWS data stack and proven ability in cloud-native platform design.

The predicted salary is between 95000 - 100000 £ per year.

Reporting to the Head of Data for this global, rapidly modernising SaaS platform, this business is scaling its data capabilities to support native AI engineering and agentic workflows. We’re looking for a Senior AWS Data Engineer who wants to shape the future of their data platform, modern analytics stack, and the way data powers decisions across the business. This is a hands‑on, architecture‑shaping, strategy‑influencing role for someone who thrives at the intersection of engineering excellence, data modelling, platform design and cross‑functional leadership. You’ll own the full data lifecycle from ingestion to modelling to consumption, and play a pivotal role in building a reliable, governed, cloud‑native data ecosystem.

What you’ll be doing:

  • Architect and deliver a cloud‑native data platform across ingestion, modelling, warehousing and BI
  • Lead adoption of DBT, ELT patterns, AWS DMS, Redshift, Athena, Iceberg
  • Build high‑quality models (Kimball, Data Vault, OBT) and set the standards for testing, documentation and governance
  • Shape BI strategy and ensure consistent, trusted metrics across the business
  • Mentor engineers and partner with Principal Engineers, Product and Analytics to deliver high‑value data products
  • Evolve the AWS‑native platform: Redshift, Athena, S3 lake patterns, Iceberg
  • Modernize DataOps: CI/CD for dbt and infra, automated testing, GitHub Actions
  • Build high‑reliability ingestion pipelines with strong SLAs and schema‑change resilience
  • Retire legacy pipelines and uplift performance, cost and governance
  • Ensure strong security, compliance and data governance across the platform

Key requirements:

  • Deep experience across the modern AWS data stack
  • Proven ability to design and scale cloud‑native data platforms
  • Mastery of modelling, ELT, warehouse architecture and BI tooling
  • A collaborative, pragmatic leadership style with a passion for high‑quality data ecosystems.

£95k - £100k. London & 90% remote. 12-month Fixed Term Contract.

Senior Data Engineer – DBT, AWS (native), AWS DMS, ETL, Warehouse Architecture, Redshift, IaC (Terraform) in York employer: Smart Sourcer

Join a forward-thinking SaaS platform that is at the forefront of data innovation, where your expertise as a Senior Data Engineer will directly influence the evolution of our cloud-native data ecosystem. With a strong emphasis on collaboration and professional growth, we offer a dynamic work culture that values engineering excellence and strategic input, alongside competitive remuneration and the flexibility of 90% remote work. This role not only allows you to shape cutting-edge data solutions but also provides ample opportunities for mentorship and career advancement in a rapidly modernising environment.

Smart Sourcer

Contact Details:

Smart Sourcer Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Senior Data Engineer – DBT, AWS (native), AWS DMS, ETL, Warehouse Architecture, Redshift, IaC (Terraform) in York

Tip Number 1

Network like a pro! Reach out to your connections in the data engineering field, especially those who work with AWS and DBT. A friendly chat can lead to insider info about job openings that aren't even advertised yet.

Tip Number 2

Show off your skills! Create a portfolio showcasing your projects, especially those involving ETL processes and cloud-native architectures. This will give potential employers a taste of what you can bring to their team.

Tip Number 3

Prepare for interviews by brushing up on your technical knowledge and soft skills. Be ready to discuss your experience with Redshift, AWS DMS, and data governance. Practice common interview questions to boost your confidence!

Tip Number 4

Don’t forget to apply through our website! We’re always on the lookout for talented individuals like you. Plus, it’s a great way to ensure your application gets the attention it deserves.

We think you need these skills to ace Senior Data Engineer – DBT, AWS (native), AWS DMS, ETL, Warehouse Architecture, Redshift, IaC (Terraform) in York

DBT
AWS (native)
AWS DMS
ETL
Warehouse Architecture
Redshift
IaC (Terraform)

Some tips for your application 🫡

Tailor Your CV:Make sure your CV reflects the skills and experiences that align with the Senior Data Engineer role. Highlight your expertise in AWS, DBT, and data modelling to show us you’re the perfect fit!

Craft a Compelling Cover Letter:Use your cover letter to tell us why you’re excited about this role and how you can contribute to our data platform. Share specific examples of your past work that demonstrate your ability to shape data strategies.

Showcase Your Projects:If you've worked on relevant projects, don’t hold back! Include links or descriptions of your previous work with ETL processes, Redshift, or any cloud-native solutions. We love seeing real-world applications of your skills.

Apply Through Our Website:We encourage you to apply directly through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any updates from us!

How to prepare for a job interview at Smart Sourcer

Know Your Tech Stack Inside Out

Make sure you’re well-versed in the AWS data stack, especially DBT, Redshift, and AWS DMS. Brush up on your ETL processes and warehouse architecture knowledge. Be ready to discuss how you've used these technologies in past projects.

Showcase Your Problem-Solving Skills

Prepare to share specific examples of challenges you've faced in data engineering and how you overcame them. Highlight your experience with building ingestion pipelines and ensuring data governance, as this will resonate with their needs.

Demonstrate Leadership and Collaboration

Since this role involves mentoring and cross-functional collaboration, be prepared to talk about your leadership style. Share instances where you’ve successfully led a team or collaborated with other departments to deliver high-value data products.

Ask Insightful Questions

Prepare thoughtful questions about their data strategy and how they envision the future of their data platform. This shows your genuine interest in the role and helps you assess if it’s the right fit for you.