We are looking for an Analyst to join our manufacturing clients Commercial Team and play a key role in driving data-informed decision-making. This role is an initial 12-month Fixed Term Contract and will be delivering data insights that support strategic planning, sales performance, pricing strategy, and overall commercial growth.
The Commercial Analyst supports in 5 key areas:
OTE Programme Support
- Using the ERP & CRM, perform advanced Excel data manipulation, mapping, and complex formula modelling to support the programme.
- Identify and resolve anomalies in collaboration with Regional Sales Teams/Heads of Sales.
Sales Forecasting
- Support forecasting by preparing data, ensuring accuracy by cross-checking with Salesforce interface outputs and Excel.
Dashboard & Analytics Development
- Maintain reports and dashboards, creating new dashboards and reports on request.
- Maintain responsibility for Salesforce dashboards and regional reporting requirements.
Product Forecasting
- Update Excel product forecasts using ERP and CRM data.
- Identify improvements, automation and AI opportunities.
Pricing
- Share responsibility for global pricing requests to support global sales teams and collaborate proactively to refine and improve pricing processes.
- Support with pricing queries, using the pricing model.
Key skills of the Commercial Analyst:
- Advanced Excel capability including complex formulas, data modelling, mapping, v-lookup, pivot tables, IF statements.
- Experience with Power BI, Tableau or similar, for reporting and dashboard development.
- ERP and CRM experience preferred.
- A strong analytical mindset with exceptional attention to detail.
- Proactive, collaborative, and improvement focused.
- Able to manage multiple deadlines in a fast-paced environment.
- Proven ability to communicate complex data findings to non-technical stakeholders.
This business is offering hybrid working, and a friendly, team-orientated culture. Great benefits offered including 25 days holiday (option to purchase up to 5 days annual leave), a generous bonus and pension scheme, Westfield Health Plan, employee assistance programme, life assurance, cycle to work scheme, recruitment referral scheme, and Christmas shutdown.