Analytics Engineer

Immediate Live Co; Greater London; On-site; GBP 30,000 - 50,000; Full time

Benefits offered by this job

Flexible / hybrid working

25 days holiday

Career development

Job summary

Immediate Live Co is hiring an Analytics Engineer to build scalable data models on Databricks using dbt, delivering self-serve analytics for cross‑functional teams. You’ll shape data quality, implement tests, and partner with stakeholders to enable AI‑driven decisions.

The role is hybrid with a focus on robust data foundations, keeping dashboards and analytics reliable across business domains.

Qualifications

• Strong SQL for data transformation and analysis.
• Deep proficiency in dbt on Databricks with modelling techniques.
• Familiarity with modern data stack principles and dimensional modelling.

Responsibilities

• Design and build dbt models on Databricks for unified subscriptions/content data.
• Create reusable data sets powering dashboards and self-serve analytics.
• Ensure data quality with tests and maintain clear data lineage.
• Collaborate with analysts, engineers and stakeholders across the business.
• Support self-serve and conversational analytics capabilities.

Skills

SQL

dbt

Databricks

Data modelling

Git

Experiened with data stacks

Tools

Databricks

dbt

VS Code

GitHub

Delta Live Tables

Job description

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 an 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.
• Provide guidance on data modelling best practices, performance optimisation, and modular design in dbt.
• Participate in code reviews and knowledge‑sharing sessions to uplift team capability.
• 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

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