Contracts Administrator

Line Up Aviation; Hemel Hempstead; On-site; GBP 25,000 - 35,000; Full time

Job summary

A prominent aviation company is seeking a Contracts Administrator in Hemel Hempstead. The role involves managing contracts, analyzing sales data, and ensuring excellent customer service. Candidates should have strong data analytical skills, proficiency in Microsoft Excel, and familiarity with Power BI. This full-time position offers the opportunity to work closely with sales, procurement, and operations teams in a supportive environment.

Qualifications

• Ability to produce timely and high-quality reports.
• Knowledge of MRP functionality and Inventory control will be beneficial.

Responsibilities

• Understanding the contractual demands and analysing ad-hoc vs consignment sales.
• Proactively create customer reports based on parts usage and new demands.
• Working with the Purchasing team to ensure safety stock levels are maintained.
• Developing/improving consignment dashboards.

Skills

Data analytical skills

Proficient in Microsoft Excel

Effective communicator

Flexible and responsive to change

Self-motivated and confident

Education

Bachelor's degree in marketing & sales or equivalent experience

Tools

Power BI

Microsoft Excel

Job description

Overview

We are thrilled to offer a fantastic opportunity for a Contracts Administrator on behalf of my client. As the Contracts Admin for the sales team you will be responsible for ensuring all business demand requirements have been captured from Sales / New Business Opportunities, Consignment Stock and general stock replenishment, monitoring 1500 different products SKUs. This role will work across Procurement, Sales & Operations. Local and international business travel may be required to customer sites.

Role: Contracts Administrator. Salary: Upon Application. Location: Hemel Hempstead. Hours: Full time (8:30am to 5:00pm), Monday to Friday.

Key Responsibilities

• Understanding the contractual demands and analysing ad-hoc vs consignment sales
• Proactively create customer reports based on parts usage and new demands
• Working with the Purchasing team to ensure safety stock levels are maintained
• Being a focal point for the contractual customers whilst ensuring customer service is maintained at the highest level
• Developing/improving consignment dashboards (Power Bi knowledge essential)
• Using data to drive sales, consign new parts to existing customers and target potential customers for contracts
• Maintaining inventory related tasks such as reserving and un-reserving stock, recording expiry dates, correcting stock balances and performing cycle counts at remote sites
• Receiving and reconciling usage reports from consignment customers
• Invoicing consignment customers with monthly usage
• Organising replenishment orders for each of the consignments
• Using PowerPoint to prepare and present monthly/quarterly KPIs
• Managing Contract pricing proposals
• Liaising with warehouse and logistics to ensure consignment shipments are moving on time
• Ensuring the consignment KPI\'s are regularly recorded and conducting quarterly consignment reviews
• Ensuring customer stock levels vs our stock levels are aligned
• Ensuring consistent replenishment / ad-hoc analysis with recommendations
• Providing solutions to open orders through escalation and offering possible alternates

Required Skills & Experience

• Data analytical skills
• Proficient in Microsoft Excel
• Knowledge of MRP functionality and Inventory control will be beneficial
• Effective communicator both written and verbal
• Bachelor\'s degree in marketing & sales (beneficial, not essential) or equivalent industry experience
• Ability to produce timely and high-quality reports
• Flexible and responsive to change
• Self-motivated and confident