Skip to main content

Commercial Data & BI Analyst

Published 24 June 2024
£50000 - £53000.00 per annum + Hybrid Working Available
Leicester, Leicestershire
Job Starts: 24th June 2024
Data Analytics

Job Description

Macildowie Recruitment & Retention - Data, BI & MI Analytics
Commercial Data / BI Analyst - Up to £53,000 - Leicester
Monday - Friday, 9am - 5pm - Hybrid Working Available - Permanent

Macildowie Data Analytics is proud to collaborate with a PLC listed organisation in Leicester to recruit a Commercial Data & BI Analyst to join our client's international finance function.

The key objective is to understand commercial analytics whilst building and nurturing positive relationships with internal stakeholders to create user-engaging BI/MI through Excel and PowerBI, reporting on key customer trends, customer buying patterns, budgeting and forecasting.

Main Responsibilities

  • Confidently collaborating with internal stakeholders to construct appropriate value-adding commentary ensuring that the BI/MI you're reporting is user engaging and tells a story.
  • Extracting data from core systems whilst partnering and cooperating with finance and the wider teams to identify trends creating new purposeful BI/MI on customer sales, customer buying patterns, customer returns, forecasting, budgeting and overseas / competitor trends, creating dashboards on a weekly, monthly basis using Excel and PowerBI.
  • Creating financial performance reports against forecast working to identify tactical areas of growth.
  • Transforming complex data into actionable insights that drive business growth and optimise performance.
  • Cooperating with stakeholders to provide appropriate value-adding commentary helping our client identify gaps and explore.
  • Identify opportunities to automate data processes and implement data quality control measures.
  • Build a comprehensive and context driven, understanding of returns rates for use in modelling by income stream, adapting attributes to consumer returns behaviour and adjusting to numerous markdown events.
  • Modelling total returns risk and managing the value held in the businesses balance sheets.

The Candidate

  • Previous experience operating as a Commercial Analyst, Commercial Finance Analyst, Finance Analyst, BI Analyst, BI Developer, BI Analyst, MI Analyst, Data Analyst or in a similar position.
  • Ability to create meaningful, clear dashboards with appropriate value-adding commentary.
  • Proficient in using data reporting tools such PowerBI including DAX and Excel.
  • Excellent communication skills.
  • Able to commute to Leicester.
  • Comfortably able to read and query SQL code.
  • The ability to convey complex data sets to stakeholders, ensuring the BI/MI tells a story and is user engaging.


  • Bonus scheme - dependent on profit performance.
  • Employee ShareSave Scheme.
  • Electric Car Scheme - salary sacrifice.
  • Staff discounts.
  • Free parking on site.
  • On-site nursery.

The first stage of the application process is to apply online. If you would like any more information about this vacancy before applying, please get in touch with Tom Whitsey.

Please put your home postcode on your CV when applying. Our recruitment tech uses this to make sure your CV is reviewed by the relevant consultant, for the relevant job(s), in the relevant geography.

Macildowie are a recruitment business working on behalf of a client to recruit this role. Your personal data may be forwarded to that client company as part of the application process.

If you would like information on how we will process your data please go to our website ( and view our fair processing notices which are located at the bottom of the page under privacy policies. Within the fair processing notice for Candidates there is guidance on how to amend your contact preferences or exercise your rights relating to personal data. We can't provide direct links as email address and website urls within our job adverts are removed by some of the websites on which we advertise.

Macildowie is a specialist recruitment consultancy with a rich history of enhancing the careers of professionals across the Midlands and the Northern Home Counties. We have an unrivalled understanding of the local market place and recruit for the majority of the region's premier employers. To search for all of our live jobs please visit us at

Share this Job