Lead SQL Developer

Lead SQL Developer

Hybrid (2-3 days on-site in Norwich, NR4)

Inside IR35 paying £243 per day (Band 8a)

Job Summary

We are seeking an experienced Lead SQL Developer to support the implementation of a unified Electronic Patient Record (EPR) across one of NHS organisations. This is an exciting opportunity to play a pivotal role in enhancing patient care and advancing digital health capabilities across three major acute hospitals in the region.

As a Lead SQL Developer, you will be instrumental in developing, maintaining, and optimizing SQL databases within the system. Your expertise will be key in meeting the data needs of our healthcare partners, ensuring that our EPR systems support high-quality, efficient care for our diverse communities.

Responsibilities:

1. Lead a team of SQL data warehouse developers, fostering a collaborative and innovative environment.
2. Work closely with business analysts, solution architects, and project managers to understand data requirements and translate them into technical solutions.
3. Align with stakeholders across multiple departments to ensure data solutions meet strategic goals.
4. Design and implement a robust, scalable, and secure data warehouse that integrates data across the EPR system.
5. Develop and maintain ETL (Extract, Transform, Load) processes to ensure timely, accurate data flow.
6. Ensure data quality and consistency across the data warehouse for effective querying and reporting.
7. Create advanced SQL queries, develop complex stored procedures, and optimize data warehouse performance.
8. Leverage experience with cloud-based data warehousing solutions (e.g., Snowflake, AWS Redshift, Google Big Query) and data integration tools.

What do you need to be successful?

1. Extensive experience in the Business Intelligence development lifecycle, ideally within a healthcare setting.
2. Advanced proficiency in SQL Server Management Studio, scripting languages, and programming within a healthcare data environment.
3. Demonstrated experience in managing, developing, and recruiting staff.
4. Solid understanding of NHS data and regulations, with experience in addressing NHS data quality issues.
5. Experience and understanding of data quality issues within the NHS and how to resolve them.
6. Experience with cloud-based data warehousing solutions (e.g., Snowflake, AWS Redshift, Google Big Query) and data integration tools.

What is nice to have but not essential?

1. Background with NHS projects.
2. Knowledge of the NHS Data Dictionary and Data Model.

Attributes:

1. A proactive role model who aligns with our values, demonstrating commitment to Equality, Diversity, and Inclusion.
2. Adaptable to fast-paced environments with a willingness to work out of hours during peak periods of the EPR programme (e.g., weekends, evenings for upgrades).

This role provides a chance to drive real impact in patient care while advancing your career in a dynamic, supportive environment.