People & Culture Reporting Analyst

Hemel Hempstead - UK

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

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 Britvics 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 depots 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 ( 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 historys innovation of products and some of the UKs 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.

Required Experience:

Job Title: Reporting Analyst Location: Hemel HempsteadJob Length: 18 Month FTCWorking Hours: 35Competitive Salary with extensive benefits:Monthly product allowance alcoholic & non-alcoholic options availablePrivate Medical optionsLife AssuranceCompany bonus schemeAccess to 24/7 GP servicesEnhanced ...