The successful Junior Data Analyst - Advanced Excel Specialist - Contract will be responsible for:

• Utilising Power Pivots, Power Query, VBA coding within excel to manipulate, automate and prepare data for key cyclical projects, i.e. Annual Salary Review and Talent Review
• To understand and be able to problem solve data requests, in order to simplify processes and assist the automisation of data where possible
• Frequently audit data to ensure the data is of high quality, spot checking for errors and working collaboratively with relevant colleagues to problem solve issues
• Assist with the data collection for miscellaneous projects and ad-hoc requests
• Understand how to communicate and simplify data problems in a way that's meaningful and simple to understand for all colleagues, regardless of their data skills
• Store, manage and share data securely in a complementary manner
• Up skill People team members and knowledge transfer to enable team to manage data processes independently
• Assist the gathering and presentation of findings of Annual Salary & Talent Reviews on Power Point slide decks
• Assist if needed with the maintenance of ongoing metrics, reports and dashboard administration for key drivers of our business on behalf of the Operations and Projects team.
• If required work with the Data Analyst to drive project plans automating analytic