Job Details

Data Engineer

For the past 20 years, ProPharma has improved the health and wellness of patients by providing advice and expertise that empowers biotech, med device, and pharmaceutical organizations of all sizes to confidently advance scientific breakthroughs and introduce new therapies.ProPharma partners with its clients through an advise-build-operate model across the complete product lifecycle. With deep domain expertise in regulatory sciences, clinical research solutions, quality & compliance, pharmacovigilance, medical information, and R&D technology, ProPharma offers an end-to-end suite of fully customizable consulting solutions that de-risk and accelerate our partners' most high-profile drug and device programs.

We're looking for a hands-on Data Engineer to work with teams of engineers, designers, and product managers to build scalable, secure, and user-centric products in the clinical space. The role involves collaborating closely with stakeholders to define requirements, design robust architectures, and implement features that align with the product vision. This position offers the opportunity to work on cutting-edge technologies, contribute to strategic initiatives, and play a key part in shaping the future. This role is ideal for someone who pairs deep Python expertise with AWS-native engineering, understands AWS for Health, and has experience integrating Veeva Vault Clinical data.

What You'll Do

• Leverage your expertise across frontend, backend, databases to optimize our systems and build complex features as part of the team, by writing clean code, taking pride in your work and value simplicity, testing and productivity as part of your daily routine, always putting user experience first
• Take ownership of end-to-end feature development, making technical decisions that ensure our platforms are scalable, performant, and maintainable across the entire stack
• Support and debug critical production issues, and implement sophisticated solutions while carefully considering business impact
• Provide leadership mentorship to less experienced team members, helping establish best practices and guiding architectural decisions while fostering a collaborative learning environment
• Embrace new languages and frameworks, containers and cloud, and not be afraid to dig deep and learn new things all the time
• Collaborate with other teams, technical and business/product leadership to ensure best quality of the product that delights the users
• Establish data product patterns (ownership, versioning, schemas, discoverability, SLAs, contracts, and APIs)
• Clinical & Clinical Trial Data Engineering
• Ingest and transform clinical data formats: HL7 v2, FHIR (R4), CDA, DICOM, and payer/provider artifacts (claims/eligibility)
• Integrate clinical trial data and results from Veeva Vault Clinical and other CTMS/eTMF systems
• Normalize to standard terminologies (SNOMED CT, LOINC, RxNorm, ICD?10?CM, CPT, NDC) and/or OMOP CDM when applicable
• Build high-quality pipelines for EHR, claims, labs, imaging, registries, and trial endpoints
• Implement ingestion, transformation, and serving layers using AWS: S3, Glue, EMR/Spark, Lake Formation, Redshift, Athena, Lambda, Step Functions
• Expose products through Athena/Redshift schemas, FHIR APIs, and secure extracts; integrate with dbt models and catalog metadata
• Partner with Security/Compliance to align with HIPAA, HITRUST, SOC 2, and GxP requirements for clinical trial data

Qualifications

• 7+ years of data engineering experience with strong Python and AWS-native solutions
• Proven experience with clinical data (HL7 v2, FHIR R4, CDA, DICOM) and healthcare vocabularies
• Hands-on with AWS core data services and AWS for Health
• Experience with Veeva Vault Clinical and handling clinical trial results (e.g., endpoints, adverse events, protocol data)
• Strong grounding in security & compliance for PHI and clinical trial data (HIPAA, GxP)
• Experience with data product design, metadata/lineage, and governance

Preferred

• Familiarity with clinical trial standards (CDISC, SDTM, ADaM)
• Integration with CTMS/eTMF systems including Veeva
• Knowledge of regulatory submission workflows and data integrity principles

We celebrate our differences and strive to create a workplace where each person can be their authentic self. We are committed to diversity, equity, and inclusion. Employees are encouraged to unleash their innovative, collaborative, and entrepreneurial spirits. With a holistic approach as an Equal Opportunity Employer, we provide a safe space where all employees feel empowered to succeed.

All applications to roles at ProPharma are personally reviewed by a member of our recruitment team. We do not rely on AI screening tools to support our hiring process. You will always receive an outcome to your application so that you have an answer from us - whether you're successful or not.

***ProPharma Group does not accept unsolicited resumes from recruiters/third parties. Please, no phone calls or emails to anyone regarding this posting.