Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and build scalable data pipelines to drive insights and improve services.
- Company: Join BPAS, the UK's largest independent reproductive healthcare charity.
- Benefits: Enjoy 34 days annual leave, life assurance, and a supportive work-life balance.
- Other info: Hybrid role with great career growth opportunities in a values-driven organisation.
- Why this job: Make a real impact in healthcare by shaping data solutions for better decision-making.
- Qualifications: Experience with SQL, Python, and cloud platforms like Azure is essential.
The predicted salary is between 55000 - 62000 £ per year.
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 and delivering robust, scalable data solutions that support operational reporting, strategic decision-making, and 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
- 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. 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.
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.
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
Values & eligibility
All applicants must be pro-choice and support a woman's right to choose, in line with BPAS values and mission.
Person Specification
Qualifications
- 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
- Training in data governance, NHS data standards, or secure data management (e.g. GDPR, IG Toolkit)
- Familiarity with Agile or DevOps delivery approaches
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
Data Engineer in Royal Leamington Spa employer: British Pregnancy Advisory Service (BPAS)
Contact Detail:
British Pregnancy Advisory Service (BPAS) Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer in Royal Leamington Spa
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even just grab a coffee with someone who works in data engineering. Building relationships can lead to job opportunities that aren’t even advertised.
✨Show Off Your Skills
Create a portfolio showcasing your projects and skills. Whether it’s GitHub repos or a personal website, let your work speak for itself. This is your chance to demonstrate your expertise in building scalable data solutions!
✨Ace the Interview
Prepare for technical interviews by brushing up on SQL, Python, and data pipeline concepts. Practice common interview questions and be ready to discuss your past projects in detail. Confidence is key, so show them what you’ve got!
✨Apply Through Our Website
Don’t forget to apply directly through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are genuinely interested in joining our mission at BPAS.
We think you need these skills to ace Data Engineer in Royal Leamington Spa
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Engineer role. Highlight your experience with automated data pipelines, SQL, and Python/PySpark. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Share your passion for data engineering and how you can contribute to our Business Intelligence team. Let us know why you're excited about working with BPAS.
Showcase Relevant Experience: When filling out your application, be specific about your past projects. Describe how you've built scalable data solutions and improved data quality. We love seeing real examples of your work!
Apply Through Our Website: Don't forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can't wait to hear from you!
How to prepare for a job interview at British Pregnancy Advisory Service (BPAS)
✨Know Your Data Tools
Make sure you brush up on your SQL, Python, and any cloud platforms like Azure or Microsoft Fabric. Be ready to discuss specific projects where you've built automated data pipelines or transformed datasets. This will show that you not only understand the tools but can also apply them effectively.
✨Understand the Business Context
Research BPAS and their mission in reproductive healthcare. Understand how your role as a Data Engineer can impact their services. Being able to connect your technical skills to their purpose will demonstrate your commitment and help you stand out.
✨Prepare for Scenario Questions
Expect questions about how you would handle real-world data challenges, such as ensuring data quality or integrating multiple systems. Think of examples from your past experience where you successfully tackled similar issues and be ready to share those stories.
✨Showcase Your Collaboration Skills
Since you'll be working closely with BI Analysts and various stakeholders, highlight your teamwork experiences. Discuss how you've translated requirements into effective data solutions and contributed to knowledge sharing. This will show that you're not just a tech whiz but also a great collaborator.