Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and maintain T-SQL ETL pipelines for large-scale clinical research datasets.
- Company: Join a not-for-profit social enterprise supporting healthcare research across the UK.
- Benefits: Gain hands-on experience with SQL Server, competitive salary, and a collaborative work environment.
- Other info: Opportunity for career growth in a dynamic, research-focused team.
- Why this job: Make a real impact on healthcare research while working with massive datasets.
- Qualifications: 3-6 years of SQL Server ETL experience and strong T-SQL skills required.
The predicted salary is between 36000 - 60000 £ per year.
Optimum Patient Care has been supporting chronic disease management and research in primary care for over 15 years. We are a not-for-profit social enterprise which provides a range of services to over 1000 GP surgeries across England, Scotland, Wales and Northern Ireland. Our services include clinical audit and review services, IG‐compliant data extraction services, and research support services. Our services are provided at no cost to participating practices and freely available to all GP surgeries across the UK. Our anonymised research database, OPC Research Database (OPCRD), is one of the largest electronic health record databases in the world for research use, with over 17 million anonymised patients.
We are seeking a hands‐on SQL Server ETL Engineer to work on large‐scale T‐SQL and SSIS‐based data pipelines supporting national GP clinical research datasets. The role focuses on maintaining and improving a mature on‐premises SQL Server 2019 environment responsible for ingesting and processing high‐volume clinical data used in real‐world research. This role requires strong hands‐on SQL Server and SSIS experience. It is not a cloud‐platform or Spark/Snowflake data engineering role. The position is script‐heavy and database‐centric, involving significant T‐SQL development, ETL scripting, SSIS package maintenance, and large‐scale data processing across very large databases.
Key Responsibilities- SQL Server ETL Development
- Develop and maintain T‐SQL based ETL pipelines running on SQL Server 2019.
- Data Processing & Data Quality
- Investigate and resolve data integrity and quality issues across multiple research databases.
- Write historic correction scripts to fix data anomalies across large datasets.
- Implement validation and consistency checks during data ingestion and transformation.
- Performance & Database Engineering
- Optimise ETL queries and batch processes running against very large tables (billions of rows).
- Analyse and tune query execution plans, indexing strategies, and partitioned tables.
- Improve performance of data loads and batch ETL processing.
- Operational Database Work
- Support operational SQL Server tasks including integrity checks and troubleshooting failed imports.
- Manage file‐based data ingestion, including large CSV imports and server directory management.
- Maintain and improve SSIS packages and SQL‐driven import scripts.
- Manage ~700 automated data imports per month from multiple GP clinical systems.
- Maintain and extend 150+ ETL scripts responsible for data ingestion, transformation, and validation.
- Adapt ETL pipelines as data formats and source system specifications evolve.
- Strong commercial experience working with Microsoft SQL Server (2016–2019+).
- Stored procedures, complex joins and transformations, large batch processing scripts, error handling and logging.
- Hands‐on experience building or maintaining ETL pipelines using SSIS.
- Experience working with large datasets (hundreds of millions to billions of rows).
- Experience with query optimisation and performance tuning, including execution plan analysis and partitioned tables.
- Experience working in script‐driven ETL environments.
- Comfortable working directly with database servers and file‐based data imports.
- Typical candidates will have approximately 3–6 years experience in SQL Server ETL, BI development, or database engineering roles.
- Experience working with clinical, healthcare, or research datasets.
- Familiarity with SNOMED CT or OMOP CDM.
- Experience with PostgreSQL.
- Experience building ETL utilities in Java or C#.
- Migration of one major research database to a PostgreSQL clustered platform, expanding our data infrastructure rather than replacing SQL Server.
- Development of OMOP‐compatible data pipelines to strengthen interoperability and support advanced research workflows.
- National GP clinical datasets used in medical and population health research.
- Extensive use of T‐SQL, SSIS, and batch ETL scripting.
- Very large datasets containing billions of clinical records.
- Collaborative technical team of engineers, DBAs, and research specialists.
You will help maintain and develop the data infrastructure supporting some of the UK's most significant real‐world clinical research programmes. This role offers the opportunity to work deeply with large‐scale SQL Server ETL systems and complex healthcare datasets in a collaborative research‐focused organisation.
SQL Server ETL Engineer (T-SQL / SSIS) – Intermediate in Norwich employer: Optimum Patient Care Global Limited
Contact Detail:
Optimum Patient Care Global Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Server ETL Engineer (T-SQL / SSIS) – Intermediate in Norwich
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with people on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! If you’ve got a portfolio of projects or GitHub repositories, make sure to highlight them. This is your chance to demonstrate your SQL Server and SSIS expertise in action.
✨Tip Number 3
Prepare for interviews by brushing up on common SQL and ETL questions. Practice explaining your past projects and how you tackled challenges. Confidence is key, so let your passion for data shine through!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are genuinely interested in joining our mission at Optimum Patient Care.
We think you need these skills to ace SQL Server ETL Engineer (T-SQL / SSIS) – Intermediate in Norwich
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your SQL Server and SSIS experience. We want to see how your skills match the job description, so don’t be shy about showcasing your T-SQL development and ETL pipeline work!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re passionate about working with large datasets and how your experience aligns with our mission at Optimum Patient Care. Keep it engaging and relevant!
Showcase Your Problem-Solving Skills: In your application, mention specific examples where you've tackled data integrity issues or optimised ETL processes. We love seeing how you’ve made an impact in previous roles, especially with large-scale data processing.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at Optimum Patient Care Global Limited
✨Know Your SQL Inside Out
Make sure you brush up on your T-SQL skills before the interview. Be prepared to discuss complex joins, stored procedures, and how you've handled large batch processing scripts in the past. They’ll likely want to see your problem-solving skills in action!
✨Showcase Your ETL Experience
Since this role is heavily focused on ETL processes, come ready to talk about your hands-on experience with SSIS. Share specific examples of ETL pipelines you've developed or maintained, and be ready to discuss any challenges you faced and how you overcame them.
✨Prepare for Data Quality Questions
Expect questions around data integrity and quality issues. Think of scenarios where you had to investigate and resolve data anomalies. Highlight your approach to implementing validation checks during data ingestion and transformation.
✨Demonstrate Performance Optimisation Skills
Be ready to discuss your experience with query optimisation and performance tuning. They might ask you to analyse a query execution plan or suggest improvements for large datasets. Bring examples of how you've improved performance in previous roles to the table.