H

Holycode

AI consultancy, strategy, and software development

Senior Analytics Engineer - Google Cloud, dbt

Data EngineeringConfirmed live in the last 24 hours
Full-timeBucharest, RomaniaNo salary listed

About the Job

Requirements

  • 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.
  • Availability to work onsite from the Bucharest office.

Responsibilities

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

Desired Qualifications

  • Experience with PostgreSQL replication and logical decoding.
  • Familiarity with Google Cloud Datastream.
  • Experience with Metabase, including query caching and efficient dashboard design.
  • Experience using GitHub Actions for data workflows.
  • Familiarity with dbt Cloud, Dagster or Airflow.
  • Experience with OpenTofu or Terraform on Google Cloud.
  • Relevant dbt or Google Cloud certifications.
  • German language skills.

About the Company

Holycode

AI consultancy, strategy, and software development

Preparing company summary for Holycode based on provided description.

Company size
201-500
Company stage
Not listed
Total funding
Not listed
Headquarters
Zurich, Switzerland
Founded
2014

Recently Posted Jobs

Explore more opportunities at Holycode

See more jobs