Senior Consultant GCP Data Engineer

Intuita - Vacancies; Remote; GBP 50,000 - 70,000; Full time

Job summary

A leading consultancy in the UK seeks a Data Engineer with senior experience to join their Data Engineering team. The role involves transforming raw data into reliable models using dbt within Google Cloud Platform. Candidates should possess strong SQL skills, experience in data modeling, and familiarity with agile principles. This position offers a flexible remote work environment, an attractive salary between £50,000 - £70,000 based on experience, and numerous perks supporting health and professional growth.

Benefits

Flexible work hours

Free therapy sessions

Professional development opportunities

Dog friendly offices

Qualifications

• Expert level proficiency in SQL is required.
• Deep experience in building and architecting data models with dbt.
• Solid experience on Google Cloud Platform, especially with BigQuery.

Responsibilities

• Design, build, and maintain scalable data models using dbt.
• Translate business requirements into well-documented dbt models.
• Collaborate with teams to implement data models that serve as a single source of truth.

Skills

Expert level proficiency in SQL

Experience building data models with dbt

Understanding of data warehousing concepts

Experience with Google Cloud Platform

Experience working with stakeholders

Familiarity with version control and CI/CD

Experience with agile principles

Tools

dbt

BigQuery

Git

Job description

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

All our office locations considered: Newbury & Liverpool (UK); Šibenik, Croatia (considered)

We're on the hunt

First and foremost we seek strong Consultants; so, if you are ready to explore our dynamic team where you can truly act as an expert in your field in support of our clients and their challenges in the world of data and technology, read on!

The Team

We're Intuita - a fast-growing consultancy that's making waves in both the consultancy and technology space. With our ambitious goals for 2025 and beyond, we are looking for talented individuals to complement the team of experts we already have working across our business, becoming a pivotal part of our journey, to not just meet, but continuously exceed our client expectations! We can offer an interesting insight into projects spanning a variety of industries, which may include telecoms, insurance, healthcare, finance and mortgages across various sectors.

The Role

We are seeking a skilled Data Engineer, ideally Senior experience to join our Data Engineering team, ideally as a permanent consultant opportunity. We can move fast and adapt our selection period to our needs. With this in mind, immediate or quick availability is ideal, alongside permanent rights to work are essential, alongside other factors we'll consider.

This is a hands‑on Analytics Engineering role where you'll be at the heart of data-driven decisions. Day to day you will be transforming raw data in clean, reliable and performant data models using dbt within Google Cloud Platform (GCP). Your primary goal is to empower our clients' business users by making data accessible, understandable and ready for reporting, dashboarding and ad-hoc analysis.

We're looking for someone who loves to model data and bridge the gap between technical data infrastructure and business intelligence. Experience in the mobile/telecoms industry would be a bonus!

Key outputs for the role

• Design, build, and maintain scalable and trustworthy data models in dbt, making use of Kimball Dimensional and One Big Table (OBT) methodologies.
• Translate business requirements from stakeholders into robust, well-documented and tested dbt models.
• Develop and own workflows within Google Cloud Platform environments, primarily using BigQuery and dbt.
• Write high-quality, optimised SQL for data transformation and analysis.
• Develop and maintain scalable data pipelines within the Google Cloud Platform, ensuring efficient and cost-effective data transformations.
• Take ownership of dbt project health, monitoring daily runs and proactively resolving any data, model, or scheduling issues in collaboration with other project owners.
• Use version control (Git) and CI/CD to manage the entire lifecycle of analytics code.
• Collaborate with cross-functional teams to understand data requirements and implement robust, well-documented and performant dbt models that serve as a single source of truth for business reporting.
• Implement and champion data quality testing, documentation standards, and modelling best practices within dbt projects.
• Troubleshoot and resolve any issues or errors in the data pipelines.
• Stay updated with the latest cloud technologies and industry best practices to continuously enhance engineering capabilities.

A bit about YOU!

As much as we just love working with great, fun people, there are some obvious required Skills and Experience we are going to be seeking out. For this role we'd be expecting to see:

• Expert level proficiency in SQL.
• Deep, practical experience of building and architecting data models with dbt.
• A strong understanding of data warehousing concepts and data modelling techniques (e.g., Kimball, Dimensional Modelling, One Big Table).
• Solid, hands‑on experience within the Google Cloud Platform, especially with BigQuery.
• Proven experience working directly with business stakeholders to translate their needs into technical specifications and data models.
• Familiarity with version control (Git) and CI/CD workflows for analytics.
• Experience with agile principles and practices

The "Nice to Haves"

• Certification in dbt or Google Cloud Platform or related technologies.
• Experience with other cloud platforms (e.g. AWS, Azure, Snowflake) and data warehouse/lakehouse technologies (e.g. Redshift, Databricks, Synapse)
• Knowledge of distributed big data technologies.
• Proficiency in Python.
• Familiarity with data governance and compliance frameworks.

Your characteristics as a Consultant will include

• Driven by delivering quality work, with a great eye for detail.
• Takes accountability and ownership of tasks, and finds the best way to solve problems.
• Excellent communicator who can make sense of and communicate complex ideas to audiences of differing levels of seniority and technical ability.
• Ability to quickly understand client context and demonstrate expertise in their business.
• Relationship builder, with the ability to motivate and engage effectively to build trust with clients and colleagues.
• An interest in industry trends, emerging technologies, and client's businesses.
• Ability to take the lead and drive initiatives independently.

If you don't fit the above criteria exactly but are interested in working for us, get in touch anyway! - we hire people, not a job spec!

What's in it for you?

Salary

£50,000 - £70,000 per annum DOE
OR contractor day rates, Outside IR35 can to be discussed in person for experienced Engineers with good availability.

(Really) flexible and remote working

we don't mind when, where or how you work; you are trusted to work in the way that suits you best.

Genuine care and support for your health and wellbeing

free therapy sessions, financial education, birthday treats and much more.

Incredible training and learning opportunities

you'll be surrounded by the best in the business and encouraged to keep growing.

Freedom and empowerment to own problems and explore new ideas

we allow our consultants to actually be consultants, not just bodies.

A supportive, friendly team

we work hard and enjoy spending time together, whether it's in-person at socials or via silly Slack conversations.

Dog friendly offices

we're a team of dog lovers, so we've made our offices dog friendly!

Longer term benefits

Our enhanced benefits package overview (link omitted for brevity).

If you require any support with your application, please contact [e-mail]