Data Analyst

PENTLAND; United Kingdom; On-site; GBP 30,000 - 45,000; Full time

Job summary

A leading global family business, Pentland seeks a Data Analyst to support the Commercial Finance function. You will ensure data accuracy, manage reporting processes, and facilitate the transition from Excel to Power BI, contributing to continuous improvement in data reporting.

Qualifications

• Bachelor's degree in relevant discipline.
• Advanced proficiency in Microsoft Excel.
• Effective communication skills for coordination.

Responsibilities

• Maintain and update EMEA customer master data for accuracy.
• Coordinate wholesale sales and royalty submission process.
• Support migration from Excel to Power BI reporting.

Skills

Attention to detail

Communication

Organizational skills

Education

Bachelor's degree in Finance, Accounting, Business, or Data Analytics

Tools

Microsoft Excel

Power BI

Job description

We're Pentland Brands; a dynamic, global family business, and proud owners and licensees of many iconic active and footwear brands. With a community of over 1,300 team members worldwide, we embrace diversity and inclusion, and champion growth and development. Our success is built on teamwork, courage, innovation, and an unwavering commitment to excellence.

WHAT'S THE MISSION FOR THIS ROLE?

The purpose of this role is to support the Commercial Finance function across the EMEA region by ensuring the accuracy of financial data and maintaining core reporting processes. The role involves updating customer master data, validating reporting inputs, managing planning templates, and maintaining regular commercial reporting outputs. The position also contributes to improving data quality and supporting the transition from Excel-based reporting to Power BI, in collaboration with teams in the UK and India.

WHAT DOES THIS ROLE DO?

As our Data Analyst you will be responsible for:

• Maintain and update EMEA customer master data to ensure data integrity, including commercial team assignments, sales channels, regions, budgets, and sales employee mapping.
• Review and flag data accuracy issues within P&L reports to support the reliability of financial reporting.
• Set up and maintain templates for financial planning activities, including Forecasts, Budgets, Three-Year Plans, P&L Consolidation, Growth Plans, and Royalty Outlooks.
• Coordinate the wholesale sales and royalty submission process, including
  
  • Annual rollover of sales templates
  • Quarterly tracking of data submissions
  • Following up with commercial teams on outstanding reports
• Refresh and update recurring EMEA reports, including:
  
  • Weekly Trade Reporting
  • Overdue Orderbook
  • Monthly Integrated Business Planning (IBP) files
• Support the migration from Excel to Power BI reporting by preparing structured data inputs and liaising with Trading Finance and Data Analytics teams.
• Identify opportunities to enhance data accuracy and efficiency in reporting processes, supporting continuous improvement initiatives across the team.

WHAT DO I BRING TO THE ROLE?

To stand out in this role, you should have the following skills and experience:

• Bachelor's degree in Finance, Accounting, Business, Data Analytics or a related discipline.
• Advanced proficiency in Microsoft Excel, including experience working with large datasets, formulas, and pivot tables.
• Strong attention to detail and the ability to manage recurring data processes accurately.
• Organised approach to work, with the ability to meet regular deadlines and follow defined procedures.
• Effective communication skills for coordination across international teams and stakeholders.

Desirable:

• Familiarity with Power BI or other data visualisation tools.
• Experience supporting financial or commercial reporting processes.
• Exposure to shared service or global business services environments.
• Understanding of basic financial and commercial principles related to sales and margin reporting.

We want you to live our company principles, bringing a strong consumer focus, while always looking for ways to improve and grow in your role. Take ownership of your work and be proactive in solving problems whilst communicating openly and treating everyone with respect and kindness. And, of course, let your creativity shine by bringing your unique style and individuality to the Pentland Brands Team.