Analytical Engineer (f/m/d)

Awin AG seeks a Mid-level Analytical Engineer to build its Analytical Engineering practice from the ground up using Databricks, dbt, and BI tools, bridging data engineering and business intelligence.

This position is designed to establish the Analytical Engineering function within the company, leveraging a modern Databricks stack alongside Tableau and Power BI. The role operates at the intersection of data engineering and business intelligence, ensuring that reliable data from the reporting layer is transformed into a trusted semantic layer to support strategic insights and campaign performance.

Responsibilities

• Provide business context for mart layers and feed into BI-ready tables for self-serve analytics.
• Create a single source of truth for business metric definitions, KPIs, and calculation rules.
• Take responsibility for data quality initiatives and own documentation around the semantic layer.
• Partner with Data Engineering to agree handoff boundaries, raise upstream data requirements, and flag quality issues.
• Work with Insight Analysts to encode business logic and stakeholder requirements into reliable, reusable data models.
• Support BI Developers in consuming the semantic layer efficiently within Tableau and Power BI.
• Coach BI Developers in Analytics Engineering best practices considering tools such as dbt.
• Create clear documentation and playbooks so that team members can contribute to any dbt project independently.
• Design data marts with self-serve usage in mind, ensuring clear naming, consistent grain, and reliable refresh cadence.
• Ensure the semantic layer is AI-ready by keeping it clean, governed, and documented.

Requirements

• Strong, hands-on SQL with experience writing complex transformations and reviewing code.
• Proven experience with dbt (Core or Cloud) in a production environment.
• Experience working with a cloud data warehouse or lakehouse.
• Solid understanding of data modelling concepts including dimensional modelling, star schemas, and slowly changing dimensions.
• Comfortable working in a code-reviewed, version-controlled workflow.
• Experience working alongside or within a BI team.
• Ability to translate ambiguous business requirements into clear, well-documented data definitions.
• Strong communication skills to explain technical concepts to non-technical stakeholders.

Nice to have

• Experience with Tableau and/or Power BI and understanding of how BI tools consume data models.
• Familiarity with Databricks specifically, including Delta Lake and notebook-based development.
• Experience with semantic layer or governance tooling such as Unity Catalog, dbt Semantic Layer, or Cube.
• Experience mentoring or upskilling colleagues in data tooling.
• Exposure to data observability or data quality tooling.
• Exposure to AI or GenAI data requirements and understanding of what makes data AI-ready.

What the company offers

• Flexible four-day Flexi-Week at full pay with no reduction to annual holiday allowance.
• Flexi-Office and hybrid/remote work possibilities across Awin regions.
• Support and access to various initiatives and sports offers for mental and physical well-being.
• Extensive training suite Awin Academy to nurture professional and personal development.
• Monthly remote working allowance to cover running costs and support for setting up a remote workspace.
• Peer-to-peer voucher program to thank and reward colleagues.

About the company

Awin AG, established in 2000 and part of the Axel Springer group, fosters a dynamic, social, and inclusive culture. The company champions diversity and inclusion, valuing uniqueness and authenticity among its team members.

• Dynamic, social, and inclusive culture established in 2000.
• Diversity & Inclusion are paramount, and the company champions uniqueness and authenticity.
• Awin is part of the Axel Springer group.