Applications for this job are now closed
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.
About us
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’ culture. We know that by investing in our people’s whole-person wellbeing, careers and capabilities, we will help grow our clients’ businesses.
In 2021 this approach led MediaCom to be crowned Global Media Network of the Year by Adweek and Festival of Media Global, in addition to being Eurobest’s current Media Network of the Year and 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, Hasbro, Mars, NBC Universal, P&G, Richemont, Shell, Sony, Uber and Walgreens Boots Alliance.
About the role
The Data Analytics Executive will support as the custodian of the overall reporting infrastructure and delivery and be a conduit between the reporting & analytics team and the planning teams.
With their knowledge of the data and reporting process, the Data Analytics Executive will train and support the Data Analyst to ensure that the weekly reporting for Dell is delivered in a timely and accurate manner.
Providing the broader Dell planning teams with the dashboards they need to update the clients and optimise campaigns.
The Data Analytics exec will work closely with the planning teams to receive reporting briefs, both regular and bespoke and will be a highly unique and valuable role within the broader Dell team because they oversee all sides of the Dell business, and work closely with both the Consumer and Commercial teams, as well as specialist units (such as search, paid social) and media owners.
Objectives of the role
The data executive will spend equal amounts of time working autonomously to produce the weekly reporting and collaborating with team members on ongoing projects.
They will tap into the ad server and various third-party platforms to extract the data, then run it through a data management platform to ensure it is error free and ultimately prepare the outputs for the weekly reports.
With support from the data analyst and data manager, they will also liaise with members from the broader Dell team to ensure media plans are up to date and delivered in a timely manner, help troubleshoot any issues with data, and work collaboratively to provide solutions with new reporting challenges.
The data executive will also maintain strong relationships with third parties such as specialist teams and media owners to ensure the integration of data into the dashboard goes smoothly.
There are also constant opportunities to evolve the tools and processes we use, and the data executive will always receive full training and support to be able to harness these alongside their team.
3 best things about the job
- The data executive gets to work within a diverse team from all parts of the business, while still afforded the autonomy and creativity to create highly visual dashboards.
- The data executive will gain deep understanding of the impact that marketing has on the client’s sales and brand health, while developing valuable analytical skills.
- The data executive also gets exposure to highly sophisticated data platforms from Google, Facebook, Adobe and other companies at the forefront of data technology.
In 3 months, you will be able to confidently extract the data from the key sources, process it through the data management tool in preparation for delivery as part of the weekly reporting, and troubleshoot issues along the way.
In 6 months, by virtue of familiarity with the weekly reporting ritual, you will have developed a deeper understanding of the two different business units (Consumer and Commercial), each media vehicle and their unique reporting requirements, and be able to confidently tailor solutions for each accordingly and start applying your knowledge into the wider analytics remit within the team.
At the end of your first year, you will be the main champion of all aspects of the report-running process, owning every single step of the reporting infrastructure and having a palpable imprint on the tools in the spirit of refining and improving the overall process. You will be an expert on reporting & analytics needs of each team and media vehicle, and you will have developed strong and close relationships with all the key internal stakeholders.
What we’re looking for in you
- Have sound understanding of Excel and know basic formulae.
- Have some familiarity with programming languages and coding, and a desire to learn.
- Be numerically minded and can apply lateral thinking to solve problems.
- Have an interest in the media and advertising world, especially in the digital age.
- Have a hunger to constantly learn, never afraid to ask questions but also self-sufficient in seeking answers.
