Remote Protocol Data Engineer — AI-Driven Clinical Trials

A P Ventures LLC; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

A P Ventures LLC is seeking a hands-on protocol data engineer to support an FDA proof-of-concept for AI-assisted clinical trial protocol review and data engineering tasks across ICH M11-aligned standards.

You will build and maintain ETL/ELT pipelines, ensure provenance and quality, collaborate with AI/SMEs, and integrate with FDA-provided data environments, including PostgreSQL, HALO, and Databricks, in a remote setting.

Qualifications

• Extensive experience in database engineering, data architecture, information modeling, and analytics in complex enterprise environments.
• Strong expertise in relational and dimensional data modeling, metadata management, ETL/ELT design, data warehousing, and data quality.
• Advanced SQL skills, including PostgreSQL/PLpgSQL and/or Oracle PL/SQL; SQL Server experience beneficial.
• Experience with AWS data services and cloud DB platforms such as Aurora PostgreSQL, Redshift, S3, Glue, Lambda, DMS.
• Experience integrating JSON/XML data and RESTful APIs; working knowledge of Python and CI/CD practices beneficial.
• Federal health, clinical research, or regulated-environment experience preferred; familiarity with FISMA/NIST controls beneficial.

Responsibilities

• Implement protocol data structures and physical schemas for extraction, normalization, storage, retrieval, comparison, and reviewer-facing use.
• Translate ICH M11, CDISC USDM, ontology, metadata, and terminology models into practical database structures and components.
• Develop and support ETL/ELT pipelines and data transformations, preserving source provenance, metadata, validation status, and reviewer feedback.
• Collaborate with AI/prompt engineering and standards SMEs to support RAG, semantic retrieval, indexing, and protocol comparison components.
• Support integration with FDA-furnished Elsa/HALO capabilities and FDA-approved data services for evidence caching, retrieval, analytics, and dashboards.
• Build advanced SQL and data-access logic for protocol extraction, historical retrieval and comparison, reviewer dashboards, and traceability to source evidence.
• Perform data-focused quality assurance, reconciliation, validation, and regression testing.
• Document data models, interfaces, transformations, mappings, implementation decisions, and operational considerations for FDA review and knowledge transfer.
• Work closely with clinical protocol, data standards, architecture, interoperability, and AI/prompt SMEs.
• Participate in FDA technical working sessions, POC demonstrations, validation activities, and iterative refinement based on reviewer feedback.
• Support implementation within FDA-provided platforms and approved data environments; the base effort is a POC and does not require a production platform.
• Provide practical database engineering and data-quality expertise while relying on SMEs for clinical interpretation and governance.

Skills

Database engineering

Data architecture

Information modeling

Analytics

Advanced SQL

RESTful APIs

Python basics

CI/CD practices

FISMA/NIST familiarity

Education

BS degree in Computer Science, Mathematics, Data Science or relevant technical field

Tools

PostgreSQL

PLpgSQL

Oracle PL/SQL

SQL Server

AWS data services

Aurora PostgreSQL

Redshift

S3

Glue

Lambda

DMS

JSON

XML

RESTful APIs

Python

CI/CD

Elsa/HALO

HALO/Databricks

ETL/ELT

RAG

FISMA

NIST

ICH M11

CDISC USDM

Job description

A P Ventures LLC is seeking a hands-on protocol data engineer to support an FDA proof-of-concept for AI-assisted clinical trial protocol review and data engineering tasks across ICH M11-aligned standards.

You will build and maintain ETL/ELT pipelines, ensure provenance and quality, collaborate with AI/SMEs, and integrate with FDA-provided data environments, including PostgreSQL, HALO, and Databricks, in a remote setting.