Overview
We are looking for a seasoned freelance Data Engineer and Data Architect to design and deliver robust data solutions specifically for the pharmaceutical research and clinical trials sector. This role involves collaborating with stakeholders from various teams to develop scalable systems that ensure data quality, governance, and compliance. The successful candidate will utilize their expertise in R, Python, and SQL to create data pipelines and analytical dashboards, while navigating complex data environments to support critical research activities.
Responsibilities
- Act as a senior Data Engineer and Data Architect across pharmaceutical research and clinical-trial data initiatives.
- Engage with stakeholders to understand business, clinical, analytical, operational, and reporting requirements.
- Design end-to-end data architectures, including ingestion, raw and curated data zones, transformation layers, data models, and reporting/consumption layers.
- Build scalable ETL/ELT pipelines to ingest, cleanse, standardise, validate, transform, and integrate data from various sources.
- Develop and optimise complex SQL queries, stored procedures, views, and other database objects.
- Develop reusable, well-documented code libraries and analytical components that support research use cases.
- Ensure data quality, lineage, traceability, and security in delivered solutions.
- Produce clear technical documentation and ensure effective communication of progress to stakeholders.
Requirements
- Significant experience as a Data Engineer, Senior Data Engineer, Data Architect, or equivalent within pharmaceutical or regulated industries.
- Strong, demonstrable hands-on coding experience in both R and Python.
- Advanced SQL skills, including complex querying, data validation, and performance tuning.
- Proven experience designing and delivering ETL/ELT pipelines and data-integration solutions.
- Deep understanding of data architecture, including data lakes, warehouses, and dimensional modelling.
- Hands-on experience with Microsoft Azure environments and related services.
- Experience creating dashboards and reports using Tableau and/or Power BI.
- Ability to effectively communicate technical concepts to both technical and non-technical stakeholders.