Business Intelligence Analyst

*This role is on a 12 month FTC covering maternity leave

Do you have a sharp analytical mindset and a passion for turning data into insight?

Are you confident using Power BI to produce meaningful reports that inform and improve services?

BPAS is looking for a talented Business Intelligence Analyst to join our team. You'll play a key role in delivering high-quality data analysis, reporting and insight that drives performance, informs planning, and helps shape services across our organisation.

This is an exciting opportunity to join a growing Business Intelligence function at an important stage of development. You will help expand our reporting capability and support increasing organisational reliance on data-driven decision-making.

You'll take an active role in shaping reporting solutions and improving how data is used across the organisation, working across departments including clinical services, finance, operations and IT.

This is a permanent, full time role working 36 hours per week over Monday to Friday. It is a hybrid arrangement, where you will come to Head Office in Leamington Spa, typically 1-2 days a month.

Main duties of the job

• Extract, transform, and load (ETL) data from a range of systems and sources
• Develop and maintain data visualisations and dashboards in Power BI
• Provide training and support to users of dashboards and reporting tools
• Analyse and interpret complex datasets to ensure accuracy, consistency and meaningful insight
• Ensure compliance with data protection legislation and internal governance policies
• Identify and support improvements in reporting frameworks and data infrastructure
• Work with stakeholders to understand reporting needs and deliver practical, user-friendly outputs
• Keep up to date with industry trends and advancements in business intelligence, analytics, and data visualisation

About You

The successful candidate will hold a degree (or equivalent experience) in a relevant field alongside two years of experience in a similar BI, Analytics or reporting role. You should excel in Power BI for designing and developing reports including hands on experience in data modelling and SQL querying.

Your strong analytical mindset, problem-solving abilities, & excellent interpersonal skills will be crucial in effectively communicating insights & recommendations to technical and non-technical stakeholders.

We are also looking for:

• Knowledge of GDPR and experience working within data governance frameworks
• Experience working directly with stakeholders to understand reporting requirements

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

A full job description and further salary information is available for you to review and download on the right hand side of the NHS Jobs advert.

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

Salary £40,000 - £50,000 per annum depending on skills and experience

Contract 12 months fixed term covering maternity leave

Hours 36 hours per week

Hours of Work Monday to Thursday 09:00 to 17:00 | Friday 09:00 to 15:30

Location Hybrid working with travel to head office approximately 1 -2 days per month- although this may be more frequent during the initial familiarisation process

BPAS Head Office, Orion House, Athena Drive, Tachbrook Park, Leamington Spa, CV34 6RQ

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

Essential

• Degree in Computer Science, Data Science, Business Analytics, Mathematics, Statistics, or a related field, OR equivalent experience

Desirable

• Additional training in Power BI, SQL, or data visualisation techniques

Experience

Essential

• Please describe your experience delivering BI, analytics, or reporting work, including how your outputs have been used to support decision-making
• Experience working with business stakeholders to understand reporting requirements
• Hands-on experience in data modelling, Power BI report development, and SQL querying

Desirable

• Familiarity with ETL processes, data warehousing, or automation of reporting tasks

Skills and Knowledge

Essential

• Please describe your experience using Microsoft SQL for data querying and analysis, including examples of the types of queries or datasets you have worked with
• Please describe your experience designing and developing reports in Power BI, including examples of dashboards or reporting solutions you have created

Desirable

• Proficiency in Microsoft Excel, including advanced functions such as pivot tables, Power Query, and VBA
• Understanding of Statistical Process Control (SPC) methodology
• Knowledge of cloud-based BI tools and integration with databases

General

Essential

• 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 the nature of the relationship.
• This role is for 36 hours per week over Monday to Friday. It's a hybrid position with travel expected to our Head Office in Leamington Spa 1-2 days a month. (Travel is not reimbursed) This may be more in the initial familiarisation process. Can you commit to this?
• Are you aware this role is on a 12m FCT?

Desirable

• Please list any further information/statements you wish to support your application.