Business Intelligence Analyst

Job Advert; Cambridge; On-site; GBP 45,000 - 65,000; Full time

Job summary

Job Advert in St Ives, Cambridgeshire, is seeking an experienced Business Intelligence Analyst to lead the development and delivery of BI reporting and analytics across the organisation. You will work with stakeholders across Distribution, Supply Chain, Finance, Commercial and IT to transform complex data into meaningful information and actionable recommendations that support decision-making.

You will drive performance improvement, reporting consistency and data-led decisions across the

Qualifications

• Advanced Power BI development experience.
• Strong SQL knowledge.
• Experience with large and complex datasets.
• Translate business requirements into analytical solutions and recommendations.
• Experience presenting insights to management-level stakeholders.
• Excellent Microsoft Excel skills.
• Strong analytical and problem-solving abilities.
• Ability to prioritise and manage multiple projects.

Responsibilities

• Lead the design, development and continuous improvement of Power BI dashboards and reporting solutions.
• Analyse data from systems including AS400, Fabric, Manhattan Active WMS, SAP and financial systems.
• Identify trends, risks and opportunities, delivering actionable insights and recommendations.
• Develop and enhance reporting and performance metrics across warehouse operations, inventory and costs.
• Ensure data accuracy and alignment with business requirements across multiple systems.
• Drive automation of reporting processes and broaden analytical capabilities.
• Collaborate with stakeholders to prioritise reporting needs and support operational improvements.

Skills

Power BI

SQL

Data analysis

Excel

Stakeholder engagement

Presentation skills

Data modelling

Education

Bachelor's degree in Business Analytics or related field

Tools

AS400

Manhattan Active WMS

SAP

Microsoft Fabric

Job description

Role: Business Intelligence Analyst

Location: St Ives, Cambridgeshire

Hours: Monday to Friday, 37.5 hours a week

Salary: Competitive

We're looking to recruit an experienced, proactive Business Intelligence Analyst.

This is a key role within the Finance team, responsible for leading the development and delivery of business intelligence reporting and analytics across the organisation. You will work closely with stakeholders across Distribution, Supply Chain, Finance, Commercial and IT, transforming complex business data into meaningful information, insights and recommendations that support operational and strategic decision-making.

You will play an important role in driving performance improvement, reporting consistency and data-led decision-making across the business.

Duties of a Business Intelligence Analyst:

• Lead the design, development and continuous improvement of Power BI dashboards and reporting solutions.
• Analyse data from systems including AS400, Fabric, Manhattan Active WMS, SAP and financial systems.
• Identify trends, risks, opportunities and root causes, delivering actionable insights and recommendations.
• Develop, maintain and enhance reporting and performance metrics across warehouse operations, inventory, transport, customer service, labour productivity, costs, budgets and financial performance.
• Ensure reporting information is accurate, relevant and aligned with business requirements.
• Own the validation, modelling and management of data used within reporting solutions.
• Ensure data accuracy, consistency and adherence to reporting standards across multiple business systems.
• Identify and deliver opportunities to automate reporting processes and improve analytical capability.
• Enhance existing dashboards and increase the accessibility and value of business information.
• Partner with stakeholders across Distribution, Supply Chain, Finance, Commercial and IT to understand business requirements and prioritise reporting needs.
• Deliver business intelligence solutions that support operational improvements and strategic objectives.

What we would like from you:

Essential:

• Advanced Power BI development experience.
• Strong SQL knowledge.
• Experience working with large and complex datasets.
• Experience translating business requirements into analytical solutions and recommendations.
• Experience presenting insights and recommendations to management-level stakeholders.
• Excellent Microsoft Excel skills.
• Strong analytical and problem-solving abilities.
• Experience developing operational and financial dashboards.
• Excellent communication and presentation skills.
• Strong attention to detail.
• Ability to prioritise and manage multiple projects effectively.
• A degree-level qualification in Business Analytics, Data Analytics, Computer Science, Information Systems, Mathematics, Statistics, Finance or a related discipline, or equivalent relevant experience.

Desirable:

• Experience with Manhattan Active WMS.
• Experience with SAP and Microsoft Fabric.
• Experience working with AS400.
• Knowledge of DAX optimisation.
• Experience within Supply Chain, Warehouse or Logistics environments.
• Experience in financi