Systems and Data Analyst (Advanced Excel)

  • Location
    London, Greater London
  • Salary
    £ 24000 - £ 26000 / Year
  • Category
    IT - Business/Systems Analysis
  • Job type
    Contractor
  • Industry
    IT and Telecoms
  • External Reference
    JN-112020-152560

++++++++++ Fixed Term Contract +++++++++



THE ROLE:


Work as part of the project team on implementations or renewal projects for products and solutions including Employee Benefits and Reward and Recognition. Responsible for the system(s) configuration, data management, testing, launch and reporting phase for a portfolio of clients.



MAIN DUTIES:



  • Support to the Consultant and Project Management team in identifying the optimal solution to client requirements across products and solutions.



  • Support Account Managers and Project Managers in implementation of new clients, carry out scheme implementation (create and customise new sites, SSO, integrate with client's platform).



  • Loading and configuring flex, total reward statements and employee savings sites for clients using in-house and third party systems for an implementation project for a new sale or an annual renewal project for an existing client.

  • Creation and maintenance of process and data templates to manipulate incoming employee data files to identify where employees are joiners, leavers or have data changes which trigger processing within the back office system.

  • Creation of data templates to manipulate data from the system in MS Excel to create reports, data files and Management Information.

  • Manipulation of data from multiple data sources in either MS Excel or MS Access to merge the data, calculate appropriate values and present this in a format suitable for either loading into the system for an on-line TRS or as a data source for offline paper TRS.



  • Loading initial data for clients using the back office system.

  • System testing and support for the client user acceptance testing for implementation and renewal projects.

  • Compile and maintain process documentation for all schemes to a level that allows others to support the client or handle a subsequent project for any client.

  • Support to the rest of the Client Delivery team in the processing of ongoing employee data, , monthly flex elections/updates and the production of payroll and provider reports for flexible benefits clients.

  • Day-to-day support for team leader/manager in management of clients, including resolving queries in central mailbox, making changes and ad-hoc processing and ensuring teams schedules and deadlines are met.

  • Work to project schedules and deadlines as agreed with line manager.



KNOWLEDGE & SKILLS:



  • Advanced Excel skills

  • Good knowledge of Microsoft Office products

  • Confidence in working with and understanding data

  • Ability to collect and manipulate data to ensure the accurate creation, launching and on-going maintenance and updates of clients schemes

  • Ability to work accurately, consistently and in a timely manner with data

  • Work within a team to manage multiple clients

  • Ability to work under pressure and as part of a team

  • Commitment to quality and customer service

  • Experience and knowledge of the benefits market preferred

  • Experience of Zest employee benefits platform is preferred

Adecco acts as an employment agency for permanent recruitment and an employment business for the supply of temporary workers. The Adecco Group UK & Ireland is an Equal Opportunities Employer.


By applying for this role your details will be submitted to Adecco. Our Candidate Privacy Information Statement explains how we will use your information - please copy and paste the following link in to your browser https://www.adecco.co.uk/candidate-privacy

Please apply with your CV to: Jade Coakley