Data Engineer and Service Improvement Analyst

Data Engineer and Service Improvement Analyst

We have an exciting opportunity for a Data Engineer & Service Improvement Analyst to join our team at Lexicon House in Leeds. This key role is part of the Management Information Team.

As a core member of the Management Information Team, you will act as the first point of contact for performance and business reporting needs. Your responsibilities will include designing, developing, and delivering complex regular and ad‑hoc analysis for operational, corporate, internal, and external reporting. You will manage databases, data pipelines, and storage systems to ensure data accuracy, reliability, and accessibility. Your role will also involve presenting complex analysis to senior managers and diverse audiences, resolving data issues, and supporting the development of reporting systems.

Additionally, you will identify and implement AI and automation opportunities to improve processes across services.

Pay rates: £45,000 to £54,000, dependent on skill and experience.

Location:

Local Care Direct, Lexicon House, Wilmington Grove, Leeds, LS7 2BQ
.

Hours & Working Pattern:
Fixed‑term contract for two years, Monday to Friday, 09:00 to 17:00.

• Act as the primary contact for business and reporting requirements.
• Work with operational and corporate directorates to design, develop, and provide regular and ad‑hoc highly complex analysis reports.
• Support operational and resource management, business planning, and external and internal reporting, ensuring the accuracy of outgoing information.
• Create and manage databases, data pipelines, and data storage systems, maintaining high data quality.
• Present highly complex, specialist analysis to senior managers and explain report findings, resolving any data issues.
• Drive the future development of the organisation’s business and performance reporting procedures and systems.
• Identify and implement AI and automation solutions to streamline manual systems and working practices.

• Educated to postgraduate level.
• Demonstrable experience in data engineering and analysis, working independently without day‑to‑day direction.
• Experience in information extraction, transformation, and loading (ETL) and data analysis.
• Experience in NHS environments and with NHS patient systems such as Systm One and Out of Hour data sets.
• Proficiency in data store platforms, data modelling, and schema design.
• Experience with T‑SQL, Azure, and data pipelines.
• Knowledge of pattern recognition, predictive techniques, data‑driven decision making, and artificial intelligence.
• Hands‑on experience designing and developing AI‑powered solutions and automations (e.g., chatbots, analytic systems).
• Advanced skills in MS Office Excel, Power Query, Power BI, SQL, Azure data environment, and Python.
• Strong reporting writing, interpretation, and presentation skills.
• Ability to analyse and interpret complex performance data, present findings, and identify actions for improving service performance.
• Proficiency in using AI to create intelligent data platforms.
• Good organisational skills and the ability to prioritise workloads to meet changing demands.
• Experience in submitting data to ECDS, CSDS, and faster data flows.
• Experience in building and maintaining data warehouses.
• Practical experience with automated schema coding.

• Competitive salary: £45,000 to £48,000 per annum, dependent on experience.
• 25 days’ annual leave, plus bank holidays, increasing with service.
• Employee Assistance Programme for confidential wellbeing support.
• Hybrid and flexible working options, depending on role.
• Access to the Blue Light Card for national discounts.

Local Care Direct is a values‑led social enterprise providing essential health and support services across West Yorkshire. Since 2004, our teams have helped people access the right advice, care, and support in the right place, at the right time, and as close to home as possible. With around 500 colleagues across seventeen sites, we deliver services 24 hours a day, 365 days a year, including GP out‑of‑hours care, urgent treatment centres, walk‑in services, a central contact centre, dental assessment, and tailored support for NHS partners.

We look for people who share our commitment to honesty, integrity, fairness, consistency, kindness, and respect. Join us to be part of a supportive, inclusive organisation where colleagues are valued and encouraged to make a real difference for patients, partners, and local communities.

Ca