Excel jobs in United Kingdom

Junior Data Analyst page is loaded## Junior Data Analystlocations: UK - Harrogatetime type: Full timeposted on: Posted Todayjob requisition id: JR107919Because NaughtOne don’t make furniture for your home, you probably don’t know us. But LinkedIn, Google and Adobe do – because they all have our designs in their workplaces. The NaughtOne team are just as unique as the furniture we create and if you come to work with us, you’ll be joining a global business with a Yorkshire spirit. We have colleagues all over the world because the world is our customer, but our personality reflects our home: down-to-earth, friendly and honest.We’ve received numerous accolades, including The Queens Award for Enterprise for International Trade, and that makes us proud. We’ve always cared deeply about sustainability and we’re always looking for ways to do more and have a stronger impact. We don’t do it because it’s good for business – we do it because it’s the right thing.If any of that makes you curious, good – because curious people thrive at NaughtOne. Perhaps you’ll be thriving at NaughtOne soon.**Data Analyst**Location: Harrogate**Role Purpose**We are a leading UK furniture manufacturer supplying the B2B contract and commercial market. We are seeking a 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 packageAt NaughtOne we believe in keeping things simple. So simply put, we hire qualified applicants representing a wide range of backgrounds and abilities – we are committed to equal opportunity employment. We honour and celebrate people's individuality, diversity and authenticity. In this inclusive environment, we thrive together, creating endless opportunities for us all to shine. Here, you can bring your whole self to work.MillerKnoll complies with applicable disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact MillerKnoll Talent Acquisition at careers\_help@millerknoll.com.