The Programme Group Limited
DATA QUALITY & OPERATIONS ANALYST
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Salary £35,000 to £40,000 per annum DOE
20 days' holiday, excluding bank holidays
3 Month Initial Full-Time fixed-term contract, with the possibility of becoming permanent.
NO AGENCIES
Role Overview
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.
Key Responsibilities
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Skills & Experience
Essential
- 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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location