Public Services Ombudsman for Wales

We are looking to recruit a Data Officer to join a busy operational team supporting 80 staff, the majority of whom are caseworkers. This is a role with genuine progression, starting in a hands on reporting and data quality capacity today, with a clear roadmap toward a modern data stack (SQL, Power BI, Azure Data Lake, Power Automate and Copilot). The role You'll be the go to person for reporting and data integrity across a large and complex case management system (100+ tables, 7GB of data) Building, maintaining and improving reports - moving the team away from Excel generated outputs toward more flexible, insight-driven reporting Working extensively in Excel (VLOOKUPs, IF statements, reconciliation, QA) Testing how data flows through the system, tracing cause and effect, identifying where data breaks down and documenting findings Supporting communications teams with open-source information outputs Producing clear documentation to support governance and continuity The potential future of this role The organisation is investing in its data capability, and this role will grow with it Power BI dashboard development and trend analysis SQL, raw CSV and Azure Data Lake work Automation through Power Automate, low-code tools and Copilot Strong Analytical skills: a strong ability to interpret complex datasets and turn them into actional insights Strong MS Office skills, specifically Excel Strong knowledge of SQL query language and SQL data structures Confident with BI tools such as PowerBI, SSRS or similar tools An ability to think logically and to demonstrate good problem solving skills. A good understanding of information security and Cyber awareness Experience using Power Automate or other low-code tools Familiarity with Automation and AI principles Experience using Microsoft CoPilot Experience working with case management systems Renumeration Holiday: 32 days + bank holidays Location: Bridgend - 1-2 days in office, otherwise fully flexible Health cash plan This will suit someone who values stability, balance and meaningful work, perhaps stepping out of a fast paced private sector role, or an analyst ready to take on more ownership in a supportive environment. The total package (pension, leave, flex) is genuinely strong, and you'll have a clear runway to develop modern data skills on the job.