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 |