Senior Commercial Analyst - 12 Month FTC

Booker Group; Eccles; Hybrid; GBP 40,000 - 70,000; Full time

Job description

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

About the role

We have an exciting opportunity to join Booker's Commercial Finance team as a Senior Commercial Analyst on a 12-month fixed-term contract.

In this senior analytical role, you will play a key part in preparing budgets, forecasts, management accounts, and internal reporting for Booker. You will have primary responsibility for maintaining the IBM Planning Analytics (TM1) database and will work closely with the wider finance team to coordinate, consolidate, analyze, and challenge proposed budgets and forecasts.

Collaboration is essential, as you will also work with the Tesco FP&A team to meet deadlines and resolve queries efficiently. Additionally, this role includes managing one direct report, including conducting bi-annual performance reviews.

We offer a hybrid working model, with 3 days in the office and 2 days working from home per week, subject to business needs.

If you're looking for a dynamic role where you can apply your analytical expertise and leadership skills, we'd love to hear from you!

Main Responsibilities

• IBM Planning Analytics (TM1) Database Management
  • Primary responsibility for maintaining and ensuring the accuracy of the IBM Planning Analytics (TM1) database.
  • Manage data uploads, troubleshoot failed uploads, and reconcile discrepancies between data sources.
  • Maintain data integrity and ensure the accuracy of reports driven from the database.
• Financial Data Preparation & Reporting
  • Gather and prepare actuals, budgets, and forecasts using data from SAP, Business Objects, and the wider finance team.
  • Oversee reconciliation processes to ensure consistency across multiple data sources.
  • Produce and maintain Excel templates and VBA scripts for streamlined financial reporting.
  • Run SQL queries to support management reporting.
• Budgeting & Forecasting
  • Create category manager-level budgets and brand-level budget splits.
  • Collate the group rolling forecast and ensure accurate reporting.
  • Support quarterly sales reporting and produce statutory sales reports.
• Process Improvement & Training
  • Assist with the rollout of new TM1 user training and provide ongoing support for user queries.
  • Drive continuous improvement and development of financial models and processes.
• Ad Hoc Analysis & Strategic Support
  • Conduct ad hoc financial analysis to support decision-making and the ongoing FP&A agenda.

You will need

• Commercial Acumen & Curiosity - Strong business insight with an inquisitive mindset to challenge norms and drive progress.
• Desire to Learn & Add Value - Proactive in identifying opportunities to improve processes and contribute to business success.
• Relationship Management - Skilled at building positive working relationships while confidently challenging assumptions and driving constructive discussions.
• Technical Expertise - Intermediate to advanced Excel skills, including proficiency in data analysis and financial modelling.
• Analytical & Problem-Solving Skills - Strong numerical aptitude, keen attention to detail, and the ability to solve complex financial problems.
• Financial Planning & Analysis (FP&A) - Experience in FP&A preferred, with knowledge of budgeting, forecasting, and financial reporting.
• TM1 Database Management - Responsible for maintaining and optimising the IBM Planning Analytics (TM1) database.
• Budgeting & Forecasting - Preparation of budgets and forecasts, ensuring accuracy and alignment with business objectives.
• Financial Reporting - Providing key financial insights to internal stakeholders at Booker and the Tesco FP&A team.
• Leadership Experience - Line management of one direct report, including performance reviews and ongoing development.
• Accounting Qualification - Qualified or part-qualified accountant (CIMA, ACCA, or equivalent preferred).

What's in it for you

At Booker, along with being a great place to work and giving you an opportunity to get on in your career, we also offer the following fantastic package of benefits:

• A Booker colleague card with 10% off purchases at Booker and double discount events up to three times a year.
• After 4 weeks service, a Tesco colleague discount card with 10% increasing to 15% off most purchases at Tesco for a 4 day period after every four-weekly pay day, ie. thirteen times a year. In addition to 10% off at Tesco Cafe and 20% off all F&F purchases.
• 10% off pay monthly & SIM only deals with Tesco Mobile for yourself, along with further great deals throughout the year.
• Up to 30% off car, pet and home insurance at Tesco bank. Terms and conditions apply.
• Free eye test when you spend £50 or more. You can also save 30% when you spend £50 or more on glasses, prescription sunglasses and contact lenses.
• 50% off health checks at Tesco Pharmacy.
• Exclusive access to discounted RAC breakdown cover rates.
• An exclusive deals and discounts website saving you money on everyday purchases including a cycle to work scheme.
• After 3 months service, you can join our annual Save As You Earn share scheme which allows you to buy Tesco shares in the future at a discount.
• Retirement savings plan (pension) - save up to 5% and Booker will match your contribution.
• Life Assurance - You are covered for death in service life cover of up to three times annual pay.
• Health and Wellbeing support and resources including our 24/7, confidential Employee Assistance Programme and Virtual GP for you and your family.
• A great holiday package.