A bit about us

Total Media is a leading independent and international media agency that connects people to brands. Our media strategies are based on people’s behaviours – understanding how audiences think, feel and act – so that we reach them contextually, during the moments that matter.

We work across the full spectrum of media planning and buying, with fantastic media teams dedicated to client servicing, broadcast, publishing, digital, data and content production.

At Total Media we are committed to diversity & inclusion and providing equal opportunities for everyone. We are dedicated to ensuring our processes are free from any form of discrimination or bias, right from the application process to life as part of the Total Media Team!

The role

Within this position you will be responsible for:

  • Developing and maintaining Tableau Reports/Dashboards
  • Developing and maintaining data pipelines from various sources (API, GoogleSheets, Databases, Email)
  • Developing Data Models for our Data Warehouse
  • Developing Transformation and Loading SQL scripts to keep our Data Warehouse up to date
  • Developing scripts to leverage our Behavioural Science needs

Clients

An exciting opportunity to work with all our clients across all internal teams. Working with external partners to develop solutions and relationships.

About you

Degree in Computer Science or similar would be ideal, but not essential.

The role requires excellent understanding of:

  • Structured Query Language (SQL) and its advanced functions
  • Tableau or similar Data Visualisation tools
  • Object Oriented Programming and the best practices to create robust and readable code
  • Experience with programming in Python is essential. Other programming languages are valuable
  • Data Warehouse modelling techniques
  • Talend or similar ETL tools
  • AWS environment. Experience with Google BigQuery is highly valuable

Experience

  • Minimum of 1 year experience in a similar role.
  • Experience within Advertising and Media industry is a big bonus, but not essential.

Key responsibilities

  • Developing and maintaining Tableau Reports/Dashboards
  • Developing Transformation and Loading SQL scripts to keep our Data Warehouse up to date
  • Developing and maintaining data pipelines from various sources

Meet the hiring manager

Fred Rabacal - Data Engineer

Fred Rabacal - Data Engineer

Total Media is an exciting place to work as a Data Engineer. There are many different Data Sources and a good number of Data Analysts, so work is never dull. The environment is friendly and relaxed, but high standards of delivery are expected and encouraged.

Complete the form below and attach your CV

Fields with * are mandatory