Analytics Engineer

Analytics Engineer

Full-Time 40000 - 48000 £ / year (est.) No home office possible
H

At a Glance

  • Tasks: Own the dbt layer and shape analytics best practices in a growing team.
  • Company: Join an innovative platform connecting travellers with reliable home care services.
  • Benefits: Enjoy remote work flexibility and be part of a purpose-led business.
  • Why this job: Make a real impact on data strategy while enhancing travel and pet care experiences.
  • Qualifications: Strong SQL skills, experience with dbt, and familiarity with cloud data warehouses required.
  • Other info: Ideal for those passionate about data transformation in a high-growth environment.

The predicted salary is between 40000 - 48000 £ per year.

This innovative, subscription-based platform brings together a global community of individuals with complementary needs: those seeking flexible travel opportunities and those requiring reliable care for their home and animals. The model is built around trust and mutual benefit, offering a unique alternative to traditional services by focusing on shared value rather than direct transactions.

The company is at an exciting stage of data transformation. Over the past six months, they’ve built the foundations of a modern data platform, including hiring a data manager to oversee governance and integrations, a data engineer, and most recently, a data scientist. With dbt introduced as part of a broader tech overhaul, the team is now looking for a dedicated Analytics Engineer to take ownership of the dbt layer and play a key role in shaping analytics best practices across the business.

As the team scales, there’s a clear need for someone to focus solely on the analytics engineering function. Currently, analytics work is shared across the team, but performance bottlenecks, a lack of consistency, and the opportunity to implement best practice modelling highlight the need for a specialist. This role will be instrumental in building a reliable and scalable production environment on top of a growing set of raw data sources.

Tech Stack and Environment:

  • Data Warehouse: Redshift
  • Modelling: dbt (recently onboarded, still early-stage)
  • ETL & Integration: Fivetran, with plans to scale
  • Architecture: Medallion
  • Dashboarding & Visualisation: Mode Analytics (SQL-based)

Ideal Background:

  • Strong SQL skills with hands-on experience in dbt and modern cloud data warehouses (e.g. Redshift, Snowflake, BigQuery)
  • Familiarity with ELT tools (e.g. Fivetran), BI tools (e.g. Looker, Tableau, Power BI), and Git-based workflows
  • Solid understanding of data modelling, warehousing principles, and analytics best practices
  • Experience working cross-functionally with strong communication skills

Nice to have:

  • Python, AWS/GCP/Azure, Medallion Architecture, Databricks, and knowledge of data governance or experience in high-growth environments

This is a fantastic opportunity to join a purpose-led business in a high-impact role, helping to shape the data strategy of a company making travel more accessible and pet care more personal.

Analytics Engineer employer: Harnham

Join a purpose-driven company that values innovation and community, where as an Analytics Engineer, you will play a pivotal role in shaping the data strategy of a unique platform. With a strong focus on employee growth, a collaborative work culture, and the opportunity to work remotely from anywhere in the UK, this role offers a rewarding environment for those looking to make a meaningful impact in the travel and pet care sectors.
H

Contact Detail:

Harnham Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Analytics Engineer

✨Tip Number 1

Familiarise yourself with dbt and its best practices. Since this role focuses on taking ownership of the dbt layer, demonstrating your understanding of dbt's functionalities and how it integrates with data warehouses like Redshift will set you apart.

✨Tip Number 2

Showcase your SQL skills through practical examples. Prepare to discuss specific projects where you've used SQL to solve complex problems or improve data processes, as strong SQL proficiency is a key requirement for this position.

✨Tip Number 3

Network with professionals in the analytics engineering field. Engaging with others who work in similar roles can provide insights into industry trends and expectations, which can be beneficial during interviews.

✨Tip Number 4

Prepare to discuss your experience with cross-functional collaboration. This role requires strong communication skills, so be ready to share examples of how you've successfully worked with different teams to achieve common goals.

We think you need these skills to ace Analytics Engineer

Strong SQL Skills
Experience with dbt
Familiarity with Redshift, Snowflake, or BigQuery
Knowledge of ELT tools like Fivetran
Proficiency in BI tools such as Looker, Tableau, or Power BI
Understanding of data modelling principles
Experience with cloud data warehouses
Git-based workflow familiarity
Strong communication skills
Ability to work cross-functionally
Understanding of analytics best practices
Experience in building scalable production environments
Knowledge of Medallion Architecture
Familiarity with Python
Experience with AWS, GCP, or Azure
Understanding of data governance

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your strong SQL skills and hands-on experience with dbt and cloud data warehouses. Emphasise any relevant projects or roles that showcase your ability to work with ELT tools and BI tools.

Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company’s mission. Discuss how your background aligns with their needs, particularly in building a reliable and scalable production environment.

Showcase Relevant Experience: When detailing your work experience, focus on specific achievements related to analytics engineering, data modelling, and cross-functional collaboration. Use metrics where possible to demonstrate your impact.

Highlight Soft Skills: Since strong communication skills are essential for this role, include examples of how you've successfully worked with different teams or stakeholders. This will show that you can effectively contribute to a collaborative environment.

How to prepare for a job interview at Harnham

✨Showcase Your SQL Skills

As an Analytics Engineer, strong SQL skills are crucial. Be prepared to discuss your experience with SQL in detail, including specific projects where you've used it to solve complex problems or improve processes.

✨Demonstrate Your dbt Knowledge

Since the company is looking for someone to take ownership of the dbt layer, make sure to highlight your hands-on experience with dbt. Discuss how you've implemented best practices in previous roles and any challenges you've overcome while using dbt.

✨Understand the Tech Stack

Familiarise yourself with the company's tech stack, especially Redshift and Fivetran. Be ready to explain how you've worked with similar tools and how you can contribute to building a reliable and scalable production environment.

✨Communicate Cross-Functionally

Strong communication skills are essential for this role. Prepare examples of how you've successfully collaborated with different teams in the past, and be ready to discuss how you would approach working cross-functionally in this new position.

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

H
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>