Principal Data Engineer RWE RWD

• Development of data processes for the automated ongoing generation of patient level data (the “data product”) to be used by various business stakeholders for a variety of purposes (e.g. dashboards, reports, studies).
• Downstream manipulation of datasets after their onboarding from data vendors/partners (an activity predominantly carried out by the vendors and Client IT department) from “raw” format as provided into useable data structures that will be used to carry out RWE studies, dashboards & other data outputs
• Transformation of raw datasets into usable datasets
• Occasional conversion of bespoke / one-off datasets (e.g. biomarkers, mutations) to OMOP format (including an understanding of what can and cannot be converted to OMOP format, e.g. to allow analysis to be carried out on residual data that cannot be converted to OMOP).

Communication

• Technical engagement with key stakeholders (e.g. epidemiologist, statisticians, market access/health economists) from outside the RWE programming team to ensure a full and detailed understanding of end-user requirement is created and carefully documented. This includes scoping discussions, business analysis and translation of verbalised end-user needs into actionable data structures
• Detailed technical engagement with colleagues from within the RWE programming team to build data structures required for the generation of RWE study outputs and data products; also support those team members in creating the study outputs where the data engineer’s skillset can add incremental value
• Liaison & ongoing interaction with IT department to ensure that raw datasets inbound from data partners are fit for the agreed purposes (as per bullet point 1 above)
• Liaise, where required, with technical staff employed by analysis software vendors (Databricks etc)

Documentation

• Maintain clear documentation of data flows, schemas, pipelines, and processes to facilitate onboarding, troubleshooting and auditing.

Quality, Validation & Support

• Design and carry out detailed testing (data validation and monitoring) approaches for data structures built by self or other members of team to ensure the accuracy and reliability of the data within the data product
• Troubleshoot any issues encountered with data loading, extraction and transformation (ETL)
• Work in collaboration with three other members of the Data Engineering team, taking on workload from others as and when required