Job summary
An exciting opportunity has arisen at our head office for a Data & Finance Assistant. This post will be an integral part of the wider
finance & performance department function and has a key part to play in the
accurate, effective, and efficient delivery of department objectives.
The post requires excellent IT skills and an ability to work to strict
deadlines as part of a small but flourishing team.
Main duties of the job
Data Analytics
- Producing daily/weekly service performance reports for Internal Stakeholders, including analysing local trends that impact the organisation
- Completing Weekly Minimum Data Set templates for CCG & NHSE Submissions to specification
- Producing Monthly KPI Contract reports for internal/external stakeholders enabling them to take important business decisions based on various facts and trends
Support business leads with any ad hoc
information requests in a timely manner
Performing analysis to assess data quality and
understand what information is needed from the systems. Suggesting solutions to
aid the business ensure contractual data can be captured.
Removing erroneous data and fixing coding/data
entry errors and related problems (through Excel & EMIS Reporting)
Developing and maintaining databases, data
systems – structuring data into a readable format to enable automated
reporting
Using automated tools to extract data from a
range of primary and secondary sources daily (EMIS Search &
Report/SAGE/Excel Power Query)
Financial Accounts
- Process purchase invoices collect relevant approvals and resolve queries that may arise.
- Processing of expenses including purchase orders
- Raise monthly sales invoices.
About us
The Coventry
and Rugby GP Alliance is a private company limited by shares, wholly owned by
local Coventry and Rugby GP practices. As a GP led organisation, we represent 94% of Coventry and 47% of Rugby GP practices and cover nearly 420,000 patients.
We describe
our work in terms of Supporting, Innovating, Developing and Educating - we are
on the S.I.D.E. of general practice and we have developed our Operational Plans
to describe what we are going to do over this year to ensure that we continue
to high quality, accessible and responsive services for both practices and
patients.
We have
identified key areas that we will focus on to build upon and improve our
existing services.
These are our
Strategic Priorities:
- Clinical Service Improvement &
Delivery
- Clinical Innovation
- Primary Care Development Practice
and Network Support
- Training and Education
- Integrated Care
- Good Governance
Job description
Job responsibilities
Data Analytics
- Producing daily/weekly service performance reports for Internal Stakeholders, including analysing local trends that impact the organization
- Completing Weekly Minimum Data Set templates for CCG & NHSE Submissions to specification
- Producing Monthly KPI Contract reports for internal/external stakeholders enabling them to take important business decisions based on various facts and trends
- Support business leads with any ad hoc information requests in a timely manner
- Using automated tools to extract data from a range of primary and secondary sources daily (EMIS Search & Report/SAGE/Excel Power Query)
- Developing and maintaining databases, data systems – structuring data into a readable format to enable automated reporting
- Removing erroneous data and fixing coding/data entry errors and related problems (through Excel & EMIS Reporting)
- Performing analysis to assess data quality and understand what information is needed from the systems. Suggesting solutions to aid the business ensure contractual data can be captured.
- Using statistical tools to identify, analyse, and interpret patterns and trends in complex data sets
- Understanding how to layout & structure reports to be meaningful for customers, including working closely to ensure the correct requirements are met
Financial Accounts - Process purchase invoices collect relevant approvals and resolve queries that may arise.
- Processing of expenses including purchase orders
- Raise monthly sales invoices.
- Post and allocate income received against the sales ledger and general ledger ensuring all unknown items are investigated and resolved.
- Assist in production of month end and year end management accounts.
- Reconcile bank accounts on accounting systems.
- Undertaking other tasks and duties associated with general finance.
Job description
Job responsibilities
Data Analytics
- Producing daily/weekly service performance reports for Internal Stakeholders, including analysing local trends that impact the organization
- Completing Weekly Minimum Data Set templates for CCG & NHSE Submissions to specification
- Producing Monthly KPI Contract reports for internal/external stakeholders enabling them to take important business decisions based on various facts and trends
- Support business leads with any ad hoc information requests in a timely manner
- Using automated tools to extract data from a range of primary and secondary sources daily (EMIS Search & Report/SAGE/Excel Power Query)
- Developing and maintaining databases, data systems – structuring data into a readable format to enable automated reporting
- Removing erroneous data and fixing coding/data entry errors and related problems (through Excel & EMIS Reporting)
- Performing analysis to assess data quality and understand what information is needed from the systems. Suggesting solutions to aid the business ensure contractual data can be captured.
- Using statistical tools to identify, analyse, and interpret patterns and trends in complex data sets
- Understanding how to layout & structure reports to be meaningful for customers, including working closely to ensure the correct requirements are met
Financial Accounts - Process purchase invoices collect relevant approvals and resolve queries that may arise.
- Processing of expenses including purchase orders
- Raise monthly sales invoices.
- Post and allocate income received against the sales ledger and general ledger ensuring all unknown items are investigated and resolved.
- Assist in production of month end and year end management accounts.
- Reconcile bank accounts on accounting systems.
- Undertaking other tasks and duties associated with general finance.
Person Specification
Qualifications
Essential
- Advanced working knowledge of Microsoft Excel, Excellent communications skills both written and verbal, Ability to present and tailor complex data to different audiences
Desirable
- Knowledge of EMIS (patient software), Data technician qualification
Person Specification
Qualifications
Essential
- Advanced working knowledge of Microsoft Excel, Excellent communications skills both written and verbal, Ability to present and tailor complex data to different audiences
Desirable
- Knowledge of EMIS (patient software), Data technician qualification
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
