Data Analyst

2 weeks ago


London, UK, 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 |


  • Business Data Analyst

    3 weeks ago


    London, UK, UK, United Kingdom Data Idols Full time

    Business Data AnalystSalary: £450 - £550 per day Outside IR35 Location: Remote Data Idols is working with a global FMCG who are looking for a Business Analyst to join on a contract basis. Your role will involve collaborating with stakeholders across the company to gather business needs, define data domains, and streamline operational processes.The...

  • Data Analyst

    3 weeks ago


    London, UK, UK, United Kingdom Harnham Full time

    Data Analyst- Junior LevelSW London Office - HybridUp to £35,000SQL PowerBI ExcelVideo Gaming CompanyROLEI am working with an exciting gaming company that is looking for a Data Analyst to support them on their campaign to become data-driven as a business.SKILLSThe successful candidate will have:-Experience across SQL, PowerBI, Excel-Strong Communication and...

  • Senior Data Analyst

    1 month ago


    London,, UK, United Kingdom La Fosse Full time

    Senior Data Analyst (Product Analytics)up to £70,000Hybrid, 1 day p/w (London)This is a fantastic role for a Data Analyst who's looking for a new challenge, you will join the business as the pioneering Analyst in a Data Science function. The team have some really exciting projects on and this Analyst will drive the Analytics capability for the team,...


  • London, UK, United Kingdom McGregor Boyall Full time

    Business Data Analyst Price Risk Strategic Data London Overview An industry-leading financial institution is seeking a Business Data Analyst to join a Price Risk project As a Business Data Analyst, you will leverage your in-depth knowledge of trade population control frameworks and data quality controls to help drive the successful delivery of this...

  • Data Analyst

    2 weeks ago


    London,, UK, United Kingdom Computappoint Full time

    This is an exciting opportunity for an experienced Data Analyst to join a global managed service provider who champion a healthy work-life balance.They are looking for someone has can generate reports, dashboards, graphs, and visualisations in a clear & easy to understand format as well as being able to work closely with customers to collate & compile...

  • Data Analyst

    1 month ago


    London,, UK, United Kingdom Diagonal recruitment Full time

    London based - hybrid (ideally 3 days per week in the office)Salary £40k - £45k + 10% bonus + benefitsSQL proficiency is requiredCompany overviewJoin a formidable product team that is shaping the future of online advertising and advertising technology (Ad Tech). Our client (circa 100 staff) is well-funded and growing fast, with innovative solutions and an...


  • London,, UK, United Kingdom Orbis Group Full time

    About the Role:Our client, a leading insurance and asset management company based in London, is seeking an experienced Investment Data Analyst to join their Data Office team. This role focuses on enhancing investment data analysis, improving data quality, and supporting Data Governance initiatives.Key Responsibilities:Collaborate with Investment business...

  • Data Analyst

    4 weeks ago


    London,, UK, United Kingdom Omnis Partners Full time

    Data Insight Analyst Social & Customer £50k & benefits Hybrid / London Office 2-3 daysWork across a range of clients in retail, FMCG and charity industries Act as 'right hand person' to Head of Data to lead on projects Strong skills with SQL, social media listening tools and Google Analytics Basic (or more advanced) skills with Python coupled with...


  • London,, UK, United Kingdom Capital Markets Recruitment Full time

    Our client, a global leading multi-manager multi-strategy hedge fund, is looking to add a Quantitative Analyst to the team of one of their top performng Portfolio Managers. The ideal candiate will have 3-4+ years of experience working directly with alternative data sets (assessing data sets, applying them and modelling them to predict underlying company...


  • London,, UK, United Kingdom Propel Full time

    I'm currently working with a leading on-demand production of customised products such as t-shirts, wall art, mugs, books, hoodies, and cards. Their software connects over 130 top-tier production partners in 32 countries, enabling sustainable, local production with minimal waste and reduced carbon emissions.We are seeking a Data Analyst who is an expert...

  • Data Solutions Analyst

    3 months ago


    London,, UK, United Kingdom Trust In SODA Full time

    Role: Data Solutions AnalystSalary: £90KWorking pattern: Hyrbid – once a week in the office. I am currently working with a start-up who are aiming to revolutionise the insurance industry and are current looking to bring onboard a Data Solutions Analyst. This role combines product management, data analysis, and data visualisation. They are looking for...

  • Data Analyst

    4 days ago


    London,, UK, United Kingdom Camino Search Full time

    Camino Search are delighted to be partnering with a rapidly growing investor backed technology business. The business has gone through multiple funding rounds, expanded internationally and has a well recognisable brand. They're a market leader with diversified revenue streams including subscription services. As a result they're looking to bolster...


  • London,, UK, United Kingdom Orbis Group Full time

    About the Company Pension insurer who buys out defined benefit pension funds in the UK. They then invest that money so have an asset management arm.The RoleThey are looking for an Investment Data Analyst to enhance the Data Office’s Investment data analysis capabilities by driving improvements in the data quality, promoting the adoption of modern...

  • Junior Data Analyst

    2 weeks ago


    London, UK, United Kingdom Goodman Masson Full time

    We are keen to speak with junior data analysts about joining an investment management client of ours, based in Central London. This will be on a 12-month contract with an expectation to be extended or taken on permanently upon completion. This is a hybrid position with 3 days in the office. This role offers a unique opportunity for a Junior Data Analyst to...

  • Social Data Analyst

    2 months ago


    London,, UK, United Kingdom Silverdrum Full time

    Social Data Analyst role at a fast-growing independent performance / paid social agency.Salary to £40,000 + bonus. Based Central London (2 days required in office per week).SummaryThis role has huge growth potential – potentially to grow the team and manage a small department in years to comeAcross a range of clients with a big B2C brand focusYou will...

  • ESG Data Analyst Lead

    3 weeks ago


    London,, UK, United Kingdom Cornwallis Elt Full time

    ESG Data Analyst Lead - Data Science - Investment Management - up to £110,000 Our client, a leading Investment Management organisation based in the City of London, are looking for an ESG Data Analyst to join them on a permanent basis. You will be joining the ESG Data team and assist in the development of a Data Science model.The successful candidate will be...

  • Senior Data Analyst

    3 weeks ago


    London, UK, UK, United Kingdom La Fosse Full time

    Senior Data Analyst up to £55,000Watford (2/3 days p/w)Bonus + attractive benefits packageWe are partnered with a well-renowned retailer who is looking for a commercially minded Data Analyst to drive the BI function forward. You must have a mix of both technical capability and commercial acumen for this role. This is a really exciting opportunity at a stage...

  • Data Analyst

    1 week ago


    London,, UK, United Kingdom Intec Select Full time

    Data Analyst – Pensions - £465 Per Day (Inside IR35) – 6 Month Contract – HybridOverview:An excellent opportunity has become available with our client, a global financial services firm who are currently undergoing an exciting transformation. We are seeking a talented Data Analyst to offer expertise in data services (including data, interfaces, and...


  • London,, UK, United Kingdom Hays Full time

    Join our client’s dynamic and award-winning in-house investment team, managing billions in assets. Our long-established client, based in the heart of the City of London, has created a new Investment Data Analyst position to deliver timely data and reporting to a collaborative and supportive front office team. The Investment Team is at the forefront of the...

  • Market Data Analyst

    3 months ago


    London,, UK, United Kingdom Harrington Starr Full time

    Market Data AnalystMarket Data Administration / Vendor Licences / ComplianceContract (Inside) - Up to £200 per dayWe are working with a leading financial services London-based client of ours looking to bring on a mid-level market data administrator.RequirementsMarket data management systemsRefinitiv and BloombergStrong knowledge of market data and...