Data Analyst

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 |