Excel Data Analyst

Data LeadReporting to: City ManagerRole PurposeThe Data Lead is responsible for ensuring the effective management, quality, analysis, and reporting of data across a national charity’s service. The role supports operational delivery, contractual performance, continuous improvement, and strategic decision-making through the use of high-quality data.Working closely with service managers, frontline teams, and central performance functions, the postholder will ensure alignment with the charity’s Data Governance Framework, Delivery Framework, and One Data Platform.Key ResponsibilitiesData LeadershipAct as the local lead for data management and reporting within the Derby service.Support implementation of the One Data Platform and ensure high-quality source data.Embed common data standards and ensure consistent recording of interventions, outcomes, and service user journeys.Liaise between operational teams and central data functions to support organisation-wide data development.Performance & InsightProduce, validate, and interpret performance reports for commissioners, operational management, internal governance, and national datasets such as NDTMS.Support managers in using data to improve performance and achieve KPIs.Ensure timely and accurate contractual and statutory reporting.Respond to ad hoc reporting requests and support the transition to Power BI-based reporting.Data Quality & GovernanceEnsure compliance with data governance, GDPR, ISO9001, and organisational policies.Monitor and improve data quality across systems and processes.Support audits, Subject Access Requests (SARs), Freedom of Information (FOI) requests, and data compliance activities.Escalate data risks and breaches appropriately.Systems & OperationsLead day-to-day data operations within case management systems.Ensure consistent use of systems, data standards, permissions, and data completeness.Coordinate resolution of system issues and support service continuity during downtime.Contribute to system

enhancements and data model improvements.Training & ChangeDeliver training and guidance on data recording, reporting requirements, and governance standards.Improve data literacy across teams and support adoption of new systems and reporting approaches.Enable confident use of dashboards and performance information.Stakeholder ManagementBuild effective relationships with commissioners, partners, regulatory bodies, and internal stakeholders.Represent the service in meetings relating to data, performance, and quality.Ensure local priorities align with organisational data objectives.Person SpecificationExperience & QualificationsDegree-level qualification in data, analytics, information management, or a related field, or equivalent experience.Proven experience in a Data Lead, Performance Analyst, Data Analyst, or similar role.Experience managing, analysing, and reporting operational or service-level data in a complex environment.Experience improving data quality, supporting audits, and managing performance reporting.Experience delivering training and supporting change initiatives.Experience within health, social care, substance use, or commissioned services is desirable.Knowledge & SkillsStrong knowledge of data governance, data quality principles, GDPR, and information management.Experience with case management systems and performance reporting tools.Knowledge of modern data platforms and business intelligence tools, including:Power BIData warehouses and data lakesCommon data modelsAbility to translate complex data into meaningful insights for non-technical audiences.Strong analytical, organisational, and problem-solving skills.Personal AttributesDetail-oriented with a strong focus on data accuracy and quality.Proactive, organised, and improvement-focused.Able to manage multiple priorities and deadlines.Collaborative approach with the ability to work independently.Professional, discreet, and trustworthy when handling sensitive information.BenefitsCompetitive salaryPension contributionsFlexible working arrangementsLearning and development opportunitiesSupportive and collaborative working environmentWhy This Role?This national charity is committed to helping people make positive changes in their lives. As Data Lead, you will play a key role in developing data capability, improving decision-making, and supporting service excellence through high-quality data and insight. This is an opportunity to make a meaningful impact while developing your career within a values-driven organisation. #J-18808-Ljbffr