Data Engineer (Snowflake, DBT) in London
Data Engineer (Snowflake, DBT)

Data Engineer (Snowflake, DBT) in London

London Temporary Home office (partial)
Harnham

At a Glance

  • Tasks: Design and implement a Snowflake data warehouse, optimising data pipelines for cloud insights.
  • Company: Leading travel company known for innovation and seamless customer experiences.
  • Benefits: Competitive pay, flexible work arrangements, and a collaborative culture.
  • Other info: 6-month contract with excellent support from leadership and career growth opportunities.
  • Why this job: Join a transformative data journey and tackle exciting technical challenges.
  • Qualifications: Strong experience with Snowflake, SQL, and dbt; knowledge of ELT processes.

This position as a Snowflake Engineer offers the opportunity to join a leading travel company based near West London, currently undergoing a major cloud data transformation.

This established Pharma brand is known for its innovation and commitment to delivering seamless customer experiences through data. With a focus on modernising its data platforms, the company is investing in Snowflake and cloud-native tooling to better understand customer journeys, improve operations, and fuel growth. Contractors and perm hires we've placed here consistently highlight the collaborative culture, exciting technical challenges, and strong support from leadership.

As a Data Engineer, you will play a crucial role in a data transformation program, focusing on optimising data pipelines and enabling cloud-driven insights. You will also be responsible for post-project documentation, ensuring clear communication with non-technical stakeholders.

Role type: 6-MONTH CONTRACT

Location: LONDON (1 day in office)

Pay: £500 - £550 per day (Outside IR35)

Key responsibilities:

  • Designing and implementing a Snowflake-based data warehouse, ensuring scalability and efficiency.
  • Developing and optimising ELT pipelines, leveraging Snowflake best practices for data ingestion and transformation.
  • Enhancing performance and query optimisation, ensuring cost-effective and high-performing workloads.
  • Working with dbt and Airflow to transform raw data into structured datasets for analytical consumption.
  • Creating clear documentation to communicate technical processes to non-technical teams.

Key Skills and Requirements:

  • Strong commercial experience with Snowflake and its ecosystem.
  • Proficiency in SQL for data modelling and transformation within Snowflake.
  • Experience with dbt to develop scalable data pipelines.
  • Knowledge of ELT processes and best practices for cloud-based data architecture.
  • Hands-on experience with performance tuning and query optimisation in Snowflake.
  • Familiarity with cloud platforms (AWS/GCP/Azure) and their integration with Snowflake.

How to Apply: Please register your interest by sending your CV via the apply link on this page.

Data Engineer (Snowflake, DBT) in London employer: Harnham

Join a leading travel company based near West London, renowned for its innovative approach and commitment to enhancing customer experiences through data. With a collaborative culture and a focus on employee growth, this company offers exciting technical challenges and strong leadership support, making it an excellent employer for those looking to thrive in a dynamic environment while contributing to a major cloud data transformation.
Harnham

Contact Detail:

Harnham Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Engineer (Snowflake, DBT) in London

✨Tip Number 1

Network like a pro! Reach out to folks in the industry, especially those already working at the company you're eyeing. A friendly chat can give you insider info and maybe even a referral!

✨Tip Number 2

Show off your skills! If you’ve got a portfolio or GitHub with projects related to Snowflake or dbt, make sure to share it. It’s a great way to demonstrate your expertise beyond just your CV.

✨Tip Number 3

Prepare for the interview by brushing up on common data engineering scenarios. Think about how you’d tackle challenges with data pipelines or performance tuning in Snowflake. We want you to shine!

✨Tip Number 4

Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take that extra step to connect with us directly.

We think you need these skills to ace Data Engineer (Snowflake, DBT) in London

Snowflake
SQL
dbt
ELT processes
Data Modelling
Performance Tuning
Query Optimisation
Cloud Platforms (AWS/GCP/Azure)
Data Pipeline Development
Documentation Skills
Data Transformation
Analytical Skills
Collaboration Skills

Some tips for your application 🫡

Tailor Your CV: Make sure your CV is tailored to the Data Engineer role. Highlight your experience with Snowflake, dbt, and any relevant cloud platforms. We want to see how your skills match what we're looking for!

Showcase Your Projects: Include specific projects where you've designed data pipelines or optimised data warehouses. We love seeing real examples of your work that demonstrate your expertise in ELT processes and performance tuning.

Keep It Clear and Concise: When writing your application, be clear and concise. Use straightforward language to explain your technical skills and experiences. Remember, we need to communicate effectively with non-technical stakeholders too!

Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can’t wait to see what you bring to the table!

How to prepare for a job interview at Harnham

✨Know Your Snowflake Inside Out

Make sure you brush up on your Snowflake knowledge before the interview. Be ready to discuss your experience with its ecosystem, including any specific projects you've worked on. Highlight how you've optimised data pipelines and improved performance in past roles.

✨Show Off Your SQL Skills

Since SQL is crucial for this role, prepare to demonstrate your proficiency. You might be asked to solve a problem or optimise a query on the spot, so practice common SQL scenarios and be ready to explain your thought process clearly.

✨Familiarise Yourself with dbt and ELT Processes

Get comfortable discussing your experience with dbt and ELT processes. Be prepared to share examples of how you've used dbt to develop scalable data pipelines and how you ensure best practices in cloud-based data architecture.

✨Communicate Clearly with Non-Technical Stakeholders

Since you'll need to create documentation for non-technical teams, think about how you can explain complex technical concepts simply. Prepare examples of how you've successfully communicated technical processes in the past, as this will show your ability to bridge the gap between tech and business.

Data Engineer (Snowflake, DBT) in London
Harnham
Location: London

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>