Description:
This is an exciting opportunity for a Media Insight Analyst to join a thriving media agency in central London. You will work within the Analytics & Insight (A&I) team to help unify data and create actionable insights for the agency’s clients. You will be responsible for liaising with media teams, reporting on campaign performance, and ensuring the effective use of Business Intelligence (BI) tools.
Key Responsibilities:
- Collaborate with Media/Client teams to establish campaign reporting and insight requirements.
- Verify input datasets via the ETL platform to ensure accurate data.
- Manage and create client-friendly dashboards and reports to track campaign progress.
- Conduct deep-dive analyses to drive growth opportunities.
- Work with external suppliers to ensure top-quality service.
- Power Business Intelligence tools and facilitate self-service BI across teams.
- Regularly update and deliver performance reports with actionable insights.
About the Team: The A&I team works with vast amounts of client data to drive business improvements using statistical, algorithmic, and visualisation techniques. You will work on a variety of analytics projects, helping clients use data strategically for improved business performance.
Requirements:
- Proficiency in Excel (VLOOKUP, Pivot Tables, advanced charting techniques). DAX and Power Query are highly desirable.
- Solid experience in digital media performance evaluation and reporting, preferably in an agency environment.
- Experience with media data integration tools like Supermetrics, Improvado, Funnel, or Alteryx is advantageous.
- Confident in SQL and database design.
- Experience building and managing performance dashboards using Power BI or Tableau.
- Exposure to automated data collation through web APIs is a plus.
Qualities:
- Proactive, self-starter, and solution-oriented.
- Strong analytical, problem-solving, and communication skills.
- Collaborative work style and ability to present analysis to senior stakeholders.
- Willing to learn new technologies and broaden skills.
Benefits:
- 25 days holiday.
- Workplace pension scheme (after probationary period).
- Flexible working options.
- Personalized training program.
- BUPA Employee Assistance Programme.
- Bike to Work Scheme.