senior insight analyst

Senior Insight Analyst

Location:
Midlands - Hybrid (2 days in office)

Salary:
£45,000 - £55,000 + benefits

Start Date:
ASAP

The Company

A well-established UK industrial distribution organisation operating in a high-SKU complexity environment. The business serves diverse customers across multiple sectors, managing extensive product catalogues, complex pricing structures, and sophisticated supply chain operations.

With significant investment in data infrastructure and analytics capabilities, the company is building a forward-thinking analytics function that champions data-driven decision-making across all business areas. This is an opportunity to join during a transformational period where data literacy and commercial insight are becoming core to competitive advantage.

The Role

This is a unique opportunity for a versatile and proactive Senior Insight Analyst who thrives on solving diverse business challenges through data. You will act as a critical data partner across the entire organisation - from warehouse operations to eCommerce - delivering insights that drive measurable commercial impact.

The role blends analytical depth with business acumen, storytelling, and a passion for empowering others to use data confidently. You will work with stakeholders at all levels of data literacy, translating complex analysis into clear, actionable recommendations that shape strategic decisions.

This is not a siloed reporting role. You will have variety - one day analysing pricing and profitability, the next helping the eCommerce team optimise digital performance or supporting finance with margin analysis.

Key Responsibilities

Cross-Functional Analysis & Business Partnering

• Serve as the go-to data consultant for teams across the business, supporting stakeholders with varying levels of data literacy
• Deliver insights spanning logistics efficiency, inventory turnover, sales performance, and marketing campaign effectiveness
• Partner closely with senior leaders to shape strategic decisions through evidence-based analysis

Proactive Insights & Storytelling

• Independently explore large, complex datasets to uncover trends, anomalies, and opportunities
• Translate findings into clear, actionable stories through compelling data visualisations and presentations
• Provide strategic recommendations that drive operational improvements and commercial outcomes

FP&A and Financial Analysis Support

• Support the finance team with data for financial planning, analysis, and reporting
• Partner with FP&A to provide analytical perspectives on revenue, margin, and cost trends
• Analyse pricing effectiveness, rebate performance, and profitability drivers

Data Advocacy & Education

• Promote a culture of data-driven thinking across the organisation
• Develop analyses that demonstrate the value of key metrics and evolve into repeatable reports
• Help colleagues interpret data and leverage existing tools to answer their own questions

Technical Proficiency & Automation

• Work hands-on with the company's modern data platform
• Use SQL for querying and joining large, cross-functional datasets
• Apply Python for advanced analysis, data manipulation, and process automation
• Build and maintain Power BI dashboards for ongoing business monitoring

Key Focus Areas

This role will focus on analytical areas central to a wholesale/distribution environment, including:

• Pricing & Margin Analysis: Contract/matrix pricing, price realisation, rebate effectiveness
• Customer & Product Profitability: SKU-level analysis, cost-to-serve modelling
• Working Capital: Order-to-cash cycle analysis, payment terms optimisation
• Inventory & Purchasing: ABC/XYZ classification, purchase price variance, GMROI, excess & obsolete stock identification
• Marketing Analytics: Customer lifecycle analysis, RFM segmentation, promotion effectiveness
• Web & eCommerce: Google Analytics, digital funnel optimisation, online conversion drivers

Skills & Experience

Technical Skills (Essential)

• Strong proficiency in SQL for data extraction, transformation, and complex queries
• Advanced Excel skills for day-to-day analysis (pivot tables, VLOOKUPs, complex formulas)
• Experience with Power BI or Tableau for dashboarding and visualisation
• Familiarity with Python for analytical workflows and automation (pandas, numpy)

Your Experience (Essential)

• Proven background in a data analyst or business intelligence role
• Demonstrable experience working with large, complex datasets
• Track record of delivering actionable insights that influenced business decisions
• Strong stakeholder management and communication skills

Highly Desirable

• Experience within a wholesale, distribution, or supply chain environment with high SKU complexity
• Exposure to ERP systems (SAP, Microsoft Dynamics, Oracle)
• Experience with Salesforce and Google Analytics
• Understanding of inventory management principles and financial metrics

Analytical & Soft Skills

• Exceptional problem-solving ability with a keen eye for accuracy and detail
• Strong business acumen and the ability to connect insights to commercial outcomes
• Excellent communication and presentation skills - able to explain technical concepts to non-technical audiences
• A collaborative, curious, and self-motivated mindset
• Comfortable working in a dynamic environment and managing multiple priorities
• Able to work independently while also contributing to team objectives

Why Join?

You will join a forward-thinking organisation that values curiosity, collaboration, and commercial impact. This role offers:

• Genuine variety - work across multiple business functions rather than being siloed in one area
• Strategic influence - partner with senior leadership to shape business decisions
• Professional development - exposure to modern data platforms and diverse analytical challenges
• Visible impact - see your insights directly influence company performance
• Growing function - help build and shape the analytics capability
• Hybrid flexibility - balance office collaboration with remote working

This is a role for someone who loves the variety of business problems, wants to move beyond pure reporting into strategic insight generation, and is excited to play a visible role in shaping an organisation's data culture.

Interview Process

• Stage 1: Technical assessment (SQL-focused)
• Stage 2: Interview with Hiring Manager and Analytics Lead (competency and technical discussion)
• Stage 3: Final interview with Senior Leadership (strategic fit and approach)

How to Apply

Send your CV to
Mohammed Buhariwala
or connect on LinkedIn to learn more about this opportunity.

Keywords:
Senior Insight Analyst, Data Analyst, Business Intelligence Analyst, SQL, Power BI, Tableau, Python, Distribution Analytics, Wholesale Analytics, Inventory Analytics, Supply Chain Analytics, eCommerce Analytics, Data Visualisation, Business Insights, FP&A, Midlands, Hybrid