Senior Data Operations Executive

Ad-Ops London, United Kingdom


Description

Position at Havas Media

Job Specification

 

Job title:

Senior Data Operations Executive

Reporting to:

Data Operations Manager

Skill:

Developing scripts for ETL, marketing automation and custom tagging solutions. Working with APIs and cloud infrastructure. Development of internal tools.

Salary:

£35,000

1ST Interview

2nd Interview

Data Operations Manager

Data Operations Manager, Head of Engineering

Location:

The HKX Building, 3 Pancras Square, London, N1C 4AG

 

 

About Havas Media Group

 

Havas Media Group is the UK’s fastest growing media network, employing the UK’s top media and creative talent to deliver cutting-edge integrated communications solutions. Our companies provide market-leading media planning and buying and creative services across all media channels, with particular expertise in emerging media: digital, data, direct, sports, entertainment, experiential, branded content and PR.

 

Our teams are collaborative, competitive and passionate and above all – unified with an entrepreneurial spirit about the work that we do for our clients. Havas Media Group brands include Havas Media, Havas Sports & Entertainment, Arena Media, Cake, Field Day and others

 

Purpose of the role

 

You will be part of the Engineering team within the wider Data team, reporting to the Data Operations Manager.

 

The main responsibility for the role is to support ETL processes that manage data coming in from multiple data sources. The role involves creating and optimising SQL tables and visualising the output in reporting dashboards. The role will support the delivery of our data solutions, to increase marketing effectiveness through the use of scripts and to improve data processes through automation.

 

The right candidate will have a hunger for knowledge, an ability to deliver outstanding work, have the desire to get involved in all areas of the business. In return, we provide tremendous opportunities for personal development and training and a fun, relaxed working environment.

 

Key responsibilities

 

  • Design, document, develop, test and deploy ETL solutions
  • Work with the Data Operations Manager to improve set processes
  • Help ensure the quality of collected data
  • Maintain a health status report across ETL processes
  • Building client facing reporting dashboards
  • Gather technical requirements from internal / external stakeholders
  • Building relationships with the internal Client Planning and Activation teams across multiple Havas business units

 

Key experience & skills

 

Required:

  • Strong SQL knowledge, especially joining and aggregating data accurately
  • Strong Excel knowledge – pivot tables, vlookups etc.
  • Good communication skills, both written and verbal
  • High degree of numeracy and attention to detail, ability to exhibit critical thinking
  • A degree in Computer Science, Mathematics or a similar technical/scientific degree or equivalent work experience

Desired:

  • Experience using cloud-based data infrastructure (GCP with BigQuery, alternatively AWS or Azure)
  • Experience building data visualisations with Data Studio or Tableau
  • Programming experience a plus, especially Python
  • Experience in an agency environment

 

Who we are looking for

 

  • Enthusiastic and very digital/tech savvy
  • Able to effectively time-manage workloads
  • Keen problem solver
  • Excellent attention to detail
  • Fast learner and methodical thinker