Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Cleanse and standardise financial data for a major system upgrade.
- Company: Join Bath & North East Somerset Council, dedicated to improving lives.
- Benefits: Flexible working, competitive pay, and a chance to make a real impact.
- Why this job: Be part of a high-profile project modernising financial systems and enhancing data quality.
- Qualifications: A-levels or equivalent with strong IT skills, especially in Excel.
- Other info: Great opportunity for career growth and community contribution.
The predicted salary is between 30000 - 42000 £ per year.
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 load-ready datasets and mapping tables for migration cycles.
- Support mock loads/dress rehearsals and reconcile pre/post-load results; capture defects and drive remediation.
- Produce clear progress reporting, data quality metrics, and insights to inform stakeholders.
- Provide guidance and training to colleagues on data capture, validation, and good governance so improvements are sustained after go-live.
- Contribute to wider process improvements that enhance data quality at source.
About you (Essential)
- Educated to A-level (or equivalent) with an IT-related 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).
- Hands-on 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 high-profile 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.
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.
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. We are a Disability Confident Employer.
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.
Data Cleansing Officer in Bristol employer: Bath and North East Somerset Council
Contact Detail:
Bath and North East Somerset Council Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Cleansing Officer in Bristol
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or even in person. Let them know you're on the hunt for a Data Cleansing Officer role. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common questions related to data cleansing and financial systems. We recommend doing mock interviews with friends or using online resources to get comfortable talking about your skills and experiences.
✨Tip Number 3
Showcase your skills! Create a portfolio that highlights your experience with data cleansing, especially using tools like Excel and Power Query. This will give potential employers a clear view of what you can bring to the table.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you're genuinely interested in joining Bath & North East Somerset Council and making a difference in people's lives.
We think you need these skills to ace Data Cleansing Officer in Bristol
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your application to highlight how your skills and experiences align with the role of Data Cleansing Officer. Use keywords from the job description to show that you understand what they’re looking for.
Showcase Your Data Skills: Since this role is all about data, don’t hold back on showcasing your experience with data cleansing and analysis. Mention specific tools like Excel or Power Query that you’ve used, and provide examples of how you’ve improved data quality in past roles.
Demonstrate Your Values: The council values being Bold, Empowered, Supportive, and Transparent. In your application, give examples of how you embody these values in your work. This will help us see how you fit into the team culture.
Apply Early!: Don’t wait until the last minute to submit your application. The advert may close early due to high demand, so get your application in as soon as possible through our website to ensure you don’t miss out!
How to prepare for a job interview at Bath and North East Somerset Council
✨Know Your Data
Before the interview, brush up on your knowledge of data cleansing and financial management systems. Familiarise yourself with Unit4 ERP7 and ERPx, as well as common data issues like duplicates and anomalies. This will show that you’re not just interested in the role but also understand the technical aspects involved.
✨Showcase Your Excel Skills
Since advanced Excel skills are crucial for this position, be prepared to discuss specific functions or tools you’ve used, like Power Query. You might even want to bring examples of reports or analyses you've created to demonstrate your proficiency.
✨Prepare for Scenario Questions
Expect questions about how you would handle specific data cleansing scenarios. Think about past experiences where you identified and resolved data quality issues. Use the STAR method (Situation, Task, Action, Result) to structure your answers clearly.
✨Emphasise Your Teamwork Skills
This role involves working closely with various teams, so be ready to discuss how you’ve collaborated with others in previous roles. Highlight any experience you have in training colleagues on data governance or best practices, as this aligns with the council's values of being supportive and empowering.
