Data Analyst

Mane Contract Services; Gloucester; On-site; GBP 40,000 - 60,000; Full time

Job summary

Mane Contract Services is seeking an experienced Data/Business Analyst to join an Operational Excellence programme that aims to improve productivity by 30% through data-driven decision-making, lean principles and automation. The role focuses on building Power BI solutions and forecasting models across multiple sites.

This on-site role (Mon–Thu on site, Fri remote) offers exposure to senior leadership and a high-impact transformation across manufacturing and supply chain.

Qualifications

• Degree or equivalent practical experience.
• Experience as Data/BI Analyst or related role in manufacturing, operations or supply chain.
• Experience developing forecasting, planning, production-load or capacity models.

Responsibilities

• Develop forecasting models translating demand into component requirements.
• Build Power BI dashboards to illustrate SIOP performance and constraints.
• Automate procurement KPI extraction and reporting processes.
• Create dashboards for supplier and procurement performance.

Skills

Advanced Excel

Power BI

Automation

SQL

Python

Education

Degree in a relevant discipline

Tools

Power BI

Excel

SQL

Python

Power Automate

Job description

Are you an accomplished Data or Business Analyst with advanced Excel and Power BI skills and a passion for operational improvement? We are looking for a Business Analyst to join a high-profile Operational Excellence programme supporting a group-wide strategy to improve productivity by 30%. Sponsored by the CEO, the programme is focused on site-by-site business transformation through data-driven decision-making, lean principles, digital automation and close collaboration with senior leaders. This is a high-impact opportunity to analyse complex datasets, develop forecasting and planning models, automate manual reporting processes and build Power BI solutions that improve operational performance across multiple sites and functions.

Contract: 6 months, with potential extension Working pattern: On-site Monday to Thursday, working from home on Friday

Key Responsibilities

Configure-to-Order Workstream

• Develop parts-level forecasts using historical sales, demand and production data.
• Build forecasting models that translate product demand into component-level requirements using generalised Bills of Materials.
• Develop analytical tools to identify part commonality across product families and child BoM structures.
• Translate demand forecasts into inventory and supplier stocking requirements.
• Design and maintain forecasting models supporting Operations, Supply Chain and Procurement decisions.

Supply Chain and SIOP Support

• Take ownership of the Line of Balance process, including automated data extraction, transformation and reporting.
• Develop and maintain Power BI dashboards illustrating SIOP performance and key operational constraints.
• Build scenario models to evaluate different production, supply chain and inventory-planning options.
• Own and continuously improve production load and capacity models.
• Provide analytical support for supply-and-demand balancing activities.

Procurement Automation

• Automate procurement KPI extraction and reporting processes.
• Develop repeatable reporting solutions that reduce manual effort and improve data accuracy.
• Create dashboards providing visibility of supplier and procurement performance.
• Identify opportunities to streamline processes through automation and digital solutions.

Supply Chain Performance Analytics

• Develop and maintain performance-management dashboards and KPI reporting.
• Design Power BI solutions providing clear visibility of operational performance against targets.
• Analyse supplier data and develop vendor-performance dashboards.
• Generate actionable insights supporting supplier reviews, operational decisions and continuous improvement.
• Establish standardised reporting and performance-measurement processes across supply chain functions.

Stakeholder Engagement and Transformation

• Communicate weekly with senior site leadership to review findings, align assumptions and maintain programme momentum.
• Present insights, recommendations and programme plans to executive-level sponsors.
• Define tactical implementation plans supporting both foundational improvements and transformational change.
• Coach site process owners to build capability and confidence.
• Lead agreed actions with strong sponsorship from senior site stakeholders.

About You

You will combine exceptional analytical capability with practical business understanding and a passion for automation. You will be comfortable working with large and complex datasets, developing sophisticated analytical models and presenting clear recommendations to senior stakeholders. You should be able to understand business problems quickly, create scalable analytical solutions and deliver high-quality outputs at pace.

Experience and Qualifications

• Degree in a relevant discipline or equivalent practical experience.
• Proven experience as a Data Analyst, Business Intelligence Analyst, Supply Chain Analyst, Business Analyst or Operational Performance Analyst.
• Experience within manufacturing, engineering, operations or supply chain environments is highly desirable.
• Experience developing forecasting, planning, production-load or capacity models.
• Ability to lead individual workstreams and collaborate with cross-functional teams.
• Strong potential to develop into a future leadership position.

Technical Skills

Advanced Excel

• PivotTables and PivotCharts
• Power Query
• XLOOKUP and advanced lookup functions
• Complex formulas and analytical modelling
• Data validation, cleansing and transformation
• VBA and macros would be advantageous

Power BI and Data Visualisation

• Data modelling
• DAX
• Power Query
• Dashboard development
• Performance optimisation
• Executive-level reporting

Automation and Analytics

• Strong experience in process and reporting automation.
• Ability to build repeatable and scalable analytical solutions.
• Understanding of data structures, data cleansing and data-governance principles.
• Ability to convert complex datasets into meaningful business insights and practical recommendations.
• Experience with SQL, Python, Power Automate or similar tools would be advantageous.
• Confident user of Microsoft Word and PowerPoint.

Professional Skills

• Strong analytical and problem-solving ability.
• Excellent communication and presentation skills.
• Ability to synthesise insights from datasets, workshops, interviews and process observations.
• Confidence communicating with senior and executive-level stakeholders.
• Ability to lead workstreams and design processes with cross-disciplinary teams.
• Comfortable working at pace within a complex transformation environment.
• Passion for continuous improvement, automation and data-driven decision-making.