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
#J-18808-Ljbffr