Data Engineer - Business Intelligence
Job summary
Are you a strong Data Engineer who builds reliable pipelines, improves data quality and delivers trusted data products?
BPAS is recruiting a Data Engineer to join the growing Business Intelligence team at an important stage of development. You will work with BI, Software Engineering, IT and business stakeholders to deliver secure, practical data solutions.
Reporting to the BI Lead, you will strengthen the data foundations that support reporting, analytics, service improvement and decision-making. You will design and maintain robust data pipelines and analytical data layers using Microsoft Fabric, Azure or similar platforms.
You will develop well-structured, high-quality datasets and governed outputs for reporting and analysis. You'll support secure data provision, including pseudonymised or anonymised outputs, in line with governance and data protection requirements.
Experience in machine learning or data science would be an advantage, but strong engineering capability is the priority.
This is a permanent, full-time, 36 hour hybrid role, with travel to Head Office in Leamington Spa typically 1 to 2 days per month.
Main duties of the job
- Build and maintain automated pipelines from SQL databases, API's and operational systems.
- Develop secure analytical data layers using Fabric, Azure or similar platforms.
- Transform, model and quality assure data for reporting, analytics and decision-making.
- Create reusable datasets, governed outputs and trusted reporting assets.
- Support secure access, governance, documentation and data lineage.
- Contribute to advanced analytics or ML use cases where relevant.
About You
We are looking for a rigorous data engineer with strong experience in integration, modelling and delivering reliable, well-documented data solutions. You should be confident moving data from operational systems into governed analytical environments, with strong attention to quality, control and secure handling of sensitive data.
You will work effectively with technical and non-technical colleagues and communicate clearly about data design, quality and delivery.
Experience within healthcare or population health data would be valuable but is not essential.
We are also looking for:
- Strong SQL, Azure and Fabric skills and proven experience building robust automated data pipelines.
- Experience with lake, lakehouse, warehouse or similar analytical platforms.
- Strong grasp of data modelling, quality, documentation, lineage and governance.
- Understanding of secure data access, GDPR and privacy-preserving methods.
- Ability to create trusted data assets for reporting, analytics and decision-making
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 to 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. Applicants must have the legal right to work in the UK at the time of application. Unfortunately, we are unable to offer visa sponsorship for this role.
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 Data Engineering, Computer Science, Information Systems, Mathematics, Statistics, Data Science, Business Analytics or a related field, or equivalent relevant experience
- Evidence of continued professional development in data engineering, cloud data platforms, SQL, Python, analytics engineering, secure data management or business intelligence.
- Current or recently held professional certification in Microsoft Fabric, Azure Data Engineering, Microsoft Data Engineering, SQL, Power BI, cloud platforms, data governance or related data technologies.
- Where certifications have expired, please describe how you have kept your knowledge current through practical delivery, renewal activity, formal learning or recent project experience.
- Training in data governance, GDPR, secure data management, Agile, DevOps or project delivery.
Experience
- 1. Data Pipelines and Integration: Experience developing automated data pipelines (including metadata driven) or data integration processes using SQL databases, APIs, operational systems, cloud data platforms or equivalent tools.
- 2. Data transformation, modelling and analytical use: Experience transforming, cleaning, modelling or structuring data for reporting, analytics, dashboards or organisational decision-making using Microsoft Fabric advanced tools and methodologies
- 3. BI, analytics and stakeholder delivery: Experience working with BI, analytics, technical or business stakeholders to ensure datasets are reliable, documented and suitable for reporting, analytical or approved organisational use
- 4. Documentation, lineage and data quality: Experience documenting data processes, including mappings, transformations, definitions, refresh logic, lineage, data quality checks or technical rules
- Experience working with healthcare, NHS, clinical, operational or other regulated datasets.
- Experience developing curated datasets, governed reporting layers, controlled data access models or pseudonymised/anonymised outputs.
- Experience supporting Power BI reporting through well-structured datasets, semantic models or governed reporting layers.
- Experience improving manual reporting processes through automation
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
- Are you aware we are unable to offer visa sponsorship for this role?
- 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
- 1. SQL and relational data: Strong SQL skills, with the ability to query, transform, validate and analyse data from relational databases or operational systems
- 2. Modern data platforms and engineering tools: Practical knowledge of data engineering tools or approaches such as Python, PySpark, Microsoft Fabric, Azure Data Factory, Synapse, Lakehouse, OneLake or equivalent platforms
- 3. Data quality, validation and reconciliation: Good understanding of data quality, validation, reconciliation, exception checking and how these affect reporting confidence
- 4. Secure data handling and privacy-conscious data provisioning: Understanding of secure data handling, GDPR, role-based access and privacy-preserving approaches such as pseudonymisation or anonymisation
- Knowledge of dimensional modelling, star schema, snowflake schema, data warehousing, lakehouse architecture or analytics engineering principles.
- Familiarity with Microsoft Purview or similar tools for metadata, lineage and governance.
- Use of Git, deployment scripting, DevOps, infrastructure-as-code or release management approaches in data projects.
- Proficiency in Microsoft Excel, Power Query, Power BI or related reporting and analytical tools.
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
United Kingdom
Employer's website
https://www.bpas.org