Department: / Human Resources
Category / Description / Essential / Desirable / Assessment Method
Skills &
Abilities /
- Strong analytical skills
- Intermediate MS Office skills (MS Excel, MS PowerPoint)
- Excel: Pivot tables, Pivot Graphs, Vlookup, match & index, median, average, lower & upper quartiles, formatting data.
- Advanced Excel skills
- One page data summaries which update automatically, macros
- Strong mathematical skills, numerate, able to analyse data, spot trends and potential errors. understands key statistical terms and how they are calculated
- Able to produce work to a high accuracy levels
- IT literate, can research internet to obtain market information or market practice, has previously used and reported from an HR IT system
- Organised, able to prioritise their work and manage their time / work to meet and preferably exceed agreed deadlines
- Ability to communicate clearly and effectively (Verbal & written communication)
- Able to clearly explain Compensation & Benefit theories, practices and provide advice to non C&B specialist such as other HR team members, managers and employees
- Able to design HR statistical summaries on a one page layout which are pictorial, effectively convey the key messages and are easy to understand
- Team Player – effective team member
X
X
X
X
X
X
X
X
X
X / X / Interview & Excel test
Interview & excel test
Numeracy Test
Numeracy & excel tests
Interview
Interview
Interview
Interview
Interview
Interview
Knowledge & Experience / Generally, we would estimate it would take a minimum of 4 years overall work experience including two years previous Compensation & Benefits experience at an Analyst level to perform this role to a competent standard.
Experience of using HR systems and running reports to obtain data using proprietary report writing tools such as Business Objects, Crystal or Cognos.
Experience of representing HR and/or Compensation & Benefits during an HR system implementation from specification to data migration and user testing / parallel runs / X
X / X / CV & interview
CV & interview
CV & interview
Training &
Education / Degree standard of education including GCSE Mathematics and English with a pass mark of C and above
or
6 GCSES including Mathematics and English with a pass mark of C and above, with over 3 years Compensation & Benefits experience
Intermediate Microsoft Office training course (pass) (Excel, Word, PowerPoint, Access and Outlook)
Advanced Microsoft Office training course including Excel, Word and PowePoint (pass)
Visio training to intermediate / X
X
X / X
X / CV & Certificates
CV & Certificates
CV & Certificates
CV & Certificates
Other Requirement / Driving licence with less than 6 points. (Location of the office is in a campus style park outside Watford with on-site parking and limited public transport)
Networks with both internal and external peers effectively
Keeps abreast of Compensation & Benefits developments in the market place
Flexible, willing to work additional hours during work peaks e.g. annual pay review / X
X
X
X / Driving Licence
Interview
Interview
Interview
H:\D05\DATA\PERS\Recruitment\Person Specifications\Person Specification Template.doc