Role details

Business Analyst

Weybridge   •   £30,000 - £40,000   •  Permanent

Bullet points

  • Budgeting, forecasting, Planning & Analysis
  • SAP, and BW experience highly desireable. Also advanced Excel skills

About Our Client

A well known brand and leader in their field of expertise, based in modern offices in the Weybridge area with lots of free parking and very easy access via public transport.

Job Description

The Business Analyst role involves;

  • Through regular engagement with market, customers and sales teams, validate and collate information to assist with both Sales Management and Strategic Direction.

  • Analyse market data and provide supporting information on UK sales strategy to support branches regarding Branch Strategy, Customer Mix Analysis, GM Analysis, Customer Discount and Rebate negotiation.

  • Assist and inform branch employees to assist in achievement of self-sufficient analytical capabilities.

  • Ensure internal processes and documentation are completed in line with company procedures incorporating analysis, supporting data and alignment with sales strategy as required e.g. ringi validation and calculation.

  • Involvement in the sales budget and revised budget cycles including preparation of the pack file and data analysis.

  • Responsible for operational Sales Forecast (fortnightly). Prepare six monthly forecast based on data received from branches, orders, market and seasonality trends, in liaison with Supply Planning regarding latest availability and short-term trends. Manufacturing will be based on this forecast; accuracy of forecasting is monitored and reported back to senior management;

  • Prepare and validate Operational Sales Forecast (monthly) - based on consolidated information received from branches, product managers and wholesale distribution. Review and analyse data to take account of seasonality and market trends.

  • Sales Updates - prepare updates of previous months' results per unit, product groups, by volume, value and gross margin; plus 4 month sales and orders forecast. Incorporating interpretation of branch forecasts, manufacturing plans, market share information and competitor analysis;

  • Prepare Master Plan quantities for long term production.

  • Ensure proper maintenance and accuracy of data within all reporting systems (SAP, BW, CRM and Dashboard),

  • Upload pricing, rebates and discount levels onto SAP - ensuring all data is accurate, in line with policy and per approved Sales Plan;

  • Prepare analysis of performance against budget (result & pipeline) - per branch and overall to report to senior management. Utililse and analyse results, market data etc. to investigate and advise on anomalies/considerations.

  • Prepare monthly Rebate Report and accrual figures for finance and corporate planning - per discount levels and agreements with customers. Ensure reported/accrued sales figures (SAP, Accounts) reflect correct customer terms;

  • Calculation of commissions - quarterly and year-end. Liaise with other departments to ensure all commission is accurately calculated taking into account changes in customer accounts, discounts, credit control etc.

  • Upload and maintain targets per customer account within SAP, reflecting changes of sales engineer as appropriate through the year;

  • Ad hoc reporting, analysis and project work as required - for senior management, Branch Managers.

The Successful Applicant

The ideal candidate for the Business Analyst role:

  • will have worked in a similar planning and & analysis role.
  • will have strong Excel skills
  • will ideally be educated to degree level in Economics, Business Studies or Similar
  • will ideally have experience of SAP and BW

What's on Offer

The Business Analyst role can pay between £30-40,000 + excellent benefits.

Apply for this job

Click the Apply or LinkedIn button below or contact Chris Royce quoting job reference 6132866
As you are using an Apple iOS device we are unable to offer you the CV upload function. Please apply with your Linkedin profile below or contact Chris Royce quoting job reference 6132866