EPR Lead SQL Developer (NHS AfC: Band 8a) - EPR - Norfolk and Norwich University Hospitals NHS Foundation Trust
Norfolk and Norwich University Hospitals NHS Foundation Trust – Norwich, Norfolk
We have embarked on a programme to implement a single Electronic Patient Record (EPR) as part of the NHS digital health ongoing initiative across the Norfolk and Waveney Acute Hospital Collaborative (NWAHC). The collaborative is made up of three acute hospitals in Norfolk and Waveney:
* James Paget University Hospitals NHS Foundation Trust (JPUH)
* Norfolk and Norwich University Hospitals NHS Foundation Trust (NNUH)
* The Queen Elizabeth Hospital King's Lynn NHS Foundation Trust (QEH)
This is a unique opportunity to contribute your skills and expertise to create a meaningful impact on the health and well-being of individuals throughout Norfolk and Waveney. We are dedicated to advancing our digital capabilities in alignment with our long-term strategic goals, ensuring a high standard of patient care and safety for our diverse communities.
An EPR Lead SQL Developer plays a critical role in the development, maintenance, and optimization of SQL databases and applications within MEDITECH Expanse. The role involves technical expertise, strong leadership, and a deep understanding of NHS data and regulations.
Join us at the Norfolk and Norwich University Hospital and be part of a workforce of over 10,000 staff!
The NNUH is one of the largest NHS trusts in the UK, providing first-class acute care for around one million people living in Norfolk and surrounding areas. We are a teaching and research hospital, at the forefront of innovation, home to state-of-the-art facilities, such as the Quadram Institute. We attract some of the best and leading professionals from across the country and are proud that our workforce represents 94 countries from across the world.
We can offer you the full range of NHS benefits/discounts and in addition:
* Fast Track Staff Physiotherapy Service
* Multi Faith prayer room
* Discounted gym memberships
* Excellent pension scheme and annual leave entitlement
* Wagestream - access up to 40% of your pay as you earn it
* Free Park & Ride service direct to NNUH site
* Free 24-hours confidential counselling support
* On-site Nursery
* On-site cafes offering staff discounts
* Flexible staff bank
* Salary Sacrifice schemes including lease cars, Cycle to Work scheme and home electronics
Key Responsibilities:
1. Lead a team of SQL data warehouse developers.
2. Collaborate closely with business analysts, solution architects, and project managers across all three trusts to understand data requirements and translate them into technical specifications.
3. Work effectively with stakeholders across different business units to ensure alignment and successful delivery.
4. Support the design and implementation of a robust, scalable, and secure data warehouse solution that integrates data from various source systems within the EPR landscape.
5. Develop and maintain ETL (Extract, Transform, Load) processes to populate the data warehouse with accurate and timely data.
6. Ensure data quality, integrity, and consistency across the data warehouse.
7. Optimize data warehouse performance for efficient querying and reporting.
8. Strong understanding of data warehousing principles, methodologies, and best practices.
9. Expertise in data modelling techniques (dimensional modelling, star schema, etc.).
10. Proficiency in SQL and experience with data warehouse platforms (e.g., Snowflake, AWS Redshift, Google BigQuery).
11. Knowledge of data integration tools and technologies.
12. Experience with cloud-based data warehousing solutions is highly desirable.
#J-18808-Ljbffr