Data Architect

Overview

We are looking for a skilled freelance Data Engineer/Data Architect to design and implement scalable and secure data solutions specifically for pharmaceutical research and clinical trials. The role involves collaborating with stakeholders, clinical and research teams to transform complex data requirements into effective data platforms. The ideal candidate should have significant hands-on experience in data engineering and architecture, particularly with R, Python, SQL, and Azure platforms.

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, transformation layers, and reporting/consumption layers.
  • Build scalable ETL/ELT pipelines to ingest and integrate data from various sources.
  • Develop complex SQL queries, stored procedures, views, indexes, and other database objects.
  • Create reusable code libraries and analytical components that support clinical-trial use cases.
  • Connect solutions to Microsoft Azure environments and implement using relevant Azure services.
  • Ensure data quality and auditability across delivered solutions while documenting technical specifications.

Requirements

  • Significant experience as a Data Engineer, Data Architect, or similar in pharmaceutical, biotech, or life sciences industries.
  • Strong coding experience in R and Python for data analysis and engineering tasks.
  • Advanced SQL skills for complex querying and database-object development.
  • Proven experience in designing and delivering ETL/ELT pipelines and data-integration solutions.
  • Deep understanding of data architecture, including data lakes and dimensional modeling.
  • Hands-on experience with Microsoft Azure and data solutions within the cloud environment.
  • Experience developing dashboards and reports using Tableau and/or Power BI.
  • Ability to integrate external datasets while ensuring data quality and governance.