Business Intelligence Analyst - 36 hours (12m Maternity Cover)

The Methodist Church in Britain; West Midlands; Hybrid; GBP 30,000 - 42,000; Full time

Job summary

British Pregnancy Advisory Service (BPAS) is seeking a fixed-term Business Intelligence Analyst on maternity cover, within its BI function. The role centers on pulling data from multiple systems, building Power BI reports and dashboards, and turning complex datasets into insight for planning and performance.

The post spans clinical services, finance, operations and IT, is full-time at 36 hours, Monday to Friday, with hybrid working.

Qualifications

• Two years in BI/reporting role
• Deliver BI outputs to support decisions
• Work with stakeholders to gather requirements
• Hands-on data modelling and Power BI development
• SQL querying experience

Responsibilities

• Extract, transform and load data from multiple systems and sources
• Build and maintain Power BI visualisations and dashboards
• Analyse complex datasets to check accuracy and draw out insight
• Work with stakeholders to pin down reporting needs and produce usable outputs
• Help shape reporting solutions and how data is used across the organisation
• Train and support users of dashboards and reporting tools
• Ensure compliance with data protection law and internal governance policies
• Improve reporting frameworks and data infrastructure
• Keep current with trends in business intelligence, analytics and data visualisation

Skills

SQL querying

Power BI design

Analytical thinking

Stakeholder comms

Education

Bachelor's degree in CS/data science or related field

Tools

Power BI

SQL

Job description

A fixed-term Business Intelligence Analyst post covering maternity leave at the British Pregnancy Advisory Service, within its growing BI function. The work centres on pulling data from several systems, building Power BI reports and dashboards, and turning complex datasets into insight for planning and performance. The post spans clinical services, finance, operations and IT, is full-time at 36 hours Monday to Friday, and includes hybrid working. Visa sponsorship is not offered, and applicants must support a women's right to choose.

What the job involves

• Extract, transform and load data from multiple systems and sources
• Build and maintain Power BI visualisations and dashboards
• Analyse complex datasets to check accuracy and draw out insight
• Work with stakeholders to pin down reporting needs and produce usable outputs
• Help shape reporting solutions and how data is used across the organisation
• Train and support users of dashboards and reporting tools
• Ensure compliance with data protection law and internal governance policies
• Improve reporting frameworks and data infrastructure
• Keep current with trends in business intelligence, analytics and data visualisation

What’s required

Qualifications

• Degree in computer science, data science, business analytics, mathematics, statistics or a related field, or equivalent experience

Experience

• At least two years in a similar BI, analytics or reporting role
• Delivering BI, analytics or reporting work and showing how outputs supported decisions
• Working with business stakeholders to understand reporting requirements
• Hands-on data modelling, Power BI report development and SQL querying

Skills & knowledge

• Using Microsoft SQL for data querying and analysis
• Designing and developing reports and dashboards in Power BI
• Strong analytical mindset and problem-solving ability
• Communicating insight clearly to technical and non-technical stakeholders

Checks & eligibility

• Legal right to work in the UK at the time of application
• Satisfactory pre-employment checks
• Three years of employment references, including reasons for leaving and any gaps

Other

• Support a women's right to choose, in line with BPAS values
• Commit to 36 hours a week, Monday to Friday, with hybrid travel to head office (travel not reimbursed)

Nice to have

• Additional training in Power BI, SQL or data visualisation
• Familiarity with ETL processes, data warehousing or reporting automation
• Advanced Excel, including pivot tables, Power Query and VBA
• Understanding of Statistical Process Control
• Knowledge of cloud-based BI tools and database integration
• Knowledge of GDPR and experience in data governance frameworks

What’s offered

• 34 days annual leave including bank holidays
• Life assurance at 3 times salary
• Defined contribution pension scheme
• GP access 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