Analytics Engineer - Driving License Required

Helping Hands; Alcester; On-site; GBP 45,000 - 60,000; Full time

Job summary

A leading care service provider based in Alcester is seeking an Analytics Engineer to build and optimise the data transformation layer for self-serve analytics. This role requires strong proficiency in dbt and SQL, alongside a collaborative mindset. Responsibilities include designing scalable dbt models, developing ELT pipelines, and ensuring data quality. The company offers a supportive work environment with genuine career growth opportunities and a commitment to diversity and inclusion.

Benefits

Career development pathways

23 days' annual leave

Employee assistance programme

Diversity and inclusion

Blue Light Card discounts

Qualifications

• Experience building and optimising pipelines at scale.
• Understanding of data warehousing and dimensional modelling.
• Familiarity with CI/CD practices.

Responsibilities

• Design and maintain scalable dbt models aligned to business logic.
• Develop and optimise ELT pipelines using modern technologies.
• Collaborate with analysts and data scientists to deliver datasets.

Skills

Problem-solving skills

Clear communication

Proficiency in dbt

Proficiency in SQL

Collaborative mindset

Tools

Matillion

Snowflake

Git/GitHub

Job description

As an Analytics Engineer, you'll play a key role in building and optimising the data transformation layer that powers self‑serve analytics and advanced data products. Working closely with analysts and data scientists, you'll ensure data is accurate, accessible and fit for purpose, supporting Helping Hands' mission to deliver exceptional care services at home.

Responsibilities

• Design and maintain modular, scalable dbt models aligned to business logic.
• Develop and optimise ELT pipelines using Matillion, Snowflake, dbt and GitHub.
• Apply dimensional modelling standards for clarity and consistency.
• Implement testing, documentation, CI/CD processes and data quality frameworks.
• Collaborate with analysts and data scientists to deliver analytics‑ready datasets.
• Monitor pipeline health and resolve data issues proactively.
• Share knowledge and contribute to a culture of continuous improvement.

Qualifications

• Strong problem‑solving skills and clear communication.
• Proficiency in dbt and SQL, with experience in testing and documentation.
• Understanding of data warehousing, dimensional modelling and schema design.
• Familiarity with Git/GitHub and CI/CD practices.
• Proven experience building and optimising pipelines at scale.
• Experience with ETL or ELT pipelines.
• Collaborative mindset and eagerness to learn.

Desirable

• Experience with modern data stack technologies (dbt, Snowflake, Matillion).
• Awareness of data governance and quality frameworks.
• Previous experience in healthcare, social care or retail industries.

Benefits

• Clear career development pathways and genuine opportunities to grow.
• 23 days' annual leave (rising to 25 after two years).
• Blue Light Card discounts.
• Employee assistance programme.
• A workplace that celebrates diversity and champions inclusion. Everyone is welcome.

At Helping Hands we’re committed to building a diverse, inclusive community where everyone belongs. All applications are considered fairly in line with our Equality and Diversity Policy.