Closing date: 06 May 2026
We are looking for a Data Engineer to build and shape a modern Business Intelligence function at the British Pregnancy Advisory Service (BPAS). This hybrid permanent role will support operational reporting, strategic decision‑making, and future analytics capability.
Main duties of the job
* Design and maintain scalable, automated data pipelines across SQL databases, APIs, cloud platforms and business systems (including Dynamics 365)
* Develop data transformation processes using SQL, Python/PySpark and modern data tools
* Implement data quality checks, validation and monitoring to ensure accuracy and reliability
* Structure and model data to support BI reporting and analytics
* Build and maintain secure data integration solutions, including APIs and data gateways
* Work with BI analysts, BI lead and stakeholders to translate requirements into effective data solutions and support reporting needs
* Produce and maintain technical documentation, including data mappings and data dictionaries
* Support data governance, security and compliance standards
* Improve automation, performance, scalability and reduce manual processes
* Contribute to knowledge sharing, peer review and continuous improvement
About you
You will be an experienced Data Engineer with a passion for building reliable and scalable data solutions.
* Experience building automated data pipelines using cloud platforms (e.g. Microsoft Fabric, Azure Data Factory, Synapse or similar)
* Strong SQL skills and experience with Python or PySpark
* Experience integrating data from multiple systems, including APIs and business platforms
* Understanding of data quality, validation and governance principles
* Ability to deliver well‑structured, documented data solutions
Qualifications
Essential
* Degree in a relevant field (e.g. Data Engineering, Computer Science, Mathematics, Information Systems) or equivalent experience.
* Professional certification in Azure Data Engineering, Microsoft Fabric or Microsoft Certified: Data Engineer Associate.
* Demonstrable commitment to continuous professional development in data engineering or analytics.
Desirable
* Training in data governance, NHS data standards or secure data management (e.g. GDPR, IG Toolkit).
* Familiarity with Agile or DevOps delivery approaches.
* Relevant qualification in project management or agile delivery (e.g. PRINCE2 Agile, Scrum).
Experience
Essential
* Developing automated data pipelines using modern cloud data platforms (e.g. Microsoft Fabric, Azure Data Factory, Synapse or similar) – describe what you built and the purpose.
* Transforming and modelling datasets for reporting or analytical use – describe the approach or tools used.
* Experience integrating data from multiple systems (SQL, APIs, business platforms).
Desirable
* Exposure to healthcare (e.g. NHS / clinical datasets) or regulated data environments.
* Experience integrating Dynamics 365 or similar systems.
* Experience working in Agile delivery environments.
* Exposure to advanced analytics and modern forecasting techniques.
Knowledge and Skills
Essential
* Experience using Python or PySpark within data pipelines or notebooks – describe the types of data processing or transformations implemented.
* Experience working with modern data platforms (e.g. Microsoft Fabric, Lakehouse, OneLake or similar) – how they have been used in your data solutions or pipelines.
Desirable
* Knowledge of star/snowflake schema design and data warehousing best practices.
* Familiarity with performance tuning and cost optimisation in Fabric or Azure.
* Experience with Microsoft Purview or similar tools for metadata and governance.
* Awareness of NHS data reporting practices and privacy considerations (e.g. pseudonymisation).
* Use of infrastructure‑as‑code or deployment scripting tools in data projects.
Benefits
* 34 days annual leave (including bank holidays)
* Life assurance at 3 salary
* Defined contribution pension scheme
* Access to GP 24/7, 365 days a year
* MyMindPal mental fitness app and 24/7 counselling support
* Online discounts, discounted gym membership, and other lifestyle benefits
* Family‑friendly policies to support work‑life balance
Other information
Salary: £55,000 – £62,000 per annum
Location: Hybrid working from home, with occasional days at Head Office Leamington Spa
Hours per week: 36
Head Office address: Orion House, 2 Athena Dr, Leamington Spa, Warwick, CV34 6RQ
Inclusive employment
We actively welcome applications from people of all backgrounds, identities, and experiences. We are proud to be an inclusive employer and will make reasonable adjustments to ensure a fair and accessible recruitment process for all candidates.
Safeguarding, Equality & Diversity
BPAS is committed to safeguarding and promoting the welfare of everyone who uses our services, and all staff share this responsibility. Recruitment follows safer‑recruitment principles and includes appropriate pre‑employment checks.
#J-18808-Ljbffr