At Bath & North East Somerset Council we have one overriding purpose to improve people s lives. FIXED TERM CONTRACT / SECONDMENT TO 30/09/2026 Bath & North East Somerset Council is seeking a Data Cleansing Officer to help prepare high quality financial data for our transition from Unit4 ERP7 (Agresso) to Unit4 ERPx. You ll work with colleagues across Finance, Procurement, and our Accounts Payable/Receivable Teams to cleanse and standardise master and transactional data so that our new system goes live with accurate, trusted information. About the Role Working with the Technical Lead and the ERPx project team, you will deliver robust data quality improvements and cleansing activities to ensure reliable management information that supports decision making, business planning, and statutory reporting. You ll also promote good data governance and help embed sustainable processes for ongoing data quality. Key responsibilities Execute data cleansing workstreams for Supplier, Customer, and Contract data in the council s financial management system Unit4 ERP7 (Agresso) in readiness for migration to Unit4 ERPx. Profile data to identify duplicates, gaps, and anomalies; define and apply business rules to standardise formats (naming, addresses, VAT numbers, payment terms, bank details). Work with relevant stakeholders to confirm data cleansing activities, such as duplicate removal, record consolidation, status verification, and validation of key data fields. Establish and document data standards, quality checks, and signoff criteria; maintain an auditable trail of changes. Build repeatable cleanses using tools such as Excel/Power Query, lookups and matching logic; where appropriate, prepare loadready datasets and mapping tables for migration cycles. Support mock loads/dress rehearsals and reconcile pre/postload results; capture defects and drive remediation. Produce clear progress reporting, dataquality metrics, and insights to inform stakeholders. Provide guidance and training to colleagues on data capture, validation, and good governance so improvements are sustained after golive. Contribute to wider process improvements that enhance data quality at source. About you (Essential) Educated to Alevel (or equivalent) with an ITrelated qualification. Excellent Microsoft Office skills (advanced Excel in particular) and experience turning data into clear analysis/reports. Proven experience cleansing and interpreting operational/financial datasets and producing concise, actionable summaries for stakeholders. Able to work independently, plan activity over days/weeks, and present findings to senior staff. Desirable Experience with Unit4 ERP / ERPx or other Financial Management Systems; familiarity with finance master data (suppliers, customers, contracts). Handson involvement in data migration projects, including mock loads and reconciliations. Skills with Power Query, or basic SQL for profiling and reconciliation. Why join us? Be part of a highprofile programme modernising our core financial systems. Make a tangible impact on data quality, controls, and service efficiency. Our values B&NES has one overriding purpose to improve people s lives. Our values are to be Bold, Empowered, Supportive and Transparent. Please explain in your application how you would demonstrate these in this role. If you are interested in this post and require more details or just to chat through the role and what s involved, please contact Lee Archer, Financial Systems & Development Manager at lee_archer@bathnes.gov.uk or by telephone on 01225 5394267 Please note that this advert may close earlier than the stated closing date due to high demand. We advise all interested candidates to apply as soon as possible Interview date: 04/02/2026 *Please note, BANES Council operates a policy of prior consideration for roles for any individual on the Council s at-risk register (redeployee). This means should a redeployee express an interest in this role, providing they meet the essential criteria for the role they will be considered ahead of external applicants. About Bath and North East Somerset Council. Working at Bath and North East Somerset provides an opportunity to contribute to your community and make a positive impact on the lives of residents. Our values shape how we work to deliver public services, and how we communicate with the residents we serve. We care about the best outcomes for local people, through our public services. Why Bath and North East Somerset Council? We offer a wide range of benefits, to ensure that you are paid fairly for your work, have the flexibility to enjoy a great work/life balance, and have the support you need. Go to https://jobsandcareers.bathnes.gov.uk/why-work-us/our-benefits At Bath and North East Somerset Council we have one overriding purpose to improve peoples lives. Find out more about our values at https://jobsandcareers.bathnes.gov.uk/why-work-us/our-values We aspire to have a diverse and inclusive workplace and strongly encourage suitably qualified applicants from a wide range of backgrounds to apply and join us. Find out more on our commitment to Equality, Diversity and Inclusion at https://beta.bathnes.gov.uk/equality-and-diversity We are a Disability Confident Employer find out more at https://shorturl.at/ajrsW The Council is committed to having a diverse and inclusive workforce. Applications for job-share, part-time and flexible working arrangements are welcomed and will be considered in line with business needs. Safeguarding Statement: The Council is committed to safeguarding and promoting the welfare of children, young people and vulnerable groups and expects all employees and volunteers to share this commitment. As part of this commitment anyone working in a post with children or vulnerable groups will be expected to undertake an Enhanced DBS check with/without barred list checks.