Business Intelligence Analyst

OA Recruitment; Cambridgeshire and Peterborough; On-site; GBP 45,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, EV CarScheme

Family-Friendly Policies

Discounted Company Products

Job summary

OA Group is seeking an experienced Business Intelligence Analyst in Cambridgeshire to lead Power BI dashboard development and analytics across Distribution, Supply Chain, Finance, Commercial and IT. You will transform complex data into meaningful information, driving operational and strategic decision-making.

The role requires advanced Power BI development, strong SQL, and experience with large datasets, plus the ability to present actionable insights to senior stakeholders and maintain robust

Qualifications

• Essential: Advanced Power BI development experience.
• Essential: Strong SQL knowledge.
• Essential: Experience with large and complex datasets.
• Essential: Ability to translate business requirements into analytical solutions.
• Essential: Experience presenting insights to management-level stakeholders.
• Essential: Excellent Microsoft Excel skills.
• Desirable: Experience with Manhattan Active WMS.
• Desirable: Experience with SAP and Microsoft Fabric.

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.

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

BEDFORDPERM

By applying to this job advertisement, you confirm you have read and understood our Data Protection and Privacy Statement and give OA Group authorisation to hold your provided data.

Thank you for your interest in this vacancy, which is being advertised by OA Group, who are acting as an employment agency / business. Your application will be considered in competition with others and we will contact you within 3 working days.