Analytics Engineer

JOIN OUR JOURNEY

Medialab is the UK’s leading independent media agency, and one of the fastest growing in the industry. We’re a media agency that’s made differently: purpose-led, data-driven, founder-run and proudly independent.

Our entrepreneurial spirit means success is rewarded and there are no limits to what you can achieve, which our employees agree with, evidenced by being a Campaign ‘Best Place to work’ for the last 5 years in a row, Campaign's Independent Agency of the Year 2024 and The Sunday Times Best Places to Work 2025. We are IPA Effectiveness accredited, an IPA People-First agency and widely awarded including a double-gold at the 2024 IPA Effectiveness Awards for our work with Laithwaites.

Our independence means we can focus 100% on doing the right thing to secure success for our clients and our brilliant people. We work with a wide variety of clients including Hovis, Sharps Bedrooms, SunLife, Standard Life, Laithwaites Wine, EMMA Mattresses, Save the Children, Mind, Guide Dogs, , Alzheimer’s Society, RNLI and Clearscore.

OUR VALUES

• Commit to Doing the Right Thing (Act with integrity and accountability)
• Help People Flourish (Invest in people)
• Dig Deeper to Understand Better (Data driven curiosity)

OUR COMMITMENT TO YOU

Working at Medialab comeswith lots of perks including all the usual things you would expect, such as a competitive salary package, pension, season ticket loans, cycle to work scheme, weekly social events and big summer / end of year parties.

On top of that, we offer extra benefits, which make life at Medialab even more rewarding:

• Time to Unwind – 22 days holiday (+ Christmas holiday closure), birthday & mental health day off, holiday buying scheme, flexi-hours and work abroad scheme.
• Hybrid Working – Balance between home and office. We welcome requests for flexible working arrangements from the commencement of employment.
  Career Growth – A meritocratic approach to progression with quarterly reviews, CPD Platinum accredited training, mentoring and leadership support.
• Health & Wellbeing – Private medical insurance, health cash plan, gym discounts, wellbeing apps Mental Health First Aiders and unlimited free professional counselling.
• Supporting Families – Enhanced parental leave, flexible working and life assurance.
• Giving Back – Paid charity days and sustainability initiatives.
• Perks & Rewards – Retail discounts, long-service trips and an unforgettable team culture.

WHAT YOU BRING TO THE TEAM

You bring a deep understanding of how to transform raw data into clean, reliable and analysis-ready datasets. You’re fluent in SQL and experienced with DBT, with a strong appreciation for scalable, well-structured models that encode business logic clearly and consistently. You think analytically and work methodically ensuring your transformations enable reporting, analytics and activation use cases with confidence.

YOUR NEXT CHALLENGE

As an Analytics Engineer at Medialab, you will:

• Design, build and maintain data models within our DBT codebase, transforming raw data into clean, tested, and documented datasets ready for analytics and activation.
• Onboard new data feeds, working closely with business and technical stakeholders to understand requirements and ensure smooth integration into our pipelines.
• Champion data quality and integrity, troubleshooting issues and ensuring our outputs remain reliable and trusted.
• Collaborate with senior Apollo leads to align our data products with business and client priorities.
• Use and contribute to our Python tooling, whether through writing scripts, enhancing existing tools, or defining requirements and design improvements.
• Partner with analytics, data science and visualisation teams, ensuring datasets are meaningful, intuitive, and optimised for their use cases.
• Support users and team members, sharing knowledge and solving problems effectively.

Must Have Skills

• SQL – proficient; confident in writing performant, well-structured SQL with full understanding of ANSI standards.
• DBT – strong working knowledge; experienced in building, testing, and documenting models as the central tool for transformation and semantic modelling.
• Python – some experience; able to use and adapt scripts and tooling effectively, with an understanding of core syntax and concepts.
• Git – intermediate; solid grasp of core workflows and version control best practices in a collaborative engineering environment.
• Strong communicator - able to engage with both technical and non-technical colleagues.

Nice to Have Skills

• Experience working with GCP (BigQuery) or other modern cloud-native data warehouses (e.g. Snowflake, Redshift).
• Familiarity with data pipelining and orchestration systems (e.g. Airflow).
• Understanding of modern analytics architectures and data visualisation tools (we use Preset.io / Apache Superset).
• Exposure to CI/CD pipelines (GitLab CI preferred).
• Experience with advertising or media data is a plus.