Data Analyst

Skills

Job Specifications

A growing international media consultancy is looking to add an Excel expert with good Power BI experience as a Data Analyst. The role is providing advertising campaign analyses for high-profile brands to help them set budgets and optimise their media spend.

Data Analyst - role

Collect, clean and verify media-spend data
Prepare data for analysis using standard database software.
Build databases and recommend analytical approaches to deliver added insights.
Using proprietary and bespoke tools, analyse media cost and quality performance
Prepare charts, tables and reports
Contribute to team discussions on findings and recommendations.
Work with team to develop interactive models to help clients set budgets
Analyse and forecast economic; consumer; media and market trends for selected countries around the world.

Data Analyst - requirements

Advanced Excel with full proficiency in: Table ranges; Filters; Complex formulas reading and writing (e.g. INDEX & MATCH, VLOOKUP, SUMIS etc); Pivot tables (knowledge of DAX formulae desirable)
Intermediate knowledge of Power Query and M Language (must have)
Intermediate level of Power BI (with knowledge of DAX measures desirable)
Programming skills (VBA, SQL or similar valuable)
Relevant degree with numeracy and analytical skills
Ability to work with large amounts of data
Ability to manage, create and present PowerPoint reports
Willingness to work with high volumes of non-standard data.
Bright intellect, good communication skills; flexible in working time; a team player.

Data Analyst - Benefits

Up to £45k salary + over 10% bonus and benefits
An interesting and stimulating role with a well-established and respected consultancy in the media sector
Learning & Development: opportunity to develop your skills and outlook with an expert team of consultants and analysts
Friendly office in a popular part of London with flexible working opportunity after probation

This is a great opportunity for a skilled Excel expert who wants to develop in the ever-expanding media sector.

Next Steps

If you have the Excel and other skills for this role we'd love to hear from you. Please send a CV ASAP! Next step would be a short telephone call with John Reilly, the recruiter. Please indicate when you’d be available for that.

Excel | Pivot Tables | Analytics | Power BI |

About the Company

Reilly People is one Of The UK's Longest-Established Media, Marketing And B2B Events Recruitment Firms. We've been helping employers grow their businesses, and candidates grow their careers since 1993. We find top Marketing, Media and B2B Event Talent with proven track records that want to work for growing companies. In nearly thirty years in talent acquisition, we’ve worked with clients and candidates all over the UK and most of the world, including EMEA; USA and Asia Pacific. Know more

Related Jobs

Company Name

Davies Talent Solutions

Job Title

Data Transformation Analyst - 6 Month FTC (Remote)

Merseyside, United kingdom

Remote

Full Time

17-11-2025

Company Name

Datatech Analytics

Job Title

Client Data Analyst – SQL & Power BI

London, United kingdom

On site

Full Time

26-09-2025

Company Name

The Consultancy Group (London)

Job Title

Data Analyst

London, United kingdom

Hybrid

Freelance

26-09-2025

Company Name

GIOS Technology Limited

Job Title

IT infrastructure Data Reporting Analyst - (FinOps/Power BI/Data Mapping/Data Visualisation/Fintech/Banking)

Sheffield, United kingdom

Hybrid

Freelance

17-09-2025