Optimum Patient Care Global Limited

Full Time, Part Time, Flexible, Permanent About the Role We are currently seeking an experienced and motivated Data Analyst to join our dynamic team within a global research organisation. This is an exciting opportunity for a data professional with a strong background in analytics and database management to play a key role in the development and delivery of high-impact health research projects. As a Data Analyst, you will support the Data Analytics Manager in leading data-focused projects across the organisation and its partner networks. You will contribute to the development and optimisation of database systems, deliver detailed analyses for research studies, and help guide data governance and quality practices. The role can be based in our Cambridge (Oakington) or Norwich office. We offer hybrid working as standard, which is Monday, Wednesday and Friday in the office and Tuesday and Thursday working from home. This role offers flexible working within the usual office hours of Monday - Friday, 9am - 5pm. Part time and close to full time working arrangements are available. Primary responsibilities 1) Solve complex problems in study and healthcare data, transforming large and diverse datasets into actionable insights that drive evidence-based decisions and improve patient outcomes. 2) Design, construct, install, test and maintain data collection and management systems 3) Assist in the development of the data analytics function and team, continuously striving to optimise data utilisation and delivery 4) Provide support and guidance to the team in the integration of data management technologies and software engineering tools for custom data collection applications 5) Employ a variety of languages and tools (e.g. scripting languages) to combine systems together ensuring seamless integration of data across multiple databases SQL, queries 6) Building APIs for data consumption; Integrating external or new datasets into existing data pipelines 7) Continuously monitor and test the system to ensure optimized performance, coaching key stakeholders in new ways of working 8) Build, maintain and oversee data collection platforms for specific organisational projects 9) Set up automated integration processes for Patient Reported Outcomes into various data collection platforms 10) EMR/EDC integration with Registry Database QUALIFICATIONS AND CERTIFICATIONS Bachelor's degree in computer science, Engineering, Maths or equivalent qualification EXPERIENCE AND SKILLS 1) Strong working knowledge of SQL/T-SQL (Essential) 2) At least three years' experience of working with large databases. 3) Experience of developing and maintaining data dictionaries for databases Knowledge of statistical analysis tools (e.g. R, STATA, SPSS, SAS) 4) The ability to effectively communicate to key project stakeholders including Senior Management 5) The ability to coach, mentor and support junior team members and provide training and guidance as necessary 6) Strong project management skills, the ability to work autonomously and prioritise own activities appropriately 1) Experience with REDCap EDC development, including designing electronic case report forms, managing study workflows, and ensuring data quality in clinical trials. 2) Experience working with modern data architectures and cloud platforms such as Microsoft Azure, Google Cloud Platform (GCP) or Snowflake 3) Knowledge of epidemiology, public health and clinical research About Optimum Patient Care 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.

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. Job Description 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 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. Key Requirements Strong commercial experience working with Microsoft SQL Server (+) 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 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. Following experience would be beneficial but is not required: 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#. Future Projects 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. Why Join Us 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.

A UK healthcare research organization is seeking a hands-on SQL Server ETL Engineer to develop and maintain data pipelines supporting clinical research. This role involves significant T-SQL development and SSIS package maintenance, focusing on data quality and integrity across large datasets. The ideal candidate will have strong SQL Server experience and familiarity with ETL processes. Join us to support significant real-world clinical research programmes and work with experts in the field.