Performance Analyst/Acces + Excel Developer

My client and NHS Acute Trust based in London is currently looking for a Performance Analyst for a 3-4 month contract with advanced Excel and Access skills.

A key function of this interim role will be to produce routine reports and maintain existing reporting processes. Reports required include:

- monthly and quarterly activity, target and compliance reports to commissioners,
- monthly target and compliance reports in support of the Trust wide

performance management framework

- quarterly returns to Monitor (our regulator), DH and Commissioners
- running reports on the existing information systems, accessing data from multiple sources and bringing together to create a cohesive report

Skills, knowledge and experience required:

- Relevant working experience in NHS
- Advanced working knowledge of Microsoft Office including Excel, Word, Access and PowerPoint, to link data tables into MS Word documents and MS PowerPoint presentations, as well as formatting (A/I).
- Advanced MS Excel 2003 and 2007 skills for data manipulation and reporting, especially in the use formulae including (but not limited to) INDEX MATCH, VLOOKUP, Pivot Tables, Charts, Conditional Formatting, Linking Spreadsheets, COUNTIF, SUMIF, RANK, IF statements, ISBLANK etc (A/T).
- Intermediate Business Objects XI Web Intelligence report writing skills for amending existing reports / queries and exporting data for reporting (A/T).
- Intermediate MS Access 2003 and 2007 skills for amending existing queries, linking tables to MS Excel and exporting data (A/T).
- Ability to express complex issues, both orally and in writing in an easily understood manner for a range of audiences. (I/T)
- A logical and sensible approach to problem solving. (I/T)
- Ability to identify opportunities for improving existing systems and processes. (I/T)
- The ability to organise and prioritise workload and being able to work under pressure. (I)
- Having a pro-active and self motivated approach to completing work to a high standard in conjunction with other staff. (A/I)
- Ability to pay strict attention to detail (A/I)

If you are interested in this role please get in touch immediately for consideration, telephone interviews are scheduled for Wednesday morning.

To find out more about Real Staffing please visit www.realstaffing.com