Commercial Analyst

The Commercial Analyst will support the Commercial Business Analyst and the wider sales and finance teams by preparing reports, analysing data, and maintaining key datasets. This role is ideal for someone who is comfortable working with Data Visualisation tools alongside manipulating large datasets to create bespoke reporting and analysis using Microsoft Excel. You will assist with performance reporting, costing, and pricing analysis, data preparation, and process improvement activities. This is a hands-on role with excellent career progression. Key Tasks And ResponsibilitiesReporting & Data Analysis

• Support the development and maintenance of regular financial and non-financial performance reports.
• Build and update commercial reports, dashboards, and trackers.
• Assist in turning raw data into clear insights and visualisations for stakeholders.
• Provide ad-hoc analytical support, including performance analysis and basic forecasting.

Commercial Support

• Assist with the preparation and maintenance of costing models and pricing data.
• Help monitor sales trends, customer performance, and key commercial metrics.
• Support competitor and market analysis activities.
• Contribute to the preparation of presentations for key stakeholders.

Process Improvement & Systems

• Support continuous improvement of reporting processes and data quality.
• Assist with data collection, documentation, and organisation of key systems.
• Help develop and enhance reporting automation where appropriate.

Person SpecificationEssential

• Previous experience in a commercial role
• Working knowledge of Microsoft Excel (formulas, pivot tables, lookups, charts).
• Comfortable handling and interpreting large datasets.
• Strong numerical and analytical skills with excellent attention to detail.
• Ability to communicate data clearly and simply.
• Proactive, organised, and eager to learn.
• Interest in commercial performance, finance, or data analysis.

Desirable

• Exposure to Power BI, Tableau, Qlik, or other BI/reporting tools.
• Basic understanding of budgeting, forecasting, or variance analysis.