Description

Who are we?
Amplifi is Dentsu's investment and operational arm who are reinventing the rules of media by only making investment decisions that grow their clients’ business.  Amplifi has launched in response to the market dynamics of consolidation and convergence.  We are the media buying specialist of Dentsu and are pioneers in diversified media investments.
Our commitment is to understand how to add value to our clients’ business through investment in brave and innovative ways for the collective benefit of all parties.  It is also our own investment in our people and of their time that will create opportunities for all parties in ways that generate real incremental value.
Through its differentiated proposition Clients, Media and the Industry have come to recognise Dentsu's trading and investment strategy as a commercially valuable and industry defining step change in the advertising marketplace
Role Purpose
Analyse network billing and payable data to identify revenue saving and growth opportunities, then engaging the relevant parts of the business to deploy these strategies by generating actionable insight and recommendations.
Primary Responsibilities
What you will do:
Manage a suite of reports on Tableau Server; ensure existing dashboards are refreshed, maintained and are kept relevant; these reports are used by Amplifi’s management team to support performance management to maximise income generated from our commercial and trading arrangements across traditional media channels and programmatic.
Derive insight from complex data – working closely with the Commercial and Trading teams to provide market narrative and insight to optimise revenue opportunities and identify risk.
Build effective relationship with data stakeholders across Dentsu's brands; form a detailed understanding of locally managed and disparate data sources; identifying gaps and areas for improvement; contributing to rollout of new data collection processes as required.
Maintain documentation, mappings & processes to sustain a trusted single source of truth for all spend & income data
Build a detailed backlog of all analytics & reporting demands. Review & agree priorities for the following year with senior stakeholders.
Supporting Business Intelligence Partner with integration of new data sources
Ongoing and proactive Quality Assurance checks on our source of truth, comparing with internal and external data sources.
Help create a continuous process improvement environment.
Critical Competencies
Can build effective and productive relationships with stakeholders
Strong analytical skills and attention to detail
An eye for clear and effective data visualisation that is rooted in understanding business challenges
Communication and presentation skills to convey complex numerical information to a range of stakeholders in a meaningful and concise manner.
Naturally inquisitive and a flair for identifying problems as well as effective, logical and practical solutions through detailed investigation.
The ability to work effectively in a highly complex, fast moving environment.
Desire to drive best practices across the company
Qualifications
The ideal candidate will have:
a solid background in data analytics
experience working with messy data to solve complex business challenges
experience using Tableau
experience using Alteryx or similar ETL tools
strong Microsoft Excel skills.
experience using SQL
an understanding of best practices in data architecture, ETL & data management