Analytics Engineer

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.