Vacancy: Junior Data Analyst

We are a leading UK furniture manufacturer supplying the B2B contract and commercial market. We are seeking a Junior Data Analyst to transform data into insights that drive real time data driven decisions, sustainable growth, improve product and margin performance, and strengthen customer engagement. The role will analyse data across sustainability, product costing, customer behaviour, marketing performance, competitor pricing, and digital channels to provide clear recommendations for profitable growth.

Key Responsibilities

1. Sustainability Data

• Analyse and report on sustainability performance to meet customer and regulatory requirements.

2. Product, Margin & Competitor Analysis

• Evaluate product profitability and cost-to-serve, supporting data-driven pricing and margin improvement.
• Build and maintain a competitor pricing database to benchmark against market.
• Manage and update the product costing model to track ROI on new and existing product lines.
• Review material cost price adjustments over time, report on by supplier and material type. Work with Supply chain team to target cost reductions.
• Example metrics: product gross margin %, ROI per product launch, competitor pricing variances, component cost trends.

3. Stock & Returns Analysis

• Optimise stock holding to balance working capital, service levels, and obsolescence.
• Analyse product returns and warranty claims to highlight trends and cost impact.
• Example metrics: stock turnover ratio, stock ageing %, warranty claims cost vs sales, returns rate %.

4. Customer Behaviour & Profitability

• Analyse customer data to understand buying patterns, account profitability, and retention.
• Example metrics: average order value, buying frequency, repeat purchase rate, customer lifetime value (CLV), cost-to-serve per account, customer profitability by channel.

5. Marketing & Digital Performance

• Use Google Analytics and other tools to measure marketing ROI and customer engagement.
• Track campaign performance across channels (email, website, digital advertising).
• Provide insight into customer buying behaviour from a marketing lens: order frequency, average order value, lead conversion rates.
• Example metrics: website conversion %, bounce rate, campaign ROI, lead-to-order conversion, time from lead generation to first purchase.

6. Data Mining & Reporting

• Mine existing ERP, CRM, and web data sources to build reports that provide actionable commercial insight.
• Example outputs: customer profitability dashboards, campaign ROI tracker, competitor pricing reports, sustainability scorecards.

7. Cross-Functional Collaboration

• Work with Sales, Marketing, Product, Finance, and Operations teams to align insights with strategy.
• Any other relevant analysis & reporting required by the business
• Present recommendations clearly to both technical and non-technical stakeholders.

Skills & Experience Require

• Strong analytical background.
• Proficiency in Excel, Analytics.
• Experience building and managing competitor pricing and costing models.
• Ability to interpret large datasets and provide clear commercial recommendations.
• Familiarity with ERP/CRM systems in a manufacturing environment (e.g. SAP, Microsoft Business Central, Infor SyteLine).
• Knowledge of ROI analysis for marketing and product launches.
• Strong communication and presentation skills.

Personal Attributes

• Commercially minded, with a focus on profitability and ROI.
• Detail-oriented and curious, with the ability to “tell the story” behind the data.
• Comfortable working across Finance, Marketing, and Sales teams.
• Passion for sustainability, product innovation, and customer value.

What We Offer

• A pivotal role in shaping data-driven decision-making in a growing B2B manufacturer.
• The opportunity to build and manage new data systems (competitor pricing, customer profitability, campaign analysis).
• Career development opportunities across commercial, finance, and marketing analytics.
• Competitive salary and benefits package