Business Intelligence Developer

OptumUK; Leeds; On-site; GBP 50,000 - 70,000; Full time

Job summary

A healthcare solutions provider is seeking a Business Intelligence Developer to enhance critical data systems supporting healthcare decisions in the UK. The role involves designing ETL processes, optimizing queries, and managing database environments using Microsoft technologies. Ideal candidates will have a strong background in SQL Server and experience with SSIS, SSRS, and data warehousing principles. This is a collaborative position focused on continuous improvement and upskilling in emerging technologies.

Qualifications

• Expert-level understanding of Microsoft SQL Server (2022 preferred).
• 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.

Responsibilities

• 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 and engineers to meet operational goals.
• Participating in continuous improvement initiatives.

Skills

Expert-level understanding of Microsoft SQL Server

Strong experience with SSIS

Strong experience with SSRS

Strong experience with SSAS

Proven ability to write and optimise T-SQL queries

Solid understanding of data warehousing principles

Experience working with large datasets

Proactive mindset

Collaborative approach to problem-solving

Job description

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.