Purpose of the Position
Data is at the core of the company’s decision‑making and commercial success. Our mission is to ensure that Awin leverages the full value of its data assets to drive strategic insight, optimise campaign performance, and empower client‑facing teams with best‑in‑class intelligence.
We are looking for an experienced Analytical Engineer to join our BI team and shape the data foundation that powers self-serve analytics across the business. This is an exciting opportunity to establish our Analytical Engineering practice from scratch, working on a modern Databricks stack with Tableau and Power BI as our primary BI tools.
This role sits at the intersection of Data Engineering and BI. You will work closely Data Engineering who own our data pipelines, Databricks infrastructure and data intelligence, and with BI Developers and Insight Analysts who deliver reporting and insight to stakeholders. The purpose of this role is to bridge both worlds, taking reliable data from our reporting layer and transforming it into a trusted, well-documented semantic layer that the whole team can build from. The ultimate goal is to successfully unlock self serve reporting across the organisation.
Key Tasks & Accountabilities
Build the Analytics Engineering practice
- Provide the business context for the mart layers of our data architecture, feeding into BI-ready tables that support self-serve analytics across the business.
- Create a single source of truth for business metric definitions - KPIs, business logic, and calculation rules. This should be accessible to all BI tools.
- Take responsibility for data quality initiatives and own documentation around the semantic layer.
Work across teams
- Partner with Data Engineering to agree handoff boundaries, raise upstream data requirements, and flag quality issues at source.
- 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.
- Participate in regular cross-departmental syncs with Data Engineering to keep both teams aligned.
Upskill and develop the team
- Work closely with the BI Manager to 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.
- Be an internal advocate for Analytics Engineering standards across both the BI team and Data Engineering.
Drive self-serve analytics
- Design data marts with self-serve usage in mind. Clear naming, consistent grain, reliable refresh cadence.
- Work with Insight Analysts to identify which stakeholder questions can be answered via self-serve and model accordingly.
- Reduce ad-hoc data requests by making well-structured, trustworthy data accessible to the business.
- Ensure the semantic layer is AI-ready. Clean, governed, and documented so that AI and GenAI tools can operate on our data without ambiguity.
Skills & Expertise
- Strong, hands-on SQL. Comfortable writing complex transformations, optimising queries, and reviewing others’ code.
- Proven experience with dbt (Core or Cloud) in a production environment.
- Experience working with a cloud data warehouse or lakehouse. Databricks preferred, but others also relevant (Snowflake, BigQuery etc)
- Solid understanding of data modelling concepts: 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. Understanding what BI Developers and Insight Analysts need from the data layer.
- Ability to translate ambiguous business requirements into clear, well-documented data definitions.
- Strong communication skills. Able to explain technical concepts to non-technical stakeholders and align across departments.
Highly desirable
- Experience with Tableau and/or Power BI and an 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. Unity Catalog, dbt Semantic Layer, Cube, or similar.
- Experience mentoring or upskilling colleagues in data tooling.
- Exposure to data observability or data quality tooling.
- Exposure to AI or GenAI data requirements. Understanding of what makes data AI-ready.
Our Offer
- Flexi-Week and Work-Life Balance: We prioritise your mental health and wellbeing, offering you a flexible four-day Flexi-Week at full pay and with no reduction to your annual holiday allowance. We also offer a variety of different paid special leaves.
- Flexi-Office: We offer an international culture and flexibility through our Flexi-Office and hybrid/remote work possibilities to work across Awin regions
- Health & Well Being: With our support and access to various initiatives and sports offers, you can devote yourself to your mental and physical well-being. .
- Development: We’ve built our extensive training suite Awin Academy to cover a wide range of skills that nurture you professionally and personally, with trainings conveniently packaged together to support your overall development.
- Remote Working Allowance: You will receive a monthly allowance to cover a part of your running costs. In addition, we will support you in setting up your remote workspace appropriately.
- Appreciation: Thank and reward colleagues by sending them a voucher through our peer-to-peer program.
- We are hiring in multiple countries, additional benefits in terms of health, well being, security and more will be discussed further upon first initial interview with the talent team.
Established in 2000, Awin is proud of our dynamic, social and inclusive culture.
Like all businesses, we’ve had to adapt and nurture our culture in a virtual environment. Our virtual ‘Life @ Awin’ hub brings our colleagues from across the globe together for various social activities.
Diversity & Inclusion are paramount to us, and we proudly pursue and hire diverse team members. We champion uniqueness and authenticity; this is who we are at our core. Our network of affiliate partnerships are diverse and transparent, as are the employees powering our vision to build the world’s leading open partner ecosystem. We welcome all backgrounds, identities, and experiences. If you need support at any point in the application or interview process, please let us know.
Awin is part of the Axel Springer group. Learn more at axelspringer.com/en/, and explore the Axel Springer Essentials here: axelspringer.com/en/inside/the-essentials-what-we-have-adapted-and-why
Apply now to begin the next stage of your career at a progressive company that supports both your professional and personal development.