Clinical Data Ingestion

SIRO; Mexico; On-site; PHP 7,326,000 - 9,158,000; Full time

Job summary

SIRO in the Clinical Data domain seeks a Senior Manager for Ingestion to lead data feeds into review platforms like Veeva CDB, Elluminate, and JReview, ensuring quality and timeliness of data loads.

You will build reusable ingestion components, monitor transfers, and enforce data contracts for analytics and programming teams while coordinating with vendors and stakeholders in regulated environments.

Qualifications

• BS/BA (or equivalent) plus 7+ years in data ingestion/integration, ETL/ELT operations, or clinical data pipeline support.
• Preferred platform exposure: Veeva CDB, Elluminate, and/or JReview (or comparable clinical data review systems).
• Strong understanding of end-to-end ingestion concepts including data contracts/specifications, refresh cadence, incremental vs full loads, controlled reprocessing, reconciliation, and traceable lineage.
• Ability to design/execute automated QC/validation checks and reconciliation routines to ensure datasets are review-ready.
• Hands-on experience with CSV, JSON, XML and API-based integrations; familiarity with secure transfer patterns (e.g., SFTP).
• Strong SQL skills; working proficiency in Python (preferred) or similar scripting to automate ingestion, QC, parsing, and operational tasks.

Responsibilities

• Ingest clinical data from EDC/CTMS and vendors into Veeva CDB/Elluminate/JReview per specifications and refresh cadence.
• Execute and support file/API loads, including mapping, transformations, referential integrity, and controlled reprocessing.
• Apply ingestion best practices: standardization, automated QC/validation, reconciliation, auditability/lineage, and incremental loads.
• Build and maintain a reusable ingestion framework and standards to accelerate onboarding and improve consistency.
• Operate transfer monitoring and ingestion operations: expected vs received, timeliness/completeness checks, alerting/escalation, scheduling/re-runs, defect triage, and KPI/SLA tracking.
• Ensure datasets are review-ready and manage downstream exports to internal consumers with clear data contracts and refresh expectations.
• Partner with vendors and stakeholders to define/maintain transfer specs and acceptance criteria; provide SME troubleshooting and document fixes for repeatable operations.
• Follow controlled documentation and change practices for regulated clinical processes, maintaining validation/traceability evidence and audit-ready records as required.

Skills

SQL

Python

ETL/ELT

Data ingestion

Data quality

Monitoring

Vendor coordination

Education

BS/BA (or equivalent)

Tools

Veeva CDB

Elluminate

JReview

Job description

• Objective / Purpose: The Clinical Data Ingestion Senior Manager FSP is responsible for ingesting, validating, and operationalizing clinical data feeds into clinical data review platforms (e.g., Veeva CDB, Elluminate, JReview) to enable efficient, high-quality clinical data review. This role focuses on strong ingestion principles, building and scaling reusable ingestion frameworks, and establishing monitoring and controls for vendor transfers and enterprise sources (e.g., EDC, CTMS) as well as managing downstream exports to enable analytics and programming teams.Accountabilities: Ingest clinical data from EDC/CTMS and vendors (e.g., labs, eCOA, imaging, safety) into Veeva CDB/Elluminate/JReview per specifications and refresh cadence.


• Execute and support file/API loads, including mapping, transformations, referential integrity, and controlled reprocessing.


• Apply ingestion best practices: standardization, automated QC/validation, reconciliation, auditability/lineage, and incremental loads.


• Build and maintain a reusable ingestion framework and standards (templates, metadata-driven mappings, reusable QC rules, runbooks) to accelerate onboarding and improve consistency.


• Operate transfer monitoring and ingestion operations: expected vs received, timeliness/completeness checks, alerting/escalation, scheduling/re-runs, defect triage, and KPI/SLA tracking.


• Ensure datasets are review-ready and manage downstream exports to internal consumers with clear data contracts and refresh expectations.


• Partner with vendors and stakeholders to define/maintain transfer specs and acceptance criteria; provide SME troubleshooting and document fixes for repeatable operations.


• Follow controlled documentation and change practices for regulated clinical processes, maintaining validation/traceability evidence and audit-ready records as required.

Education & Competencies (Technical and Behavioral):

Education/Experience: BS/BA (or equivalent) plus 7+ years in data ingestion/integration, ETL/ELT operations, or clinical data pipeline support, ideally supporting clinical data review and recurring study/vendor transfers.

• Preferred platform exposure: Experience ingesting data into Veeva CDB, Elluminate, and/or JReview (or comparable clinical data review systems).


• Clinical data ingestion principles: Strong understanding of end-to-end ingestion concepts including data contracts/specifications, refresh cadence, incremental vs full loads, controlled reprocessing, reconciliation, and traceable lineage.


• Data quality & Review readiness: Ability to design/execute automated QC/validation checks, completeness/timeliness verification, and reconciliation routines to ensure datasets are review-ready.


• Data formats & Interfaces: Hands-on experience with CSV, JSON, XML and file-based and/or API based integrations; familiarity with secure transfer patterns (e.g., SFTP/managed file transfer concepts). Querying & Scripting: Strong SQL skills; working proficiency in Python (preferred) or similar scripting to automate ingestion, QC, parsing, and operational tasks.


• Frameworks & reusability: Demonstrated ability to build or extend reusable ingestion components (metadata-driven mappings, templates, reusable QC rules, standard runbooks).


• Monitoring & Operations: Experience building/using monitoring for transfers and pipelines (e.g., expected vs received, timeliness/completeness checks, alerting, incident triage, reruns, KPI/SLA reporting).

Domain / Business Competencies

• Source system familiarity: Working knowledge of common clinical sources such as EDC, CTMS, and vendor domains (e.g., labs, eCOA/ePRO, imaging, safety) and how those feeds typically arrive and change over time.


• Downstream enablement: Understanding of downstream consumption needs (data review workflows, exports to CDM/analytics/programming) and ability to support stable, well-documented exports.

Compliance & Documentation

• Controlled processes mindset: Strong documentation discipline (specs, mappings, runbooks, issue logs) and comfort operating in controlled/regulated environments.


• Preferred: Exposure to GxP/CSV expectations, change control, and maintaining audit-ready operational evidence (as applicable to the organization/process).

Working Style

• Strong cross-functional communication and stakeholder management (vendors, CDM, data review, IT, analytics/programming).


• Detail-oriented, highly organized, Strong collaboration and communication; organized, self-directed, proactive problem-solver and able to manage recurring operational workloads while driving issues to closure and preventing recurrence.