Analytics Engineer, Immediate Media Co

• 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
• 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

• 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
• 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
• 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
• 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