data cleansing jobs

We’re looking for a driven and skilled Workforce Information Manager to lead the Trust’s workforce reporting and data quality agenda at a really exciting time of change. This role sits at the heart of our newly integrated Workforce Information, Payroll Control and HR Transactions function, giving you the chance to shape how we deliver high-quality, modern workforce intelligence across the organisation.

You’ll lead on statutory reporting, build automated and visual dashboards, improve data quality across ESR, and help develop better digital tools and processes. If you enjoy turning complex data into meaningful insight, improving systems, and influencing colleagues across HR, Finance, Operations and Digital, you’ll thrive here.

This is a fantastic opportunity for someone ready to step up, make their mark, and help us build a more consistent, accurate and forward-looking workforce information service.

The Workforce Information Manager will lead the delivery of accurate and timely workforce reporting for the Trust. This includes producing dashboards, statutory submissions such as WRES, WDES and Gender Pay Gap, and providing high-quality analysis to support planning, assurance and operational decision-making.

You will be responsible for monitoring and improving data quality within ESR, carrying out audits, data cleansing and reconciliation work, and maintaining the accuracy of organisational hierarchies and workforce structures. The role involves close collaboration with HR, Recruitment, Payroll, Finance and Digital teams to resolve data issues and strengthen processes.

The postholder will provide day-to-day supervision and support to junior colleagues within the Workforce Information & Systems team, ensuring work is well coordinated and delivered to a high standard. You will also contribute to improvements in reporting tools and the development of digital solutions that enhance the accessibility and reliability of workforce data.

To be successful, you will need strong analytical and data visualisation skills, experience working with ESR and workforce datasets, excellent attention to detail, and the ability to communicate clearly with a range of stakeholders. The role requires someone organised, proactive and confident in managing varying priorities in a busy and data-driven environment.

You’ll be joining a growing Workforce Information & Systems team that is focused on improving how the Trust understands and manages its workforce. The team works closely with HR, Recruitment, Payroll, Finance and Digital teams, creating a collaborative environment where people are encouraged to share ideas, solve problems together and improve the way we work.

We are in the process of bringing several workforce-related functions into a more integrated service, which creates opportunities to influence how reporting, data quality and systems support develop over time. Colleagues are supportive, open to change and committed to building a reliable, modern workforce information service for the organisation.

As part of South London and Maudsley, you will have access to flexible working arrangements, development opportunities and a range of staff benefits, alongside the chance to contribute directly to work that helps improve services for patients, staff and local communities. This is a team where your expertise is valued, and where good ideas are actively encouraged.

1. Workforce Data and Reporting

• Develop and deliver high-quality workforce reports and dashboards that support assurance, performance monitoring, and workforce planning.
• Lead the production of regular returns such as WRES, WDES, Gender Pay Gap, Annual Reports and Model Hospital, ensuring timeliness and data integrity.
• Use business intelligence tools (e.g. Power BI, Excel, ESR BI) to create automated and visual reporting solutions.
• Respond to complex ad hoc data requests, ensuring outputs are accurate, clear and appropriately interpreted for their intended audience.

2. Data Quality and Systems Oversight

• Monitor and manage data quality across ESR and associated systems, undertaking regular audits, spot checks and reconciliations.
• Lead a structured programme of work to identify, prioritise and address systemic data quality issues, including targeted data cleansing and collaboration with upstream data entry teams.
• Maintain and validate ESR hierarchy (including positions, job roles and organisational structure), ensuring alignment with national coding standards and internal establishment control processes.
• Liaise with colleagues across HR, payroll, recruitment and rostering to ensure accurate data flow and early resolution of data anomalies.
• Contribute to the development and implementation of system improvements, new digital forms, or automation tools that support workforce data accuracy.

3. Service Improvement and Innovation

• Identify and deliver improvements to the accessibility, consistency and usefulness of workforce reporting.
• Promote self-service and digital reporting through standardised dashboards and tools that reduce manual effort and duplication.
• Support pilots, prototypes and proof-of-concept reporting solutions in response to operational and planning needs.
• Collaborate with IT, Digital, and other corporate teams to improve system integration and modernise reporting workflow

4. Line Management and Team Support

• Provide effective line management and supervision to junior colleagues with the team, including work allocation, performance management and professional development.
• Support recruitment, onboarding and team development activity.
• Provide cross-cover and team support within the wider integrated function (including HR Transactions and Payroll Control) where appropriate.
• Promote a team culture based on Trust values, quality and continuous improvement.

5. Stakeholder Engagement

• Act as a key contact for workforce data queries and service requests across the organisation.
• Build strong working relationships with HR, Finance, operational managers and IT to ensure shared understanding of workforce data requirements.
• Support training and troubleshooting for local teams using ESR, BI tools or data templates.

6. Governance and Compliance

• Ensure reporting and data management activities comply with Trust data protection, information governance and audit requirements.
• Maintain clear documentation of data definitions, calculations, templates and reporting logic.
• Contribute to internal and external audits by supplying data, narrative and technical explanation as required.
• Maintain and regularly review local SOPs and process documentation.

7. Other

• Take part in wider team meetings, Trust planning cycles and people reporting development groups.
• Maintain personal development and professional knowledge in line with emerging tools and reporting requirements.