Business Intelligence Analyst

Job Advert; Cambridgeshire and Peterborough; On-site; GBP 45,000 - 65,000; Full time

Benefits offered by this job

5% Company Bonus

25 Days' Annual Leave

Job summary

Job Advert is seeking an experienced Business Intelligence Analyst in Cambridgeshire to lead BI reporting across the organisation. You will transform complex data into insights, partnering with Distribution, Supply Chain, Finance, Commercial and IT to prioritise reporting needs.

The role emphasizes Power BI development, data validation and delivering actionable metrics for operational and financial performance. Strong stakeholder communication and Excel skills are essential.

Qualifications

• 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.

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, 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.

Skills

Power BI

SQL

Data analysis

Stakeholder communication

Excel

Attention to detail

Dashboards

Prioritisation

Education

Degree in related discipline

Tools

AS400

SAP

Manhattan Active WMS

Microsoft Fabric

Job description

Role: Business Intelligence Analyst

Location:Cambridgeshire

Hours: Monday to Friday, 37.5 hours a week

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.

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 financial reporting and cost analysis.

Benefits

• 5% Company Bonus
• 25 Days' Annual Leave, with the option to buy or sell additional days