Location: ARC, Glasgow

Key Responsibilities

Data Extraction & Automation

• Extract and centralize data from disconnected silos across the organization.

• Develop and maintain automated reporting scripts using Python to replace manual data gathering.

• Create and manage the Master Inventory Position Report.

Process Engineering & Production Mapping

• Engage directly with the Production team to map out currently undocumented activity flow charts

• identify financial gaps, overlaps, and points of consumption.

• Identify bottlenecks and "hidden" costs within the production lifecycle.

• Establish a formal process for tracking production data where none currently exists.

Cost Analysis & Procurement Support

• Analyze the Cost of Goods Sold (COGS) to identify discrepancies and ongoing issues.

• Support the Procurement team in bringing reporting functions in-house as we reduce reliance on outsourced providers.

• Translate complex data sets into clean, actionable Excel dashboards for senior management.

Education/Experience:

• Experience in Operations, Supply Chain, or Data Analysis.

• Note: A formal accounting qualification (Part Qualified) is not required for this role; we value technical data skills and operational curiosity over formal finance credentials.

Technical Skills:

• Python: Python for data extraction, cleaning, and reporting will be advantageous.
• Advanced Excel: Comfortable with formulas, Pivot Tables, and data modeling.
• Platform Agnostic: Ability to quickly learn and navigate various software platforms to find the necessary data.

Soft Skills:

• Communication: Strong interpersonal skills to interview production teams and explain technical data to non-technical stakeholders.
• Problem Solving: A "detective" mindsetyou enjoy finding the root cause of data discrepancies.
• Process Oriented: The ability to look at a chaotic workflow and visualize a structured flow chart.