Business Intelligence Developer

The Vacancy

Are you a Business Intelligence Developer looking for a permanent role where your work directly supports the delivery of healthcare services across the UK? Do you enjoy working with data, solving real-world problems, and continuously learning new technologies? If so, this opportunity at Optum UK could be the perfect fit.

We're looking for a BI Developer to join our team supporting business-as-usual (BAU) operations. This is a hands-on role focused on maintaining and enhancing critical data systems that underpin healthcare decision-making. You'll be working with modern Microsoft technologies and have the opportunity to retrain and upskill as new tools and platforms are introduced.

What you'll do

At Optum UK, we believe in the power of data to drive better healthcare outcomes. In this role, you'll be part of a team that ensures our data infrastructure is robust, efficient, and continuously evolving.

Key responsibilities include

• Designing, developing, and maintaining ETL processes
• Writing and optimising complex queries for data extraction and transformation
• Supporting BAU data operations and ensuring consistent data delivery
• Creating and managing reports
• Developing analytical models)
• Managing and troubleshooting database environments
• Ensuring data integrity, quality, and consistency across systems
• Collaborating with data architects, engineers, to meet operational goals
• Participating in continuous improvement initiatives and exploring new technologies
• Collaborating with stakeholders to develop new and innovative reporting and data solutions.

Who you'll be

You'll be an experienced BI Developer who thrives in a data-rich environment and enjoys solving practical problems. You'll be detail-oriented, technically strong, and eager to learn.

We're looking for someone with

• Expert-level understanding of Microsoft SQL Server (2022 preferred).
• Strong experience with SSIS, SSRS, SSAS, and SSMS.
• Proven ability to write and optimise T-SQL queries.
• Solid understanding of data warehousing principles and practices.
• Experience working with large datasets and delivering reliable data transformations.
• A proactive mindset and a collaborative approach to problem-solving.
• Interest in retraining and upskilling with emerging technologies.