Jobs · Information Technology · North Carolina

Senior Bioinformatics Data Engineer (Consultant)

ProPharma · Raleigh, NC · 1 wk ago
Information TechnologyFull-time

Key Responsibilities

  • Build and maintain Dagster-orchestrated ingestion pipelines for genomics vendors (Caris, Predicine, Tempus, Olink, CellCarta), including IO managers, Iceberg writers, and row-level accounting.
  • Develop and harden dbt Silver-to-Gold transformations: real-data test coverage, store-failures patterns, staging/intermediate/mart models, and macro consolidation.
  • Implement clinical data ingestion paths (SDTM and ADaM), reconciliation logic, and subject-dimension routing.
  • Deliver platform infrastructure: FastAPI endpoints, CI/CD pipelines, containerized deployments, observability instrumentation, and Redshift performance tuning.
  • Extract transformation rules from legacy R and PySpark code and reconcile against new platform implementations.
  • Identify repetitive processes and convert them into automated workflows, guardrails, or reusable tooling.
  • Participate in adversarial design and code reviews, identifying edge cases and pushing back on suboptimal patterns.
  • Collaborate with the lead engineer on design decisions and jointly own delivery velocity through paired working sessions and PR reviews.
  • Ensure all work meets reproducibility standards: CI on every PR, automated tests, no ad-hoc notebook-based production processes.

Minimum Qualifications

  • AI-native engineering practice: demonstrated experience building systems and workflows around AI coding agents (Claude Code, Cursor, Codex, or equivalent) - not just prompting them.
  • You recognize when a repeated process should become an automated pipeline, when agent output needs guardrails, and when to build infrastructure that makes future work faster.
  • Surface-level tool usage is insufficient.
  • Education: Bachelor's or master's degree in computer science, Data Engineering, Bioinformatics, or related field.
  • Experience: 5+ years of professional experience in data engineering with shipped production pipelines on AWS (S3, ECS/Fargate, Redshift or equivalent MPP).
  • Strong proficiency in Python and SQL with working knowledge of modern data engineering libraries.
  • Advanced proficiency with dbt and a workflow orchestration tool (Dagster, Airflow, or Prefect).
  • Data quality instinct: track record of catching silent failures, questioning data correctness assumptions, and noticing lossy joins or incomplete deliveries.
  • Solid understanding of lakehouse architecture patterns, ETL processes, and schema design for complex multi-modal datasets.
  • Ability to handle PHI-adjacent clinical data under Incyte's contractor policy (background check, compliance training, VPN access).
  • Willingness to work within legacy codebases (R, PySpark) to extract business rules and validate new implementations.
  • Excellent communication skills and ability to work in an embedded pair model with tight feedback loops.

Preferred Qualifications

  • Direct experience with Apache Iceberg, AWS Glue Catalog, or lakehouse table formats.
  • Comfort reading genomic data (VAF, HGVS nomenclature, VCFs, CNV/fusion semantics) or demonstrated ability to ramp on unfamiliar scientific domains quickly.
  • Familiarity with clinical data standards including SDTM, ADaM, and CDISC.
  • Pharma, clinical research, or life sciences background.
  • Experience with containerization (Docker/ECS) and infrastructure-as-code (CloudFormation).
  • Proficiency in R for interoperability with bioinformatics teams.

Similar jobs