Hemel Hempstead, GB
People & Culture Reporting Analyst
Job Title: Reporting Analyst
Location: Hemel Hempstead
Job Length: 18 Month FTC
Working Hours: 35
Competitive Salary with extensive benefits:
- Monthly product allowance – alcoholic & non-alcoholic options available
- Private Medical options
- Life Assurance
- Company bonus scheme
- Access to 24/7 GP services
- Enhanced pension contribution
- Generous holiday (inc bank holidays)
- Access to a range of high street discounts
Carlsberg Britvic is the largest multi-beverage supplier in the UK and is home to some of the most iconic and popular beers & soft drinks, including Carlsberg Danish Pilsner, 1664, Poretti and Brooklyn to ale favourites such as Hobgoblin and Wainwright. For soft drinks, Carlsberg Britvic’s brands include J2O, Robinsons, Tango and London Essence along with the licence rights to the Pepsi portfolio in the UK including Pepsi MAX, 7UP, Lipton Iced Tea and Rockstar Energy.
With a strong national footprint, the Carlsberg Britvic business includes 5 production facilities and 16 logistics depot’s servicing customers up and down the UK. As these two historical businesses have come together, the one common goal remains, and that is ensuring our people succeed.
About the role:
The reporting analyst collects, cleans, and analyses data from our People systems. Reviewing headcount, turnover, hiring, compensation, and employee engagement, to identify trends and patterns. The analyst builds dashboards and reports for P&C leaders and business stakeholders, ensuring data accuracy and consistency. They also help translate complex data findings into clear, actionable recommendations that improve talent management, workforce planning, and overall organisational performance.
Role Responsibilities:
- Data Collection & Management- Extract, validate, and maintain workforce data from HRIS and other people systems, ensuring accuracy and consistency.
- Reporting & Dashboard Development- Design, build, and maintain recurring and ad-hoc P&C reports and interactive dashboards for stakeholders.
- Data Analysis & Insight Generation- Analyse trends in headcount, turnover, hiring, diversity, absence, and engagement to generate actionable insights.
- Data Quality & Governance- Implement data validation checks, maintain data standards, and ensure compliance with data governance and privacy regulations.
- Stakeholder Engagement - Partner with P&C Business Partners and leaders to understand reporting needs and translate business questions into analytical outputs.
- Workforce Planning Support- Provide analytical input into workforce planning, forecasting, and organisational design decisions.
- Process Improvement- Identify opportunities to automate reporting processes and improve efficiency through better data workflows.
- Technical Proficiency- Demonstrate strong skills in our People systems (e.g.SAP SuccessFactors), Excel, Query Manager and visualisation tools like Power BI.
- Communication & Storytelling- Present complex data in a clear, concise manner using data visualisation and narrative techniques tailored to non-technical audiences.
- Analytical & Critical Thinking- Apply statistical reasoning and problem-solving skills to interpret data accurately and challenge assumptions when necessary.
Experience and Key Attributes:
- Advanced Excel Skills- Proficiency in formulas, pivot tables, Power Query, data modelling, and large dataset management.
- Data Querying & Manipulation- Working knowledge of data extraction tools to retrieve and transform data.
- Data Visualisation Tools- Experience using Power BI, Tableau, or similar tools to build dashboards and interactive reports.
- Data Management & Governance- Understanding of data structures, data quality controls, validation techniques, and documentation standards.
- Basic Statistical Knowledge- Ability to interpret trends, averages, variance, correlation, and forecasting outputs.
- Systems Knowledge – Proficiency with HR reporting tools, including SuccessFactors and Query Manager, is preferred and will support effective data analysis and reporting.
Our commitment to diversity equity & inclusion
We welcome applications from people of all backgrounds, identities, and experiences - including those of different races, ethnicities, genders, sexual orientations, ages, abilities, religions, and socioeconomic statuses. We actively seek to create a safe and inclusive environment for all of our colleagues, where diverse perspectives are welcomed, and inclusive practices are embedded in everything we do.
We are happy to support accessibility needs, to ensure a fair and equitable experience for all candidates, so please do let us know if you require any adjustments during the recruitment process.
This is an exciting time to join our newly formed business – with their incredible individual history’s, innovation of products and some of the UK’s most iconic brands, Carlsberg Britvic strives to deliver the best service to our customers and consumers. We aim to make a difference, bringing together two diverse companies, our global reach enables opportunity, growth and a chance to work with some fantastic people.
