Procurement Commercial Analyst

Holman; West Midlands; On-site; GBP 45,000 - 55,000; Full time

Benefits offered by this job

25 days annual holiday entitlement (+

Floating Day Holiday in lieu of Birth

Job summary

Holman in the United Kingdom is seeking a Procurement Commercial Analyst to join our Birmingham team. This permanent role pays circa £50,000 depending on skills and experience, with a focus on supplier performance and data-driven procurement improvements.

You will develop relationships with strategic suppliers, analyse data, and support contract negotiations while leveraging Excel, Power Query and Power BI for reporting. Strong numerical skills and stakeholder collaboration are essential.

Qualifications

• Bachelor’s degree or formal data analytical education preferred.
• Proficient in MS Office including Outlook, Excel, Word, PowerPoint, Project, Visio, SharePoint.
• Strong Excel skills: VLOOKUP, PivotTable; intermediate Power Query.
• Experience with ETL principles and data quality management.
• Familiarity with Power BI for data modelling and dashboards.
• Desirable: VBA macros and Python for data analysis.
• Numerate and able to interpret statistical information.

Responsibilities

• Develop relationships with strategic suppliers (top 50% of spend).
• Collaborate with operations, customers and suppliers to identify improvements.
• Maintain knowledge of external market conditions affecting suppliers.
• Lead routine vendor performance review meetings.
• Analyse data and prepare reports for procurement performance.
• Monitor contract terms and renegotiations; manage expirations.

Skills

Excel

Power BI

Power Query

Python

VBA

Data analysis

Statistical knowledge

Education

Bachelor’s degree in data analytics or related

Tools

SharePoint

Visio

Outlook

Project

Job description

At Holman, we exist to provide rewarding careers and better lives for employees and their families. We hire, train, empower, and reward exceptional people. Our journey is guided by our desire to get it right every time and the acknowledgement that we have an opportunity to be better. To be better, we have to do better, and to do better we must know better. That’s why we are listening, open to learning new things – about ourselves and each other. We will never stop striving for improved diversity, equity, and inclusion because we are successful together when we feel trusted and supported. It’s The Holman Way.

At Holman, your total compensation goes beyond your paycheck. To position you for success and provide a rewarding career and better life for you and your family, Holman is proud to offer you the benefits you deserve; including protection against illness, disability, loss of work, or preparation for retirement. Below is a brief overview of these programs (programs may vary by country or worker type):

• Health Insurance
• Dental Insurance
• Life and Disability Insurance
• Flexible Spending and Health Savings Accounts
• Employee Assistance Program
• Retirement Plan
• Paid Time Off
• Tuition Reimbursement

We have an exciting opportunity that has arisen for a Procurement Commercial Analyst to join our growing team here at Holman UK. The role is based in our Birmingham office, near the NEC so please bear this in mind when applying. This is a permanent opportunity and we are looking to pay circa £50,000 depending on skills and experience.

We are looking for someone with a positive, confident, and approachable communication style, with the ability to adapt to accommodate internal stakeholders. You must have a strong work ethic and will need excellent questioning and listening skills with an ability to assimilate accurate information. The successful candidate will need a thirst for process improvement and willing to challenge practices.

Key Responsibilities

• Develop strong working relationships with strategic suppliers (at a minimum, covering the top 50% of spend in given procurement category).
• Communicate and work with operations, customers, customer relations and suppliers to identify, accelerate and remedy poor performance or commercial improvement opportunities.
• Deep, day to day knowledge of overall supplier performance in a large network environment.
• Schedule and lead routine vendor performance review meetings.
• Maintain deep understanding of the external market conditions as they relate to strategic suppliers, i.e. mergers, tariffs, global commodity pricing, competing supplier strategies (e.g. FMC, manufacturers), etc.
• Analyse data and compile reports in support of procurement led performance management activity, contract negotiations, initiatives and opportunities.
• Scorecard Development and Maintenance - Coordinate tracking and reporting on vendor performance measures including VOR, Compliance, Administration and Commercial SLA’s and other established contract compliance and performance metrics. Work with accounting, finance and other departments as needed to ensure that data integrity is properly maintained.
• Conduct remote vendor performance discussions with vendors according to established procedures.
• Ensure that agreement terms are managed, communicate approaching agreement expirations to procurement for re-negotiation, extension or cancellation.
• Perform all other duties and special projects as assigned.

What are we looking for?

• Bachelor’s degree or formal data analytical education preferred.
• Additional education, certifications, or other distinctions are a plus
• Proficient in various desktop tools including MS Office Programs (i.e. Outlook, Excel, Word, PowerPoint, Project, Visio, SharePoint etc.)
• Able to use Excel to an intermediate level. Proven ability with the following Excel skills as a minimum: VLOOKUPs; PivotTable
• Able to use Power Query to an intermediate level. Proven ability to extract, transform and prepare data from multiple sources.
• Proven understanding of ETL (Extract, Transform, Load) principles and data quality management.
• Familiarity with Power BI for data modelling, reporting and dashboard creation.
• Desirable: experience using VBA macros to automate reporting and analysis activities.
• Desirable: familiarity with Business Objects reporting tools and legacy data sources.
• Desirable: knowledge of Python for data analysis and process automation.
• Must be highly numerate and literate with the ability to rapidly understand statistical information
• 5 years of subject matter experience with an vendor data environment
• Proven ability to resolve conflict related to performance complaints
• Demonstrated track record of success in a breadth of prior, challenging experiences
• Proficient in financial modelling and data analysis
• Experienced in basic supplier management practices and/or processes

What's in it for you?

• 25 days annual holiday entitlement (+ 8 bank holidays)
• Floating Day Holiday in lieu of Birthday
• Group Personal Pension Plan
• Death in Service insurance cover
• Critical illness insurance cover
• Free parking
• Health cash plan
• Partners In Excellence rewards – Partner of the Quarter, Partner of the Year, Bonus
• Free Breakdown cover (eligible employees – service related)
• Long Service Awards, Support for further education / employee development.

The need to know parts

• You must have the right to remain and work in the UK.
• You must tell us about any previous convictions or cautions including any deemed as 'spent'. These will not necessarily exclude you from employment but they must be declared at the point of application.
• Please also be aware we do not provide sponsorship for any of our positions advertised.
• We want to positively encourage differences within Holman UK and believe it is critical to our success as a company. Holman UK is proud to be an equal opportunity workplace that seeks to recruit, develop and retain the most talented people from a variety of backgrounds, perspectives, and skills.
• We therefore encourage applications from all genders, races, religions, ages and sexual orientations, as well as parents, veterans, people living with disabilities, and any other groups that could bring diverse perspectives to our business.

Holman is a global automotive leader that serves both commercial and consumer clients The Holman Way by always doing the right thing for our people, our customers, and the community since 1924. The Holman story began nearly a century ago as a single Ford dealership in New Jersey. Today, Holman, headquartered in Mount Laurel, New Jersey, is one of the largest family-owned automotive service organizations in North America with more than 6,500 employees across North America, the UK, and Germany.

Holman delivers a unique range of automotive-centric services including industry-leading fleet management and leasing; vehicle fabrication and upfitting; component manufacturing and productivity solutions; powertrain distribution and logistics services; commercial and personal insurance and risk management; and retail automotive sales as one of the largest privately owned dealership groups in the United States. Guided by its deeply rooted core values and principles, Holman is continuously Driving What’s Right.

Holman provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.