TL;DR

Analytics Engineer: Designing and building dimensional data models and dbt pipelines for business-ready data, focusing on creating a consistent semantic layer for reliable reporting and analytics. Focus on modernizing data estate, implementing data quality checks, and collaborating with cross-functional teams.

Location: London-based with a hybrid model (2 days per week in the office)

Company

%hirify_global% is a family-owned media business focused on creating content for millions of people across Europe, spanning print, online publishing, and audio broadcasting.

What you will do

Design and build dimensional data models and marts using dbt and Kimball principles.
Develop and maintain dbt pipelines for transforming raw data into gold-layer marts.
Define and maintain a semantic layer for consistent metrics across BI tools.
Contribute to the migration from Redshift/BigQuery to Snowflake.
Implement data quality checks using dbt tests and Great Expectations.
Collaborate in agile squads, participate in code reviews, and maintain documentation.

Requirements

Strong SQL skills (Redshift or BigQuery experience; Snowflake preferred).
Hands-on experience with dbt (models, tests, production environments).
Solid understanding of dimensional modelling (Kimball-style).
Familiarity with semantic layer design and BI tools (Looker, Power BI).
Practical Python experience for data engineering tasks.
Agile team experience (Jira, Confluence) and Git-based workflows.
Cloud experience (ideally AWS).

Nice to have

Advanced Snowflake experience.
Exposure to Airflow, Great Expectations, and dbt-expectations.
Familiarity with Tableau and multi-tool BI environments.
Knowledge of CI/CD, Infrastructure-as-Code (Terraform).
Industry experience in media, digital audiences, or subscription businesses.

Culture & Benefits

You'll have 28 days holiday, bank holidays & 2 volunteer days to use.
Access to internal training via Bauer Academy.
Enhanced Maternity/Adoption, Paternity and Shared Parental Leave Pay.
Opportunity for flexible working.
Commitment to ensuring an inclusive and accessible recruitment process.