BI Developer

VC Evidensia UK; United Kingdom; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

Pet Drugs Online, part of IVC Evidensia, is hiring a BI Developer to transform data into actionable insights and support decision-making across the business. You will build dashboards in Power BI, optimize data models, and collaborate with stakeholders to deliver robust reporting solutions on a hybrid work arrangement with three days on-site in Keynsham.

You will also help rebuild data warehousing, maintain data pipelines, and contribute to BI governance and best practices to ensure scalable

Qualifications

• Strong commercial experience with Power BI and Power BI Service, including dataflows, apps, and gateway management.
• Proven experience designing and optimising data models within Power BI.
• Advanced SQL skills, including complex query writing, optimisation, and working with large datasets.
• Solid understanding of data warehousing principles, ETL/ELT processes, dimensional modelling, and data transformation.
• Experience working with ETL/ELT tools such as Azure Data Factory, SSIS, or similar technologies.
• Experience delivering end-to-end BI solutions, from requirements gathering through to deployment.
• Strong stakeholder management skills with the ability to communicate effectively with both technical and non-technical audiences.
• Excellent analytical and problem-solving abilities, with strong attention to detail.

Responsibilities

• Designing and developing engaging dashboards and reports using Power BI.
• Transforming complex data into clear, meaningful insights that support business performance.
• Writing and optimising SQL queries, views, and datasets to underpin reporting solutions.
• Building and maintaining reliable data pipelines to support efficient data ingestion and transformation.
• Collaborating with data owners and business stakeholders to translate requirements into effective technical solutions.
• Troubleshooting issues across the data lifecycle, from source systems and ETL processes through to front-end reporting.
• Monitoring and improving report, dataset, and query performance.
• Supporting BI governance, documentation, and best practices to ensure a scalable and reliable reporting environment.
• Contributing to the ongoing evolution of our data and analytics capabilities.

Skills

Power BI

Power BI Service

Advanced SQL

Data modelling

ETL/ELT

Stakeholder management

Analytical thinking

Python

Azure Data Factory

SSIS

Tools

Azure Data Factory

SSIS

Job description

IVCEvidensiais the UK and Europe’s leading veterinary care group, made up of over 900 practices and referral hospitals, united by a shared purpose of happier animals, happier owners.

At IVCEvidensia, we believe careers should be built without limits. Our people are supported to make more impact, access more career opportunities, and play an active role in their local and professional communities. Through investment in learning, innovation, and wellbeing, we create environments where our teams can grow in confidence, capability, and fulfilment—at every stage of their career.

Pet Drugs Online is one of the UK’s leading online pet pharmacies and retailers, helping pet owners access trusted medication, healthcare products, and everyday essentials quickly, safely, and conveniently. As part of the IVCEvidensiaGroup, Pet Drugs Online combines the agility of a growing ecommerce business with the strength andexpertiseof a leading veterinary careorganisation.

Our teams play a vital role in making pet healthcare more accessible through innovation, operational excellence, and outstanding customer experience.

Help Shape the Future of Data at Pet Drugs Online

We’re looking for a BI Developer to join our growing team and play a key role in transforming data into meaningful insights that help our business thrive.

If you're passionate about Power BI, enjoy solving complex data challenges, and love working closely with stakeholders to deliver impactful reporting solutions, we'd love to hear from you.
The role requires 3 days per week on site in our Keynsham office.

What You'll Be Doing

As our BI Developer, you'll be responsible for building, maintaining, and enhancing our business intelligence capability across the organisation.

You'll work with stakeholders from across the business to understand reporting needs, develop robust data solutions, be pivotal in our data warehouse rebuild, and ensure decision-makers have access to accurate, actionable insights.

Your responsibilities will include:

• Designing and developing engaging dashboards and reports using Power BI.
• Transforming complex data into clear, meaningful insights that support business performance.
• Writing and optimising SQL queries, views, and datasets to underpin reporting solutions.
• Building and maintaining reliable data pipelines to support efficient data ingestion and transformation.
• Collaborating with data owners and business stakeholders to translate requirements into effective technical solutions.
• Troubleshooting issues across the data lifecycle, from source systems and ETL processes through to front-end reporting.
• Monitoring and improving report, dataset, and query performance.
• Supporting BI governance, documentation, and best practices to ensure a scalable and reliable reporting environment.
• Contributing to the ongoing evolution of our data and analytics capabilities.

What We’re Looking For

• Strong commercial experience with Power BI and Power BI Service, including dataflows, apps, and gateway management.
• Proven experience designing and optimising data models within Power BI.
• Advanced SQL skills, including complex query writing, optimisation, and working with large datasets.
• Solid understanding of data warehousing principles, ETL/ELT processes, dimensional modelling, and data transformation.
• Experience working with ETL/ELT tools such as Azure Data Factory, SSIS, or similar technologies.
• Experience delivering end-to-end BI solutions, from requirements gathering through to deployment.
• Strong stakeholder management skills with the ability to communicate effectively with both technical and non-technical audiences.
• Excellent analytical and problem-solving abilities, with strong attention to detail.

Nice to Have

• Experience using Python for data analysis, automation, or pipeline support.
• Knowledge of SQL Server administration, performance tuning, indexing, and maintenance.
• Advanced DAX development and optimisation experience.
• Experience enabling self-service BI through training, documentation, or user support.
• Experience within e-commerce, retail, veterinary, or consumer-focused businesses.

Why Join Pet Drugs Online?

At Pet Drugs Online, you'll be joining a business that's growing fast, investing in technology, and passionate about delivering exceptional experiences for pets and their owners.

You’ll have the opportunity to:

• Make a genuine impact on business decisions through data.
• Work with modern BI and data technologies.
• Collaborate with talented colleagues across multiple functions.
• Contribute to the development of a data-driven culture.
• Grow your skills and career within a supportive and ambitious environment.

Pet Drugs Online

At IVC Evidensia we are a committed to Diversity, Equality, Inclusion and Belonging, we are keen to hear from candidates from all minority and diverse groups. As a Disability Confident Employer, we are keen to hear from candidates with disabilities and long-term health conditions and would be happy to discuss any reasonable adjustments needed during the recruitment process.

Any questions before applying?

Speak to Jake Nicholls from our recruitment team who would be happy to help you with any questions you have before applying for this role.