Data Analyst (6 Month FTC)

Data Analyst  - 6 Month FTC  (up to £60K 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 looking for an experienced Analytics Engineer to join our team for a 6-month project focused on redesigning and enhancing our data models and reporting layer. This role is key to establishing a robust data foundation using dbt, SQL, and modern data modelling best practices. Reporting to the Lead Analytics Engineer, who oversees the data tagging, modelling, and reporting workstreams, you'll play a critical role in a high-impact initiative aimed at migrating and transforming subscriptions and app data. 

This project is essential to future-proofing our customer proposition and enabling sustained growth. You’ll be working within a large, cross-functional team of over 50 professionals, contributing specifically to the data workstream. Responsibilities will span data platform migration, implementing tracking strategies, rigorous testing, and rebuilding our reporting layer using newly modelled datasets. With tight deadlines and clear deliverables, we are seeking someone who can hit the ground running and provide immediate value through strong technical delivery and collaboration.  

Key Deliverables:  

• Provide subject matter expertise to help shape and guide the overall data modelling strategy for the project. 

• Design and implement intermediate data models to support a comprehensive and unified view of subscriptions data. 

• Lead the planning and execution of MVP data mart development to enable robust, accurate, and scalable reporting.  

• Plan, scope, and initiate the build of fast-follow development phases.  

As a Data Analyst you will;

• Serve as a subject matter expert on data modelling throughout the project lifecycle. 

• Design and implement scalable and maintainable dbt models for our subscriptions data domain. 

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

• Collaborate with data analysts, engineers, and business stakeholders to rebuild reporting marts using the new data model. 

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

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), including advanced modelling techniques and test writing. 

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

Nice to Have: 

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

• Experience with cloud data warehouses such as Azure.  

• Familiarity with data visualisation tools (e.g., Looker, Tableau) and their data requirements. 

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

Tools & Technologies You’ll Work With:  

• Azure Synapse data warehouse  

• dbt for data transformation  

• SQL (Azure T-SQL)  

• VS Code UI for SQL and dbt coding  

• Git/GitHub  

• Azure Orchestration (ADF)  

• Data visualization tools (Tableau)  

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