Job info |
Job info details |
Job title |
Data Cleanse Officer |
Strategic team/Directorate |
Children's Services |
Service |
Business Intelligence |
Business unit |
Business Intelligence |
Responsible to (day to day issues) |
Business Intelligence Service Manager |
Accountable to (line manager) |
Business Intelligence Service Manager |
Salary grade |
E |
JE ref |
JCT67a |
1. Key purpose of job
- To ensure that all client records within Children’s Services management information systems are complete and accurate.
- Effectively and efficiently source and resolve record anomalies and omissions.
- To identify and propose solutions to data cleansing large volumes of records.
- To accurately and methodically work through potentially long lists of records which require a range of agreed tasks.
- To coordinate and categorise user defined forms by running an application and potentially attaching to children records.
2. Anticipated outcomes of post
- To complete a large volume of data cleansing tasks that improves both the completeness and accuracy of those records during migration.
- To address anomalies and omissions in records that will enable 100% of records needing to be migrated to be migrated.
- To help establish data cleansing rules and seek approval for the application of these rules.
- To ensure data migration timescales are met by the effective and efficient delivery of manual data cleansing.
3. List key duties and accountabilities of the post
- As an Employee of Torbay Council all roles are expected to work in a way that ensures vulnerable children and adults are safeguarded and report any safeguarding concerns in accordance with established policies and procedures. The Designated Senior Lead for Safeguarding is the Chief Executive and Director of Children’s Services.
- Responsible for safeguarding and always promoting the welfare of children.
- To implement agreed manual data cleansing solutions for cleansing children records.
- To identify new solutions and rules for cleansing large volumes of records.
- To ensure cleansing routines are consistently and accurate applied across a number of different areas of a child’s record.
- To update the Business Intelligence Service Manager and Systems Team on a regular basis communicating progress against the agreed timeline.
- Work with the system team and other Business Intelligence colleagues where appropriate to resolve data queries.
- Potentially run a software application to extract elements of child’s record and help oversee the loading of this information on to another system.
4. Budgetary/Financial Responsibilities of the post
5. Supervision/Line Management Responsibilities of the post
6. Working environment and conditions of the post
- Normal office environment.
7. Physical demands of the post
- Display Screen Equipment work.
8. Specific resources used by the post
9. Key contacts and relationships
- External - Software Suppliers.
- Internal - Business Intelligence colleagues.
10. Other duties
- To undertake additional duties as required, commensurate with the level of the job.
Other Information
- All staff must commit to Equal Opportunities and Anti-Discriminatory Practice.
- Torbay Council is committed to safeguarding and promoting the welfare of children and applicants must be willing to undergo the checks appropriate to the post applied for.
- The post holder is expected to work in a way that ensures vulnerable children and adults are safeguarded and report any safeguarding concerns in accordance with established policies and procedures. And are aware that the Chief Executive and the Director for Children's Services are the Safeguarding Leads for the Council
- The post is eligible for both hybrid and permanent home working.
- As this post meets the requirements in respect of exempted questions under the Rehabilitation of Offenders Act 1974, all applicants who are offered employment will be subject to a criminal record check (Disclosure) from the Disclosure & Barring Service before the appointment is confirmed. This will include details of ALL cautions, reprimands or final warnings as well as convictions, whether “spent” or “unspent”. Criminal convictions will only be taken into account when they are relevant to the post.
- The Council operates a Smoke-Free Policy and the post-holder is prohibited from smoking in any of the Council's buildings (including Council owned and Council leased buildings, but excluding designated areas in residential schemes), enclosed spaces within the curtilage of buildings, and Council vehicles. The Council does not permit smoking breaks within work time, however, in services where the flexi-scheme is in operation, employees may take reasonable break times outside of core hours, in accordance with flexi-time arrangements. Employees should follow the flexi-scheme procedure for agreeing time away from their duties in the normal manner with their immediate colleagues and line manager, with break start and finish times being recorded, as with any other break-time arrangement.
- The post-holder is expected to familiarise themselves with and adhere to all relevant Council Policies and Procedures.
- The post-holder must comply with the Council’s Health and Safety requirements as outlined in the H&S policy appropriate to the role.
- The post-holder must be committed to the Council’s Core Values for employees – “Torbay Council employees are committed to being forward thinking, people orientated and adaptable - always with integrity”. Evidence will be sought during the probation and appraisal processes.
- If this post is a customer facing role and meets the requirements of the Immigration Act 2017 (part 7) the ability to converse at ease with members of the public and provide advice in accurate spoken English is essential for the post.
- If you are required to access a government system such as HMRC, DWP or The Public services network (PSN) as part of your role with the Council you will be required to complete a basic disclose with your line manager before you can access these systems. Your manager will be required to complete a verification form that confirms your identity, nationality and immigration status, employment history and unspent convictions (third party).
- If you are required to use your own vehicle on Council business or drive a council vehicle you will be asked to provide information on any driving endorsements by accessing gov.uk/view-driving-licence and providing a code to your Line Manager in order to share your driving licence information with the Council.
Person Specification
Note for Candidate
All Candidates
The supporting statement on your application form will be used to assess ability to meet the essential requirements of the role, so you should explain how you meet each of the numbered essential requirements within your supporting statement.
In a competitive situation, the desirable criteria may be taken into consideration, so you are encouraged to show how you also meet each of the desirable criteria.
Candidates who consider that they have a disability
Reasonable adjustments will be made to the job, job requirements or recruitment process for candidates with a disability.
If you consider yourself to have a disability you should indicate this on your application form, providing any information you would like us to take into account with regard to your disability in order to offer a fair selection interview.
Where ever possible and reasonable we will make adjustments and offer alternatives to help you through the application and selection process.
If you have indicated that you have a disability on your application form you will be guaranteed an interview if you clearly demonstrate in your supporting evidence how you broadly meet the essential requirements of the role.
Job info |
Job info details |
Job Title |
Data Cleanse Officer |
Strategic team/Directorate |
Children's Services |
Service |
Business Intelligence |
Business unit |
Business Intelligence |
Skills and effectiveness
Essential skills and effectiveness
- Proficient in the use of desktop applications (Microsoft Office) MS Word and Excel.
- An understanding of data security and confidentiality issues.
- Conscientious and proven team worker with the ability to engage with people at all levels.
- Attention to detail and assurance of own work.
- Methodical and diligent approach to completing repetitive tasks.
- Organisational Skills, ability to prioritise work within timescales and meet deadlines.
Desirable skills and effectiveness
- Experience of data cleansing.
- Problem solving.
Knowledge
Essential knowledge
- Awareness of the importance of data quality and the potential impact this has on effective delivery of service.
- Awareness of data protection and the handling of highly sensitive information.
Desirable knowledge
- Experience of using client record software applications.
Experience and achievements
Essential experience and achievements
- Working with computer databases and spreadsheets to help record work and report on progress.
- Working accurately with electronic data.
Desirable experience and achievements
- Knowledge of Children’s Social Care.
- Experience of working with sensitive information and working to General Data Protection Requirements.
Qualifications/professional memberships
Essential qualifications/professional memberships
- Educated to GCSE level standard (or equivalent).
Desirable qualifications/professional memberships
- ECDL qualification or equivalent experience.
Other requirements
Other requirements of the job role
- Demonstrates a commitment to safeguard and promote the welfare of children and young people.
- Ability to travel efficiently around the Bay/Southwest/UK in order to carry out duties.
- Ability to accommodate unsociable hours.
- Ability to accommodate shift patterns.
- Ability to accommodate on-call working.
- Ability to accommodate occasional/permanent home working.