Senior Analytics Engineer – Google Cloud & dbt
About this role
Holycode is looking for a Senior Analytics Engineer with strong BigQuery and dbt experience to join our team in Bucharest.
You will help build and improve analytics pipelines on Google Cloud, ensuring that business teams have access to reliable, timely data. Working closely with engineering and business stakeholders, you will improve data models, optimise warehouse costs and develop practical solutions that scale with business needs.
What awaits you:
• Assess and improve analytics pipelines connecting operational databases, BigQuery, dbt and business intelligence tools. • Develop and maintain dbt models that transform raw data into reliable datasets for reporting and analysis. • Identify BigQuery cost drivers by analysing query history, data scanned and resource usage. • Optimise table design through partitioning, clustering and appropriate materialisation strategies. • Improve incremental processing and reduce unnecessary full refreshes. • Design data refresh schedules that balance business needs, data freshness and infrastructure costs. • Support near-real-time analytics for selected datasets using suitable ingestion and transformation approaches. • Improve workflow orchestration, automated data quality checks, logging and failure handling. • Collaborate with analytics users to improve dashboard performance and reduce unnecessary warehouse queries. • Communicate findings and recommendations clearly, prioritising improvements by expected impact and implementation effort. • Document data models, dependencies and operational procedures.
What we expect from you:
• At least five years of experience in data engineering or analytics engineering. • At least two to three years of hands-on production experience with BigQuery. • Advanced SQL skills and experience working with complex analytical datasets. • Strong practical experience with dbt, including incremental models, materialisations, tests, tags and selectors. • Proven experience optimising BigQuery performance and costs through partitioning, clustering, partition pruning and query analysis. • Familiarity with BigQuery INFORMATION_SCHEMA and the trade-offs between consumption-based and capacity-based pricing. • Experience with change data capture or streaming ingestion into BigQuery. • An understanding of how BI tools and dashboard queries affect warehouse performance and cost. • Experience with Git and automated data workflows. • A pragmatic approach to problem-solving, with the ability to explain technical trade-offs and prioritise improvements. • Fluent written and spoken English. • Availability to work onsite from our Bucharest office.
Bonus points for: