Media Insight Analyst Job Type Permanent Salary: Up to £40,000 - £42.000 Location: London Hybrid working Consultant: Mags Rendle The Company We are thrilled to be working with an independent, progressive and first-class media agency based in central London with an established and impressive client base. Formed in 1978 they are the Agency of choice for Charities and impactful businesses who are wanting a smart thinking, and faster moving agency who will be making their media work harder in the face of adversity. This is your opportunity to join this independent media specialist with an entrepreneurial culture that has constantly kept them ahead of the agency market and shaped the skills and capabilities they use to give their clients measurable business advantage. The Role We're looking for a talented Media Insight Analyst to join a growing Analytics & Insight (A&I) team and help unify their data landscape into a single source of truth powering our Business Intelligence tools, deep-dive analyses, AI predictive models and wider media planning and buying tools. The role reports directly to the Data Strategy and Analytics Director. The A&I team provides a full-service research and data analytics function - covering a wide spectrum of methodologies from audience profiling and segmentation through to econometrics, TV attribution and structured testing. They take a methodologically neutral approach, designing bespoke measurement frameworks based on our client’s individual business objectives. This is a fantastic opportunity for a Data Analyst with strong digital campaign performance reporting skills and a passion for data analysis to be an integral part of a thriving, profitable business - to help build a strong data offering that will be transformational for our people and our clients. The role will focus on several key deliverables: Liaise with Media/Client teams to establish media campaign reporting and insight requirements and regularity, including involvement from briefing stage to inform campaign setup and relevant metrics Validate and verify input datasets via our ETL platform to ensure correct information is available Create & manage client friendly dashboards and other reports to provide insight on campaign progress Build and deliver meaningful mid and end of campaign performance reports with actionable insight and learnings Maintain client and agency benchmark studies Liaise with external suppliers including data, tech and media companies to ensure top quality service and excellent relationships Power deep-dive analyses to answer questions that unlock the next growth lever for our client’s businesses Enable fast, easy, self-serve BI in every team, helping everyone to spend time on what really matters. The Team The Analytics & Insight team are responsible for leveraging the vast amounts of client data to discover insights, identify opportunities and build data products to drive the business forwards. They do this through the use of statistical, algorithmic and visualisation techniques. As a Media Insight Analyst, you will work with members of the team to scope, plan, build and deliver a range of analytics projects. This could involve supporting the media planning teams with research, customised reports and implementation of bespoke data management processes, supporting senior analysts to build advanced forecasting models, managing a data pipeline to power a visualisation dashboard, or something else entirely different – no two days will be the same. They collect data from dozens of data sources, ranging from industry research, macroeconomic data, web analytics info, transactional data, subscriptions and memberships, customer event-level data, media data, third party data and much, much more. Their data is extremely varied, some being very finely grained, event-level data, others being already aggregated to various degrees. It also arrives on different schedules The business logic they apply to the data is complex and the end uses for data are varied. All this requires well-designed, robust, future-proofed data visualisation and performance reporting skills that can keep up with the business and support our ambitious plans to unlock the value of data strategically. About You A deep interest and enthusiasm in data and using data to support continuous business improvement Exceptional Excel skills (including vlookup, pivot tables and advanced charting techniques) is a major pre-requisite for this role. Use of DAX and Power Query is highly desirable. Solid experience of digital media performance evaluation and reporting – preferably within an agency environment Some experience of working with media data integration tools such as Supermetrics, Improvado, Funnel or Alteryx would be advantageous. Confident in writing SQL and a good understanding of database design. Solid exposure to building and managing marketing performance dashboards using Power BI (preferred) or Tableau would be a huge benefit Experience working with automated data collation through use of web APIs. And you are Pro-active with a self-starter mindset; able to identify elegant solutions to difficult problems and able to suggest new and creative approaches. Analytical, problem-solving and an effective communicator; leveraging technology and subject matter expertise in the business to accelerate our roadmap. Able to document business insight clearly, in plain English, making knowledge easily transferable to the wider team. Confident in presenting analysis, recommendations and strategy to senior stakeholders Highly collaborative in work style Curious and inquisitive Willing to step outside your comfort zone to broaden your skills and learn new technologies. Benefits 25 days Holiday Workplace pension scheme (after probationary period) Flexible working Personalised training program to develop technical, media and career competencies BUPA Employee Assistance Programme Bike to Work Scheme Apply below and I will be in touch to discuss the company, the role and opportunity with you further. The Digital Recruitment Company is an Employment Business for interim, contract and temporary recruitment and acts as an Employment Agency in relation to permanent vacancies. To apply for this role please contact us at: Mags Rendle 0203 640 2133 magsdigitalrecruitmentcompany.com www.digitalrecruitmentcompany.com