Senior Analytics Engineer (all genders)

Eraneos; Hamburg; On-site; EUR 85,000 - 125,000; Full time

Benefits offered by this job

Hybrid work model

International team

Learning opportunities

Company Bike program

Wellpass membership

Job summary

Eraneos in Hamburg seeks a Senior Analytics Engineer to design and deliver modern analytics solutions. You will build scalable data models and data pipelines with dbt, translating business needs into robust analytics architectures.

You will work with Snowflake, Databricks, BigQuery or Redshift, ensuring data quality, governance, and performance. The role requires leadership, collaboration with analysts and data scientists, and occasional travel within Germany.

Qualifications

• Hands-on Analytics Engineering and data modelling on modern cloud data platforms.
• Experience with dbt Core/Cloud across multiple client projects.
• Strong dimensional data modelling (Kimball Star Schema, Snowflake Schema) and ELT design.
• Excellent SQL skills and Python for automation and data-driven solutions.
• Experience with Snowflake, Databricks, BigQuery or Redshift and lakehouse architectures.
• Understanding of Data Quality, Data Testing, Data Lineage and Data Governance.
• Knowledge of Data Vault 2.0 and BI architectures is a plus.
• Ability to communicate complex technical concepts to technical and business stakeholders in German (C1) and English.

Responsibilities

• Design, develop, and own analytical data models on modern data warehouses and lakehouses.
• Build robust data transformation pipelines using dbt; implement tests, docs, and version control.
• Implement scalable analytics architectures; integrate diverse data sources into a consistent analytics landscape.
• Drive best practices for data quality, lineage, and governance.
• Optimize data models and query performance on cloud platforms; work with Delta Lake and Apache Iceberg.
• Collaborate with stakeholders, analysts, data scientists, and engineers; mentor colleagues.
• Present technical solutions in a business-oriented way and participate in client workshops.

Skills

Analytics Engineering

Data Modeling

dbt Core/Cloud

Dimensional Modelling

SQL

Python

Cloud Data Platforms

Data Quality & Governance

Data Vault 2.0

BI Architectures

German/English Communication

Tools

Snowflake

Databricks

BigQuery

Amazon Redshift

Delta Lake

Apache Iceberg

Great Expectations

Job description

What you will find with us

We are a technical, implementation-oriented spin-off of a global management consultancy. Our clients are primarily DAX and Fortune Global 500 companies, which we advise on issues in the areas of analytics, big data and machine learning. Within the group, we take on the development of individual and data-driven solutions in order to transform our clients into AI-powered companies. We offer an international working environment with agile teams and creative startup methods as well as above-average remuneration and numerous additional benefits. With our HQ in Hamburg, offices in Munich and Düsseldorf and our hub locations in all other major German cities (Cologne, Berlin, Frankfurt and Stuttgart), we ensure that all colleagues are integrated into our team of experts across Germany.

As a Senior Analytics Engineer, you will play a key role in designing and delivering modern analytics solutions. Together with our clients, you will develop scalable data models and analytics architectures that provide the foundation for reporting, self-service analytics and data-driven decision-making.

• You design, develop and take ownership of analytical data models on modern data warehouses and lakehouse platforms, ensuring high quality, performance and long-term maintainability.
• You build robust data transformation pipelines using dbt and establish best practices for testing, documentation, version control and deployment.
• You design scalable analytical data models based on established modelling approaches such as Kimball, Snowflake Schema and Data Vault 2.0, integrating diverse data sources into a consistent analytics landscape.
• You establish and drive best practices for Data Quality, Data Testing, Data Lineage and Data Governance, contributing to the development of modern analytics standards.
• You optimise data models and query performance on modern cloud data platforms, leveraging lakehouse architectures and technologies such as Delta Lake and Apache Iceberg.
• You collaborate closely with business stakeholders, Data Analysts, Data Scientists and Data Engineers, translating complex business requirements into scalable analytics solutions.
• You take technical ownership of workstreams or project modules, ensuring successful delivery while acting as a technical mentor and sparring partner for your colleagues.
• Through your strong communication and consulting skills, you advise clients as a trusted partner, facilitate workshops and present technical solutions in a clear and business-oriented way.

Who you are

• You have several years of hands‑on experience in Analytics Engineering and data modelling on modern cloud data platforms. You know how to translate business requirements into sustainable analytical data models that create measurable value for our clients.
• You have extensive experience working with dbt (dbt Core and/or dbt Cloud) and have successfully designed, implemented and further developed analytics engineering solutions across multiple client projects.
• You have a strong command of dimensional data modelling (Kimball Star Schema, Snowflake Schema) and solid experience designing and implementing modern ELT and data transformation architectures.
• You have excellent SQL skills and are comfortable using Python for automation, data analysis and the development of data-driven solutions where appropriate.
• You have practical experience with modern cloud data platforms such as Snowflake, Databricks, BigQuery or Amazon Redshift and are familiar with modern lakehouse architectures and table formats such as Delta Lake and Apache Iceberg.
• You understand Data Quality, Data Testing, Data Lineage and Data Governance as essential components of professional analytics solutions. Experience with Great Expectations, data catalogues or similar tools is an advantage.
• Experience with Data Vault 2.0 as well as Semantic Layers or modern BI architectures is considered a plus.
• You take ownership of technical solution designs, advise clients as a trusted technical partner and support your colleagues as a mentor and technical sparring partner.
• You are able to communicate complex technical concepts clearly and effectively to both technical and business stakeholders in German (C1) and English.
• You are willing to travel occasionally to client sites.

Who we are

• Shape the future with AI by working on diverse and impactful projects at the intersection of strategy, technology, and business.
• Work flexibly in a way that suits your life – with hybrid working models, flexible working hours, and the option to work from home.
• Enjoy an open, collaborative culture with flat hierarchies, an international team, and colleagues who are always willing to share their knowledge and support one another.
• A Great Place to Grow: Benefit from tailored learning opportunities, individualized career paths, and dedicated support for your professional and personal development.
• Be part of a strong international network of more than 1,300 colleagues and enjoy regular cross-office and international company events.
• Maintain a healthy work‑life balance with flexible working models and, where appropriate, the opportunity to take a sabbatical.
• Take advantage of our Company Bike program and a subsidised EGYM Wellpass membership to support your health and wellbeing.
• Work from modern, centrally located offices in Hamburg, Munich, and Düsseldorf, as well as flexible hub locations across Germany's major cities.
• Enjoy complimentary drinks, fresh fruit, snacks, premium coffee – and, if you like, an after‑work beer with your colleagues.
• Thrive in an environment built on trust, ownership, and continuous growth, where your ideas are valued regardless of your role or level of seniority

Our top priority is that you fit us and we fit you, regardless of origin, nationality, sexual orientation, religion, gender identity, age, handicap or other aspects of diversity.