Data Engineer - Business Intelligence

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?, 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., * 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

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

• 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

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., 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.