Business Intelligence Analyst

Osborne Appointments; Colne; On-site; GBP 55,000 - 65,000; Full time

Benefits offered by this job

5% Company Bonus

25 Days' Annual Leave

Salary Sacrifice Pension Scheme

Private Medical Insurance

Life Assurance of 4x annual salary

Free On-Site Gym

Subsidised On-Site Restaurant

Flexible Benefits Portal

Job summary

Osborne Appointments seeks an experienced Business Intelligence Analyst to lead BI reporting across the organisation. You will design Power BI dashboards, integrate data from AS400, SAP, and other systems, and translate business needs into actionable insights for decision-makers.

You will collaborate with Distribution, Supply Chain and Finance to drive operational improvements, ensuring data quality and scalable analytics across multiple business areas within a dynamic environment.

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.

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

Big data handling

Requirements gathering

Stakeholder presentation

Excel

Analytical thinking

Dashboard development

Communication

Attention to detail

Project prioritisation

Education

University degree in a relevant field

Tools

Manhattan Active WMS

SAP

Microsoft Fabric

AS400

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
• Salary Sacrifice Pension Scheme
• Private Medical Insurance
• Life Assurance of 4x annual salary
• Free On-Site Gym
• Subsidised On-Site Restaurant
• Flexible Benefits Portal, allowing you to tailor your benefits, including an EV Car Scheme
• Family-Friendly Policies
• Discounted Company Products