Data Analyst

1 week ago


London Area, United Kingdom Reilly People Full time

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 |


  • Senior Data Analyst

    2 weeks ago


    London, United Kingdom Data Idols Full time

    **Senior Data Analyst** Data Idols are working with an exciting e-commerce company. The team are looking for a Senior Data Analyst to join a growing team working on exciting data projects and supporting the wider data teams. The team is really enthusiastic so are looking for someonewho is equally as passionate and data led. **THE ROLE** Within this role as...


  • London, United Kingdom Data Idols Full time

    Product Data Analyst Salary: £65,000 - £75,000 Location: Fully Remote We are currently looking for an Product Data Analyst to join a fast-growing, innovative, and data-driven tech team within a global cybersecurity education company. You'll play a pivotal role in shaping data strategy and delivering insights that drive smarter decisions across the...

  • Senior Data Analyst

    2 weeks ago


    London, United Kingdom Data Idols Full time

    Senior Data Analyst Salary: £65,000 - £75,000 Location: Fully Remote We are currently looking for an Senior Data Analyst to join a fast-growing, innovative, and data-driven tech team within a global cybersecurity education company. You'll play a pivotal role in shaping data strategy and delivering insights that drive smarter decisions across the...


  • London, Greater London, United Kingdom Data Idols Full time £80,000 - £108,000 per year

    Principal Data AnalystSalary: £80-90k + bonusLocation: UK – RemoteFully RemoteWe are currently looking for an Principal Data Analyst to join our client's fast-growing, collaborative, and mission-driven tech team. In this role, you'll take ownership of their end-to-end analytics strategy, turning complex data into actionable insights that fuel smarter...

  • Senior Data Analyst

    2 weeks ago


    London, Greater London, United Kingdom Data Idols Full time £65,000 - £75,000 per year

    Senior Data AnalystSalary:£65,000 - £75,000Location:Fully RemoteWe are currently looking for an Senior Data Analyst to join a fast-growing,innovative,and data-driven tech team within a global cybersecurity education company. You'll play a pivotal role in shaping data strategy and delivering insights that drive smarter decisions across the business.As an...


  • London, Greater London, United Kingdom Data Idols Full time

    Product Data AnalystSalary:£65,000 - £75,000Location:Fully RemoteWe are currently looking for an Product Data Analyst to join a fast-growing,innovative,and data-driven tech team within a global cybersecurity education company. You'll play a pivotal role in shaping data strategy and delivering insights that drive smarter decisions across the business.As an...

  • Data Analyst

    20 hours ago


    London, United Kingdom Data Science Festival Full time

    Data AnalystSalary: £70K – £80KLocation: London – Flexible workingData Idols are working with a fast-growing, product-led tech company to hire a Data Analyst to join their growing team. This is a key role in the team and this person will directly impact their customers.The OpportunityThe team this person is joining is playing a key role in the...


  • London Area, United Kingdom Women in Data® Full time

    Location:London (Bishopsgate)Do you enjoy Delivering meaningful insights?Are you a problem solver and like to learn new things?About the Business:At Cirium, our goal is to keep the world connected. We are the industry leader in aviation analytics; helping our customers understand the past, present, and predicting what will happen tomorrow. Our mission is to...


  • City Of London, United Kingdom Data Idols Full time

    Product Data AnalystSalary: 65,000 - 75,000Location: Fully RemoteWe are currently looking for an Product Data Analyst to join a fast-growing, innovative, and data-driven tech team within a global cybersecurity education company. You'll play a pivotal role in shaping data strategy and delivering insights that drive smarter decisions across the business.As an...

  • Data Analyst

    3 days ago


    London, United Kingdom Data Science Festival Full time

    Data AnalystSalary: Up to £60kLocation: Remote/HybridData Idols is working with an exciting and fast-growing organisation that is transforming the delivery and logistics space. This is a great opportunity to join a company on an ambitious growth journey, with plans to expand both in the UK and internationally.We’re looking for a Data Analyst with strong...