Business Intelligence Developer

Pharmacy Regulation; Greater London; Hybrid; GBP 52,000 - 70,000; Full time

Benefits offered by this job

30 days holiday (plus bank holidays)

Flexible working

Career breaks and sabbaticals

Life assurance

Season ticket loan

Bike loan

Job summary

General Pharmaceutical Council (GPhC) seeks a technically strong BI Developer to design, build and optimise enterprise BI solutions, including Power BI dashboards, data models and semantic layers. You’ll collaborate with IT, Data & Research and business teams to improve data quality and reporting capability.

You will develop insight and reporting on pharmacy registration, fitness to practise activity, inspections and assurance programmes, organisational performance and trends across the pharmacy

Qualifications

• Experience designing and building enterprise BI solutions.
• Strong Power BI dashboards, data models and semantic layers.
• Ability to govern BI environments and promote best practices.

Responsibilities

• Design, build and optimise enterprise BI solutions with Power BI and Tableau where appropriate.
• Improve data quality and underlying data structures with IT and Data teams.
• Lead BI initiatives and mentor colleagues while delivering technical delivery.
• Stay current with BI tools and methodologies to drive continuous improvement.
• Provide guidance or line management when needed and support the BI Manager.

Skills

Power BI

DAX

SQL

Data quality

Reporting

Tools

Power BI

Tableau

SQL

DAX

Job description

Are you a technically strong BI Developer who can design and build scalable data solutions that enable high-quality insight and reporting across the organisation? Join us at the General Pharmaceutical Council (GPhC) and help drive our mission to protect the public by ensuring safe and effective pharmacy practice.

The role

We’re looking for an experienced Business Intelligence Developer to design, build and optimise enterprise BI solutions, including Power BI dashboards, reports, data models and semantic layers. You’ll play a key role in developing our BI environment, working with IT, Data & Research and business teams to improve data quality, structure and reporting capability.

You'll develop insight and reporting relating to areas such as pharmacy registration, fitness to practise activity, inspections and assurance programmes, organisational performance, and trends across the pharmacy profession.

Your work will support colleagues and senior leaders to better understand performance, risks and trends, contributing to informed decision-making and improved outcomes across the pharmacy sector. This is a hands‑on technical role with opportunities to influence reporting and data solutions, mentor colleagues and help shape the future of business intelligence at GPhC.

The successful applicant will:

• Be confident developing and maintaining Power BI dashboards, reports and data models using DAX and SQL, while supporting existing Tableau reporting and helping to transition reporting to Power BI where appropriate.
• Take an active role in supporting and improving the organisation’s Power BI environment, including governance and best practice. Work closely with data architecture and data engineering colleagues to improve underlying data structures and data quality.
• Lead or contribute to BI initiatives, taking ownership of technical delivery and supporting less experienced colleagues where appropriate
• Stay current with emerging BI tools, trends, and methodologies to drive continuous improvement.
• Where required, provide guidance or line management to colleagues and deputise for the Business Intelligence Manager.
• Have a unwavering commitment to equality, diversity, and inclusion.

Benefits when joining our team

In return for their commitment and enthusiasm, employees can expect a rewarding and challenging work environment, good work‑life balance and workload plus an excellent benefits package that includes:

• 30 days holiday (plus bank holidays) with the option to buy an additional 5 days.
• Flexible working arrangements.
• Career breaks and sabbaticals.
• Life assurance, season ticket loan, bike loan and many more.

About the GPhC

We are a respected regulatory body that regulates pharmacists, pharmacy technicians and pharmacies in Great Britain. We work to assure and improve standards of care for people using pharmacy services.

Our organisation has a long‑term vision and a desire for highly skilled and specialist staff. We are committed to providing workforce learning and development opportunities.

We have adopted a hybrid working approach which combines office and home working. Staff are currently required to attend the office for a minimum of 12 days per quarter, with these arrangements due to be reviewed in January 2027.

We are proud of our diverse and inclusive culture and are committed to holding ourselves to the same standards we expect of others.

Follow this link to see our privacy policy and understand how we collect, use and share your personal data during our recruitment process.

We welcome applications from all sections of the community

We are committed to promoting equality, valuing diversity and being inclusive in all our work as a health professions regulator.

Whilst we are proud to be members of the Disability Confident Scheme, you don’t have to have a disability for us to discuss reasonable adjustments. Please let us know if you need any support during the application or interview process and we will happily discuss this with you.

If you have any queries please do write to us at [e-mail] or if you would like to speak to a member of the Talent Acquisition team please do call us on 0203 713 7880.

Important Notice for Applicants

As part of our pre‑employment screening process, this role is subject to a basic Disclosure and Barring Service (DBS) check. In addition, the GPhC will conduct Fitness to Practise (FtP) checks for any applicant who is currently, or previously been, a registrant of the GPhC. Applicants will be asked to declare this during the application process and may be subject to further internal verification. Any findings may be considered as part of the recruitment decision.