Finance and Data Analyst An exciting opportunity has arisen for a motivated and enthusiastic team member to join my client's finance function. You will be responsible for providing high quality support and analysis to help them meet their clinical and contractual objectives. Do you have strong Excel skills - including the ability to manage large data files, use Pivot tables and VLookup functions? As well as assisting with the accounting function Excel, you will also be responsible for completing weekly dashboards combining operational and financial information and other ad hoc reporting, so accuracy in dealing with financial information and analytical skills is crucial. You will either have prior experience working in a finance/accounts team and be part AAT qualified or have been working in a data driven role. Candidates who are not current AAT studiers must be educated to A level or equivalent and hold English and Maths GCSE Grade 4 (or C) and above. Prior knowledge of Xero would be an advantage. A qualified workplace mentor is available to provide study support and to help progress your training. Specific responsibilities are likely to include: Data Analysis and Reporting • Monthly reporting of KPI’s from their internal clinical system. • Merge and analyse data sets to populate a database required for compliance data reporting • Produce weekly dashboard data and background data to generate invoicing for NHS contracts • Keep individual trackers up to date to ensure accurate appointment coding Purchase ledger • Deal with day-to-day supplier queries • Prepare fortnightly supplier payment run for approval • Send remittance advices to suppliers Sales ledger • Provide absence cover for processing of invoices and backing data for submission to ICB • Processing private patients card payments from Stripe Month end and year end • Assist with month end balance sheet reconciliations • Bank reconciliation posting payments and receipts where required • Post staff expenses and credit card expenses The role requires interacting with a range of stakeholders including clinical teams and senior management. Good written and verbal communication skills are essential, as is an ability to organise your own workload to ensure deadlines are achieved. You will be able to work independently, as well as part of a team. We endeavour to reply to all applications, however, if you haven`t heard from us within 7 days, you have been unsuccessful with this particular role. You are very welcome to apply to future advertisements placed by Grafters Recruitment Consultants / Grafters Accountancy Personnel