Overview

Intuita Liverpool, England, United Kingdom — Senior Consultant - GCP Data Engineer

Responsibilities

• 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.

Qualifications

• 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.

Nice to have

• 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.

Benefits

• Salary: £50,000 - £70,000 per annum DOE or contractor day rates. Outside IR35 can be discussed in person for experienced Engineers with good availability.
• Flexible and remote working — you are trusted to work in the way that suits you best.
• Care for health and wellbeing — free therapy sessions, financial education, birthday treats and more.
• Incredible training and learning opportunities — be surrounded by the best in the business and encouraged to keep growing.
• Freedom and empowerment to own problems and explore new ideas — consultants can act as consultants, not just bodies.
• A supportive, friendly team — we work hard and enjoy social time together.
• Dog-friendly offices — we’re a dog-loving team.

If you require any support with your application, please contact recruitment@intuitaconsulting.com