Excel Data Analyst

Role: Excel Data Analyst

Location: Leeds

Salary: Competitive

Contract Type: Permanent

Are you looking for a new challenge that will involve using your expert MS Excel skills? Then the below role is for you! First bus is actively seeking an expert within Excel to design, develop, analyse & validate data from multiple systems to help add insight, improve data quality & help us to make better decisions! We're looking for someone who wants to become a SME across various systems & support us on our journey towards the design, integration & eventual implementation of a new HRIS. We have a very exciting period of change on the horizon, do you want to be a part of it?

First Bus is one of the country's largest bus operators – taking 1.6 million customers to their destinations every day. We're a forward-looking business at the forefront of bus technology, leading the way on contactless payments, mobile Apps and real time information. Our investment in state-of-the-art, new buses is just one part of our transition to a low-carbon future. It's an exciting time to be here.

Reporting to the People Data Lead, the People Data Analyst will support the wider People team with scheduled and ad-hoc reporting, analytics and meaningful insights to inform and enhance the People Strategy. Furthermore, the People Data Analyst will focus on identifying trends and issues, conducting or recommending further investigations into the people data and providing information to enable HR leads to make relevant informed recommendations to their stakeholders and senior leaders.

The People Data Analyst will also support in the research and investigation of alternative tools and techniques for data analysis; and seeking out new sources of data to enhance the People data offering.

Accountabilities

• Provide accurate People data management to support the people strategy delivery, through the provision of BAU and Ad-hoc People data requests quickly and effectively.
• Work closely with colleagues within the People function to develop suitable tools, dashboards & standard reports and continually look to improve their capabilities, content & quality.
• Review existing People dashboards to ensure they are complete and accurate and follow up with individual areas where there are discrepancies or any need for clarification.
• Gather and summarise data for statutory reports, and internal committees and validate the accuracy of the information.
• Work closely with stakeholders to understand their People data requirements and provide usable data solutions based on findings.
• Work alongside IT to identify People data opportunities across multiple people systems.
• Auditing and peer checking colleagues' system input, feeding back any trends or issues to assist in training and furthering knowledge within the team.
• Supporting the data requirements across People projects including organisational design work, recruitment metrics, talent management and succession planning.
• Adhoc reports for People teams and wider business as and when requested.

Person Specification (role experience / skills and qualifications)

• Expert user of MS Excel (including designing tools & dashboards for end-users; vigorous Look Ups applications to build datasets from multiple system extracts; advanced formula applications such as If, And & Or statements & nested formulas; pivot tables; conditional formatting
• Have an analytical approach, challenging and questioning data and information presented.
• Strong preference for working with numbers, systems and information
• Comfortable in presenting information, in a clear and engaging way, to a wide range of stakeholders.
• Ability to work at pace, operating within tight deadlines and managing several conflicting priorities activities at one time.
• Organised, methodical and comfortable liaising with colleagues to obtain and verify data provided.
• Ability to communicate and build strong working relationships across the business.
• Keen interest in technology and technical improvements;
• Previous experience in a HR environment

Rewards & Benefits

• Your health is important to us which is why we offer Simply Health & Smart Health for you and your dependents at no cost to you! This offering includes cash back benefits across optical & dental as well as virtual GP appointments, mental health support and nutrition and fitness advise. Our EAP provision offers 24hr, 365 days a year mental health support
• We are also committed to your financial wellbeing, and we offer a platform with many discounts on high street brands and supermarkets etc
• Working at First you also receive discounted train travel for you and your family after 6 months service as well as a free bus pass
• Cycle to work scheme
• 25 days' holiday + bank holidays
• Pension scheme and chance to buy discounted First Group shares
• Enhanced maternity / paternity pay
• Flexible working

We put a big focus on physical and mental wellbeing at First Bus. We recognise that anyone can be affected by the stresses and strain of work, or life outside it. You'll find a range of health-promotion initiatives, and you will have 24/7 access to our confidential Employee Assistance Programme.

Please apply now. We look forward to receiving your application.

Public transport serves everyone, whatever their differences. At First Bus, we want to be an employer open to you, no matter what your differences are. We aspire to be an inclusive organisation because diverse backgrounds, thinking and experiences bring so many benefits to our customers, communities and people. We welcome applications from all.