Analytics Engineer (all genders)
Role details
Job location
Tech stack
Job description
What you will find with usWe 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 an Analytics Engineer, you will take on the following exciting tasks:
- Design and implement data models in modern Data Warehouses and Data Lakehouses, ensuring analytical data is delivered reliably and performantly
- Build and maintain data transformation pipelines with dbt, ensuring data flows are documented, tested, and version-controlled
- Develop dimensional data models (Kimball Star Schema, Snowflake Schema) and integrate diverse data sources into a consistent analytical data layer
- Implement Data Quality checks (e.g., Great Expectations, dbt tests) and contribute to maintaining Data Catalogues and Data Lineage
- Optimize database performance and work with modern table formats such as Delta Lake and Apache Iceberg
- Collaborate closely with Data Analysts, Data Scientists, and business stakeholders, translating business requirements into scalable data models
- Take ownership of (sub-)projects, structure data processes, and ensure smooth execution
- Use your strong communication skills and customer-oriented mindset to contribute significantly to project success-whether in meetings, workshops, or presentations
Requirements
- You have solid experience in data modelling within a Data Warehouse environment and know how to transform raw data into analytics-ready structures
- You have worked with dbt (dbt Core and/or dbt Cloud) in more than one project or bring at least six months of hands-on dbt experience
- You are proficient in Dimensional Data Modelling (Kimball Star Schema, Snowflake Schema) and have experience with data integration and transformation (ELT/ETL)
- You have strong SQL skills and ideally programming experience in Python
- You are familiar with Data Lakehouses (Snowflake, Databricks, BigQuery, Redshift) and ideally have worked with table formats such as Delta Lake or Apache Iceberg
- Experience with Data Quality tools (e.g., Great Expectations), Data Catalogues, and Data Lineage is a plus
- Experience with Data Vault 2.0 is a bonus
- You can explain complex topics clearly-in German (at least B1 level) and English
- You don't mind travelling to our customers from time to time
- You thrive in a team environment and bring empathy, communication skills, and a proactive mindset to every project
Benefits & conditions
- At our company you will find an exciting job in the AI environment
- Flexible working hours and locations such as home office are a matter of course for us
- A familiar culture, short communication channels and lots of great, experienced, international colleagues who are always there to support you
- Company-wide, international events that are well worth seeing
- Company bike and subsidisation of your fitness membership (EGYM Wellpass)
- Targeted and individual training for your professional and personal development
- A central location in Hamburg's,Munich's and Düsseldorf's city centre with good transport links (bus & train), as well as hub locations in all other major German cities
- Daily fresh fruit, good coffee, snacks, soft drinks & after-work beer