Senior Data Engineer

Data, Analytics & Insight Leeds, Leeds


Description

Position at MediaCom

Hello. We are MediaCom.

We believe in People First, Better Results.

MediaCom unleashes brands’ growth by helping them See the Bigger Picture. This means that we apply our unique ‘Systems Thinking’ philosophy and technology to all marketing levers: media, message and data. As a result, we design communication strategies that deliver short term results and help brands build for the future.

As part of WPP, the world's largest marketing communications services group, and GroupM, WPP’s consolidated media investment management arm, we have access to the richest data, most robust benchmarks and most advanced capabilities in the market. This helps us provide comprehensive solutions to all marketing challenges.

Our success is underpinned by our long-standing ‘People First, Better Results’ belief. We know that by investing in our people’s whole-person wellbeing, careers and capabilities, we will help grow our clients’ businesses.

In 2020 this approach led MediaCom to be crowned Global Media Network of the Year by Eurobest and Festival of Media Global, in addition to being the most awarded agency at the WARC Media Awards.

MediaCom is one of the world’s leading media communications specialists, with billings of US$17.6 billion (Source: COMvergence, 2020), employing 8,000 people in 125 offices across 100 countries. Its global client roster includes adidas, Coca-Cola (TCCC), Dell, Groupe PSA, Hasbro, Mars, NBC Universal, P&G, Richemont, Shell, Sony, Uber and Walgreens Boots Alliance.

To find out more about MediaCom visit us here:  www.mediacom.com

Role description

As a senior data engineer in MediaCom Systems Technology, you will be building data pipelines from marketing data sources – particularly digital marketing campaign data - into databases hosted on Google Cloud Platform.

Our data engineers are responsible for designing, building and maintaining cloud-based ETL pipelines, working with our dashboard engineers and data scientists to provide clean, up-to-date data for their dashboards and models.

Data sources vary from API connections, to FTP and storage buckets, or manual data entry by users into a system that you have created. You will be asked to lead on best practices for creating and maintaining those connections, designing an environment that centres around Google Cloud Platform and particularly BigQuery.

You will also work with external suppliers on certain data pipelines, integrating their work into our overall cloud environment, ensuring that these suppliers work to our specifications and also learning from them where we are able to adopt new techniques or technology.

You have an analytical mindset, a passion for solving problems and experience building automated data pipelines in a cloud environment. Google Cloud Platform experience is an advantage, along with Apache Airflow and Tableau, though this is primarily a data engineering rather than dashboarding role.

Key responsibilities

  • Maintaining existing data pipelines built in Apache Airflow
  • Working with dashboard engineers to provide data for their reports
  • Working with data scientists to provide data for their models
  • Maintaining a data warehouse, accessible by staff across MediaCom
  • Ensuring data quality
  • Ensuring that data pipelines refresh, with communication of problems to data users
  • Managing external contractors on some data pipelines
  • Building new data pipelines
  • Ensuring best-practices for data acquisition and warehousing

Experience

Essential

  • 3+ years in a data engineering role
  • Experience with cloud databases and data pipelines
  • Coding in Python or R
  • Logical, problem solving mindset

Desirable

  • Apache Airflow
  • Google Cloud Platform and BigQuery
  • Experience working with marketing and/or web analytics data
This is a rare and exciting opportunity to become part of one of the most innovative and progressive Media agencies in the world! As a core member of the team you will have opportunity to help define our product, work with, our industry-leading clients and the chance to build your career & your future the way you want it!

If you feel you have the skills and experience for this exciting and challenging role, we would love to hear from you!

Mediacom is proud to be an equal opportunity employer. We want applicants of diverse background and hire without regard to race, colour, gender, religion, national origin, ancestry, citizenship, disability, age, sexual orientation, or any other characteristic protected by law.