Business Intelligence Analyst Job at Dentsu Aegis Network | The Dots
Job Expired
72 days ago
  • Level Mid Level
  • Professions Data Analyst, Business Strategist
  • Type Full Time
  • Location London, United Kingdom

Like this job? Notify me with jobs that are similar

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

Skills Required

  • Data Analysis
  • Business Strategy

People who have worked with Dentsu Aegis Network