Data Engineer

An exciting opportunity has become available to be part of our fast-growing team and to be a key part of the IaaS Client Services function. This role provides an outstanding opportunity to join a growing global integrated marketing advisory and will provide an ambitious individual with valuable experience for progression and development.

The Company

mediasense is a global, independent advisor that brings the clarity, connection and confidence modern marketers need to fuel growth. We help marketers eliminate waste and maximize the impact of their most significant investments at scale. Our ambition is to define and own an entirely new category – recognized as the world’s most trusted, independent and impactful marketing advisor. We do this by elevating how clients operate, how agencies deliver, how platforms perform, and how all parts of the ecosystem connect. Because progress doesn’t happen in isolation, it takes alignment, intelligence, and trust. That’s what we enable. That’s what we stand for. That’s Unified Marketing Intelligence.

mediasense is designed around how we help marketers optimize and transform through best-in-class structure and governance (Organization), partners and platforms (Ecosystem), governance and controls (Assurance), and measurement and effectiveness (Science). We have the proven ability to effectively support large, complex organizations and deliver multiple projects simultaneously. As evidenced through our strong track record with clients, we pride ourselves on the consistent high quality of service delivery and the ability to accelerate transformation and growth.

mediasense has over 200 employees across London, New York, Singapore and New Delhi.

For more information, visit www.media-sense.com

What We Offer

• Remote / hybrid working (dependent on your location) - with travel into the London Office as and when needed if remote (expensed)
• Initial 28 days holiday (before bank holidays) with an accrual of 4 days over first 4 years of service
• Day off for your birthday + 10 days annual leave purchase per year
• Length of service awards
• Work from any location in the world up to 4 weeks per year
• Bonuses: Discretionary company bonus scheme & new business bonus, employee referral bonus
• Pension & Group life insurance
• Private healthcare, enhanced parental, Employee assistance program,
• Annual season ticket loan, Cycle to work scheme + Tech & voucher schemes
• Eye test & contribution towards glasses for VDU
• Charity Day plus fund raising events for charity
• Learning & development opportunities
• Frequent events- such as summer, winter & bi-weekly socials
• Free fruit & snacks + building linked benefits such as being dog friendly, access to gyms & complementary gifts, classes or discounts

The Role

This role is for a Data Engineer, based in London/UK (remote option as well as hybrid). This role will report into the Lead Data Engineer, Client Services.

You’ll play a key role in developing and maintaining data pipelines, analytical datasets and calculations that underpin our audience and marketing intelligence offerings - helping clients better understand performance, reach an effectiveness across an increasingly complex media landscape.

The role will be responsible for designing, building and maintaining the data foundations behind client-facing marketing intelligence solutions, including robust data pipelines, clean analytical datasets and reliable calculation logic that support performance measurement, reporting and decision-making.

In this role, your key responsibilities will vary as we work on a project basis, problem-solving for clients on many different types of projects.

Examples of day-to-day work may include:

• Designing, building and maintaining data pipelines using SQL and Python
• Transforming raw data into clean, well-structured analytical datasets
• Implementing and validating calculation and validation logic for performance metrics
• Supporting the delivery of audience and marketing intelligence products used by clients on an on-going basis
• Working with cloud data platforms, primarily Azure and Snowflake
• Collaborating with Associates and Consultants to ensure data structures support insight, reporting and storytelling
• Troubleshooting data quality issues and improving reliability and performance of existing pipelines
• Writing clear, maintainable code and documentation aligned to team standards
• Contributing to the continuous improvement of IaaS tools, templates and ways of working
• Supporting effective project delivery by keeping task status, assumptions and blockers clearly communicated to the project lead, helping work stay on track against agreed timelines and priorities
• Maintaining accurate timekeeping and contribute to efficient delivery by recording time promptly, working within agreed estimates, and flagging any risks to scope, effort or delivery profitability early

The Candidate

We are looking for a Data Engineer with strong SQL and Python skills who is comfortable working across the full data lifecycle- from ingestion and transformation through to analytical modelling and calculation logic. While this is primarily a data engineering role, it also requires an analytical mindset and comfort working with mathematical and statistical concepts.

This role is ideal for an ambitious data professional with 4-8 years’ experience who enjoys building robust data solutions while working closely with Associates with analytical skills and, media subject matter experts and clients to turn data into meaningful insight.

The ideal candidate will have the following:

• 4-8 years’ data engineering, analytics engineering or a closely related role
• Strong SQL skills (essential)
• Strong Python skills for data transformation and analysis
• Experience working with cloud data platforms (Azure, Snowflake, AWS, GCP or similar)
• Strong understanding of data modelling and transformation concepts

Every application is reviewed by a human on our team (not AI), so it may take us a bit of time to get through them. Because of the large number of applications we receive, we’re not always able to reply to everyone individually (especially regarding cv reviews or direct messages) but we truly appreciate your interest.

Please note that can only consider candidates who already have the right to work in the UK and do not require, now or in the future, visa sponsorship.