Analytics Engineer

Analytics Engineer (up to £50,000 per annum)

Immediate is home to some of the biggest and most loved consumer brands in the UK, including Radio Times, Good Food and BBC Gardeners World magazine. Our trusted, quality content reaches millions of people a month across digital, print, video, podcasts, apps and live events.

We're the destination for people looking to get more from the things they love. We're here to inspire, fuel, encourage and educate

Whether it's the big things, or the little things; from reaching fitness goals to savouring good food, cultivating outdoor spaces, or enjoying the latest TV sensation - we help bring our audiences joy!

About the Role

We are building towards 3 million subscribers by 2030, and data is central to that ambition. We are looking for an experienced Analytics Engineer to join our Data function on a permanent basis, playing a key role in building the data foundation that powers insight, self-serve analytics and AI-driven decision making across Immediate. Reporting to the Lead Analytics Engineer, you will be instrumental in developing scalable, well-tested data models that are built to be used directly by people across the business, not just to power dashboards.

This is a hands-on technical role suited to someone with a strong command of dbt and Databricks who is passionate about data quality, modelling best practice, and enabling genuinely self-serve, data-driven decisions. You will contribute across the full data modelling lifecycle, from design and development through to testing, documentation and enablement, working as part of a collaborative, cross-functional data team.

We are moving from a reactive, request-driven reporting culture to one where the data team proactively shapes decisions. That means curiosity about the business beyond the ticket in front of you, a willingness to challenge how things have always been done, and comfort with ways of working that are still evolving as we build them.

As a Analytics Engineer, You Will:

Provide subject matter expertise to help shape and guide the overall data modelling strategy across our data domains.

Design and implement dbt models on Databricks to support a comprehensive and unified view of subscriptions and content data.

Build data products, not just reports well-modelled, reusable data sets that power dashboards, self-serve querying and conversational analytics tools, with clear lineage back to source.

Contribute to the ongoing evolution of our data platform by identifying and delivering improvements to data quality, coverage, and performance.

Serve as a subject matter expert on data modelling, supporting analysts and stakeholders in understanding and using our data assets effectively.

Design and implement scalable and maintainable dbt models on Databricks across our core data domains, including subscriptions and content.

Create and maintain a suite of dbt tests to ensure data quality, consistency, and trustworthiness.

Collaborate with data analysts, engineers, and business stakeholders to develop and maintain reporting marts that meet evolving analytical needs.

Support the build-out of self-serve and conversational analytics capability, helping design data structures that natural language query tools can reliably and accurately query.

Participate in code reviews and knowledge-sharing sessions to uplift team capability.

Requirements

Proven experience working as an Analytics Engineer, Data Engineer, or similar role.

Deep proficiency in SQL for data transformation and analysis.

Strong hands-on experience with dbt (Data Build Tool) on Databricks, including advanced modelling techniques, test writing, and performance optimisation.

Solid understanding of dimensional modelling and modern data stack principles.

Familiarity with version control systems (e.g., Git) and collaborative workflows.

Strong communication skills with the ability to communicate clearly and work independently with minimal supervision.

A proactive, curious mindset: comfortable identifying problems and opportunities rather than only working from a ticket.

Desirable:

Experience working with subscription-based business models and datasets is highly desirable.

Broader experience with cloud data platforms such as Azure, and familiarity with Databricks features beyond dbt, such as Delta Lake or Unity Catalogue.

Familiarity with data visualisation tools and BI tools and their data requirements.

Previous involvement in large-scale data migration or re-platforming projects.

Tools & Technologies You'll Work With:

Databricks (primary data platform for modelling and transformation)

dbt for data modelling and transformation on Databricks

SQL (Databricks SQL / Spark SQL)

VS Code UI for SQL and dbt coding

Git/GitHub

Databricks Workflows / Delta Live Tables for orchestration

Modern data visualisation and self-serve / conversational analytics tooling

Benefits

A relaxed working environment with regular socials including a summer festival

Immediate Community webinars, well-being initiatives and Mental Health First aiders

25 days holiday plus a day for your birthday. Our offices will be closed between Christmas and New Year's which are in addition to your annual entitlement

Tailored training and development through our Love Learning platform

A progressive and transparent culture with clear career progression

Flexible / hybrid working plus early finish Fridays

Cycle to work scheme

Enhanced Family Policies including paternity, adoption and surrogacy leave. We also provide a pregnancy loss, fertility, and carers policy

Competitive pension plans and Life Assurance

A newly renovated modern office with lots of collaborative spaces

At Immediate, we pride ourselves on our open, collaborative, and dynamic culture that empowers our people to thrive and give their best. We care deeply about our people, environment, and impact. Our active Diversity & Inclusion network, comprehensive well-being programs, and clear sustainability strategies reflect this commitment.

People are at the heart of our business and creating a diverse and inclusive working environment is extremely important to us. Immediate is an equal opportunities employer. We'll never treat anyone less favourably because of their sex, gender reassignment, pregnancy and maternity, marital/civil partnerships, sexual orientation, race, nationality, ethnic origin, age, religion or belief or disability. We're also committed to supporting applications from those who are returning to work following a career break, maternity leave or caring responsibilities.

Immediate is a place where you can grow, be supported, and make a difference