Business Intelligence Analyst - 36 hours
Job summary
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 a minimum one year 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
Job responsibilities
A full job description and further salary information is available for you to review and download.
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
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
- Degree in Computer Science, Data Science, Business Analytics, Mathematics, Statistics, or a related field, OR equivalent experience
- Additional training in Power BI, SQL, or data visualisation techniques
Experience
- 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
- Familiarity with ETL processes, data warehousing, or automation of reporting tasks
Skills and Knowledge
- 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
- 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
- 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?
- Please list any further information/statements you wish to support your application.
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