> Markdown version of [/jobs/ext/2450166-optimise-data-quality-operations-analyst](https://www.wearedevelopers.com/jobs/ext/2450166-optimise-data-quality-operations-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # OPTIMISE DATA QUALITY & OPERATIONS ANALYST - **Company:** The Programme Group Limited - **Location:** UK - **Salary:** £35,000.0 - £40,000.0 - **Contract:** Temporary contract - **Skills:** Microsoft Excel, Audit Trail, Databases, Relational Databases, MariaDB, MySQL, Regression Testing, Release Management, Power BI, Standard Sql, SQL Databases, Data Management, Tools for Reporting - **Published:** August 26, 2026 - **Apply:** https://uk.indeed.com/viewjob?jk=bca444d4c2882707 ## About the Role * Good working knowledge of SQL, relational databases and established SQL scripts, with confidence querying data and investigating issues. * Working knowledge of Power BI, including refreshing, checking and publishing existing reports and datasets. * Strong Excel and general data-handling skills, with good understanding of data quality, reconciliation, source provenance, lineage and audit trails. * Experience working within controlled data-processing procedures, with an understanding of change or release management. Ability to maintain issue, exception, change and evidence records, and to distinguish routine processing corrections from matters requiring accountable approval. * Experience supporting projects, programmes or structured delivery activities, including actions, risks, issues, decisions, deliverables and supporting evidence. * Highly organised, methodical and detail-focused, with the ability to take ownership of repeatable processes and work independently. * Able to investigate problems logically, recognise escalation triggers and communicate data limitations clearly where outputs may not be suitable for their intended use. * Understanding role-based access, secure credential handling and appropriate separation between development, testing and production environments. Desirable * Experience working with NHS, healthcare, public-sector or similarly regulated data. * Experience with MariaDB, MySQL or similar database technologies. * Wider experience of Power BI, Microsoft Power Platform or reporting automation. * Understanding of project, programme, data-governance or assurance frameworks. * Experience working in a regulated, data-intensive or operational reporting environment. The Person We are looking for someone methodical, dependable and curious, with the confidence to work with data, reporting tools and controlled processes. They do not need to be a senior technical specialist, but they should be comfortable investigating issues, checking whether outputs reconcile and recognising when a query, exception or decision needs to be escalated. The successful candidate will be disciplined about evidence, documentation and follow-through, and able to build trust by running repeatable processes reliably, communicating data limitations clearly and supporting continuous improvement of the Optimise data and reporting cycle. ## Description We are looking for a capable, highly organised Optimise Data Quality & Operations Analyst to support the ongoing operation and assurance of the Optimise platform. This varied role combines SQL and data support, Power BI reporting, data quality, controlled processing, project assurance and administration. Reporting to the Optimise Lead, the postholder will be the operational process owner for the routine Optimise data and reporting cycle, including source receipt, processing, checking, issue administration, report refresh, publication and evidence capture. The postholder will work within the approved Deliverable and Data Quality Plan, escalating material data, technical, governance and decision-use issues through the Optimise Lead to the appropriate accountable owner. The role does not require an expert SQL or Power BI developer. However, the successful candidate must be comfortable working with databases and existing reports, running established processes, investigating data, identifying when something does not look right and recognising when a matter requires escalation., Optimise Data and Reporting Operations * Run established SQL scripts, import routines and monthly data-processing activities for the Optimise platform. * Take operational ownership of the month-end data and reporting cycle, including source receipt, processing, reconciliation, refresh and publication steps. * Refresh, check and publish existing Power BI reports and datasets to approved workspaces once validation, review and release checks are complete. * Confirm that the reporting period, refresh date, coverage and material caveats are visible in published outputs, and that the workspace, audience and access arrangements are approved and recorded. * Maintain a clear audit trail and monthly assurance summary covering processing status, reconciliations, material exceptions, unresolved issues, publication status, changes and required decisions or escalations. Data Quality and Exception Management * Complete schema, file-integrity, volume, prior-period, validation and reconciliation checks before and after processing. * Apply approved data ownership and treatment rules, distinguishing between source-owned, lookup-owned, calculated and locally managed information, and do not overwrite controlled source records. * Profile and monitor completeness, accuracy, validity, consistency, uniqueness, currency, coverage, traceability and suitability for use. * Identify, investigate and document missing, inconsistent, unexpected or unreconciled data, distinguishing blanks from zero, not applicable, not collected, unknown and awaiting confirmation. * Apply the agreed stakeholder non-response protocol, ensuring that non-response is not treated as confirmation of material or irreversible matters. * Maintain data-difference, exclusion, issue and exception records, including severity, decision impact, treatment, evidence, owner, validator, approver, due date, verification and closure evidence. * Ensure issues are only closed once corrections have been verified, downstream outputs reconciled and any provisional or time-limited determinations scheduled for revalidation. * Monitor recurring issues and propose improvements to controls, guidance or processing routines, escalating complex or high-impact issues in line with agreed triggers. Change, Release and Technical Control * Maintain the controlled inventory of operational SQL scripts, reports, datasets, calculations, rules, mappings, configurations and processing dependencies. * Use only approved versions of scripts, rules, mappings and report configurations, preserving controlled source extracts and maintaining provenance from source through staging, transformation, operational model and published output. * Record and manage changes to data rules, calculations, reports, configuration, access and processing routines in line with change control procedures. * Complete documented pre-release and post-release reconciliation checks, including regression testing where source structures, transformations, calculations or Power BI outputs change. * Confirm that required release notes, approvals, access arrangements, support information, defect records and rollback provisions are complete and recorded before publication. Escalate matters requiring changes to code, database architecture, transformation or calculation logic, report development or production configuration to the Technical Lead/developer through the agreed change-control process. Governance, Stakeholder and Project Support * Support project and programme assurance activities, including actions, risks, issues, decisions, deliverables and supporting evidence. * Help ensure project deliverables and data outputs are complete, traceable, fit for the stated use and appropriately qualified in line with agreed protocols. * Route validation requests to named data owners, validators, deputies and escalation contacts, recording evidence required, priority, due date, reminders, responses and decisions. * Link stakeholder decisions back to the relevant data-quality issue, affected asset or output, and track acknowledgement, decision and verified-closure times against agreed service targets. * Coordinate meetings, actions, follow-ups, project updates, governance information and organised project records where required. Security, Continuity and Documentation * Operate within approved access controls, credential-handling procedures and development, test and production boundaries. * Confirm published outputs, access arrangements and stakeholder contact records are managed in accordance with access, retention and information-governance requirements. * Escalate suspected access, security, privacy or information-governance issues immediately. * Support backup, recovery and documented manual fallback arrangements for critical reporting cycles. * Maintain clear operating procedures, handover records, project files and documentation so that another authorised team member can run the cycle if required. ## Related Videos - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Beyond Gut Feelings: The Rise of Data-Driven HR](https://www.wearedevelopers.com/videos/1326-beyond-gut-feelings-the-rise-of-data-driven-hr) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers)