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 |