> Markdown version of [/jobs/ext/2725393-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/2725393-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Analytics Engineer - **Company:** Rabot Energy - **Location:** Berlin, Germany - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Sql Data Warehouse, Microsoft Excel, Airflow, Business Logic, Automation of Tests, BigQuery, Cloud Computing, Code Review, Continuous Integration, Information Engineering, Python (Programming Language), SQL Databases, Data Streaming, Data Processing, Sql Optimization, Git, Infrastructure Automation Frameworks - **Published:** September 5, 2026 - **Apply:** https://startup.jobs/senior-analytics-engineer-m-f-d-rabot-energy-8923468 ## About the Role * Senior analytics engineer: advanced SQL and data modelling - dbt on a cloud data warehouse (BigQuery), Git-based work, reviews and CI, orchestration (dbt Cloud, Airflow or Dagster) and Python for automation. At least 5 years in analytics engineering, data engineering or BI, owning models yourself. * Modelling & software craft: dimensional modelling and a semantic layer with well-defined metrics are second nature to you, and you write modular, documented, refactorable models others can read and change. The same SQL copied across ten reports is a problem, not a result. * Reliability & governance: tests, monitoring, documentation and GDPR-compliant data processing are part of your definition of "done". * Business & entrepreneurial judgement: you understand our business model and the KPIs behind it (churn, CLV, pricing, spot prices, tariff logic, channels) and model accordingly - and you treat infrastructure as an investment, spotting where compute cost, maintenance or redundancy burn money and prioritising by impact. * Ownership & role model: you take topics end-to-end, bring order where much is still taking shape, review code, document where people actually look, and help colleagues grow. * Language: English is our working language. German helps with source systems and market documentation, but it is not a requirement. Nice to have: experience in the energy market (market communication, meter data, dynamic tariffs), data contracts, infrastructure as code, streaming, experience with investor or board reporting, and scale-up experience in a data-intensive, regulated environment. ## Description You own the layer between raw data and decisions. You model our data in dbt on BigQuery - from staging through core to the marts - keep the models reliable through tests, reviews and documentation, and keep an eye on run times and cost. Upstream you work with Data Engineering on ingestion, data quality and clear interfaces. Downstream you work with BI and the business functions: you turn business logic into certified, documented models with unambiguous definitions. The point is not that you build every request yourself, it is that analysts and business teams can answer their own questions on your models instead of queuing for analytics capacity. Your Results We think in outcomes, not task lists. The points below are what we will look at together in your check-ins after 3, 6 and 12 months - as a shared plan, not as an exam. Month 3 (ramp-up) * You know our dbt project and our data landscape - source systems in Sales, Marketing, Product and Customer Support, BigQuery, Metabase - and can trace every key metric from the source to the report. * Your first models are running in production: via branch, review and test, documented in dbt and our knowledge base. * You have named the biggest weaknesses in the existing setup - duplicated logic, untested models, expensive queries - and delivered a prioritised proposal for fixing them. Month 6 (performance) * You own the model layers for one core domain end-to-end - e.g. Customer & Product: naming conventions, tests, documentation and definitions sit with you. * Core models are covered by tests (uniqueness, freshness, references); errors surface in CI rather than in a management meeting. * Business logic lives in dbt rather than in individual Metabase questions and Excel files; duplicated definitions have been removed. * Cost per model is transparent, and you have measurably reduced the biggest cost drivers in BigQuery. Month 12 (scale) * There is one shared, reliable model base for the company's key metrics - versioned, tested, documented, with clear ownership of the definitions. * Self-service works: analysts and business functions build their analyses on certified models; around 90% of recurring reporting runs through the warehouse and Metabase instead of Excel. * Releases are routine: CI/CD, automated tests and traceable lineage - changes go live without firefighting. * Board and investor metrics (churn and retention, cohorts, unit economics) can be reproduced from versioned models at any time., * Ownership: you own the layer everything at RABOT rests on - from a squad-level metric to investor reporting - with real room to shape things and a direct line to BI, Data Engineering and the business functions. * Room to shape: much of this is only just taking shape; you will influence how we model data at RABOT instead of maintaining finished pipelines. * Culture: we celebrate new ideas and approaches, we take learning seriously, and we understand that life sometimes gets in the way of doing your best work. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [The Biggest German Tech Companies](https://www.wearedevelopers.com/magazine/424-the-biggest-german-tech-companies) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers)