Data Engineer - Business Intelligence
Job summary
Are you a Data Engineer looking to build and shape a modern Business Intelligence function? Do you enjoy creating scalable data solutions that drive real insight and improve services?
BPAS has an exciting opportunity for a Data Engineer to join our growing Business Intelligence team.
Reporting to the BI Lead, you will play a central role in developing our centralised BI function, designing & delivering robust, scalable data solutions that support operational reporting, strategic decision-making, &future analytics capability.
This is a hybrid permanent role, working for 36 hours per week over Monday to Friday. Travel to Head Office is typically 1/2 times a month.
This is an opportunity to work in a purpose-driven organisation where your work will directly support the delivery of high-quality healthcare services.
About the role
As a Data Engineer, you will be responsible for designing, building, and maintaining reliable data pipelines and integrations across a range of systems. You will help reduce manual processes, improve data quality, and ensure consistent, accessible data is available across the organisation.
Working closely with BI Analysts and stakeholders across clinical, operational, and corporate teams, you will play a key role in shaping how data is structured, governed, and used within BPAS.
You will also contribute to establishing best practice in data engineering, supporting documentation, knowledge sharing, and the long-term development of our analytics platform.
Main duties of the job
About You
You will be an experienced Data Engineer, with a passion for building reliable and scalable data solutions.
You will bring:
- 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
About us
The British Pregnancy Advisory Service (BPAS) is the UK's largest independent reproductive healthcare charity, providing evidence-based, not-for-profit reproductive healthcare. We work mainly on behalf of the NHS, offering abortion care, contraception, and STI testing and treatment across the country.
When you join BPAS, you become part of a values-driven organisation where compassion, professionalism, and choice guide everything we do. You will help remove barriers to safe reproductive care while supporting people to make informed choices about their health and futures.
Working with us benefits include:
- 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
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.
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.
Job description
Job responsibilities
A full job description and terms and conditions can be found on the right hand side of the page and is available for you to download and review.
Further Information
We may close this advert early if we receive a high number of suitable applications, although we aim to keep it open long enough to ensure a diverse and representative applicant pool.
If you have any questions about the role or require adjustments to support your application, please get in touch, we are happy to help.
Location Hybrid working from home with days in Head Office Leamington Spa typically 1/2 times a month.
Head Office Orion House, 2 Athena Dr, Tachbrook Park Dr, Royal Leamington Spa, Warwick CV34 6RQ
Salary £55,000 - £62,000 per annum - depending on skills and experience.
Hours Per Week 36 hours
Working Pattern Monday to Thursday 09:00 to 17:00 | Friday 09:00 to 15:30
Apply now Interested in making a difference? Apply today to join our team.
Values & eligibility All applicants must be pro choice and support a woman's right to choose, in line with BPAS values and mission.
Application outcome If you do not hear from us within two weeks of the closing date, unfortunately you have not been shortlisted on this occasion.
References & pre-employment checks All offers of employment are conditional on satisfactory pre-employment checks. Applicants must provide three years of employment references, including reasons for leaving and details of any gaps in employment.
Person Specification
Qualifications
- Degree in a relevant field (e.g. Data Engineering, Computer Science, Mathematics, Information Systens) 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
- 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
- Please describe your experience developing automated data pipelines using modern cloud data platforms (e.g. Microsoft Fabric, Azure Data Factory, Synapse or similar). What did you build and what was the purpose of the pipeline?
- Please provide an example of how you have transformed and modelled datasets for reporting or analytical use. What approach or tools did you use?
- Experience integrating data from multiple systems (SQL, APIs, business platforms)
- 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
General
- Do you support a woman's right to choose abortion?
- Are you the family or friend of a current BPAS employee? If yes, please state the name and nature of the relationship
- This role is working 36 hours per week over Monday to Friday. Can you commit to this?
- This is a hybrid role with travel to our Head Office in Leamington Spa typically once or twice a month (travel is not reimbursed) - can you travel to Leamington spa?
Knowledge and Skills
- Please describe your experience using Python or PySpark within data pipelines or notebooks. What types of data processing or transformations have you implemented?
- Please describe your experience working with modern data platforms (e.g. Microsoft Fabric, Lakehouse, OneLake or similar). How have these platforms been used in your data solutions or pipelines?
- 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
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Employer details
Employer name
British Pregnancy Advisory Service (BPAS)
Address
Orion House
Athena Drive
Warwick
CV34 6RQ
Employer's website
https://www.bpas.org