MediaCom

Project Lead - Data Engineering

Job description

Project Lead - Data Engineering

Overview of role

As a data engineering project lead within the growing arm of the Systems Technology team you will assist and lead in the development and automation of data solutions for clients. This is a hands on role and you will be responsible for developing pipelines to help us aggregate many data sources into a single view for clients and indeed MediaCom.

Marketing industry data is often incomplete, inconsistent and stored in silos with access primarily through APIs and FTPs. It is therefore our responsibility to help clients who each have their own requirements for reporting. MediaCom has invested in a technology stack based on GCP and Tableau in order to be able to adapt quickly to differing client requirements. We need a creative, experienced and motivated individual to help lead a team of data engineers and build solutions for integrating data in to the GCP & BigQuery environments.

Reporting of the role

Reports to the Head of Data Engineering and Reporting

3 best things about the job

  • You’ll have access to the latest and greatest in cloud and dashboarding technologies
  • Continuous learning, autonomy & room for development with the best in the industry.
  • You’ll be working in a close knit, friendly team who are there to support you at every stage of your career.
Measures of success

In three months, you would have:
  • Understood Systems Technology’s existing tools and techniques and how we work with the wider agency.

In six months, you would have:
  • Started to build your own contacts network, delivered on 1-2 key projects and be considering improvements that can be made to our tools or processes

In 12 months, you would have:
  • Worked closely with clients to lead and deliver on projects that drive Systems Technology forwards

Responsibilities of the role

  • Manage and contribute to the strategy for MediaCom’s Google Cloud Platform whilst training & assisting others to use the platform
  • Building Python solutions to integrate data from disparate sources into Big Query. This will include APIs and sFTPs.
  • Bringing consistency to our Data handling and schemas across MediaCom clients.
  • Help manage a team of data engineers to deliver successfully on both internal and external projects
  • Ensuring data validation during ETL, defining refresh schedules and SQL storage schemas.
  • Developing and Documenting the data audit, archiving and restoration processes.
  • Working with planning teams to translate functional specifications into technical designs for implementation and deployment.
  • Developing quality standards to ensure data quality and integrity across all database systems.

What you will need

  • Cloud platform knowledge: GCP (Certification advantageous), other cloud platform knowledge would be considered
  • Experience working with Python (R desirable)
  • Experience of working directly with clients and managing stakeholder expectations
  • Experience in building pipelines from various data sources especially APIs.
  • Experience querying databases using SQL

Desirable:

  • Line management experience
  • Experiencing working with tools such as: Jira, Confluence
  • Has worked in a technical team that use Agile, Scrum methodologies
  • Experience of DevOps tools: Github/Gitlab
  • Experience working with digital marketing and/or web analytics data.

About MediaCom

MediaCom is the UK’s largest planning and buying agency, with over 1,400 employees across five offices in London, Manchester, Leeds, Birmingham and Edinburgh.

We believe in People First, Better Results. This means that through investing in our people’s whole-person wellbeing, careers and capabilities and creating a culture of belonging, we achieve brilliant results for both our clients’ businesses and our own. We champion individuality and diversity in our people through an abundance of initiatives and training, and attract and retain the greatest talent in the industry.

Our mission is to See the Bigger Picture for our clients. 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.

MediaCom represents some of the greatest brands in the UK and beyond, both big and small. This includes Sky, British Gas, Sony, Boots, DFS, TUI, The Coca-Cola Company, Tesco and Cancer Research UK. Our client work is celebrated at the industry’s most prestigious ceremonies, and we were named Campaign’s Agency of the Decade for 2009 and 2019.

MediaCom is a member of WPP, the world's largest marketing communications services group, and part of GroupM, WPP’s consolidated media investment management arm. As such, 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.

To find out more about MediaCom visit us here! You can also follow us on Twitter, LinkedIn and Instagram!

*Although we cannot make guarantees, we welcome conversations about flexible working for all roles at MediaCom London*

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.