Senior Data Engineer

Xenon7 • Columbus, OH

1d • Hybrid

About The Position

We are seeking a Senior Data Engineer with extensive experience in data architecture and platform engineering to drive data initiatives for a top-tier life sciences client. This role sits at the critical intersection of scientific research informatics, clinical data systems, and manufacturing process engineering. In this position, you will own the architectural vision and hands-on execution of scalable data platforms and pipelines. You will bridge complex data domains—from small and large molecule research, genomics, and clinical trial datasets to active pharmaceutical ingredient (API) manufacturing processes, batch data, and industrial control systems. Operating in a 3-day onsite hybrid capacity in Indianapolis, you will collaborate directly with process engineers, clinical scientists, and platform teams to build high-performance data infrastructure that accelerates drug discovery and manufacturing operations.

Requirements

• Senior-level proficiency (10–20+ years) in software development, data platform architecture, and complex ETL/ELT engineering.
• Demonstrated ability to engineer data pipelines across non-standard, highly specialized domains (e.g., transition between process/chemical engineering data and clinical/scientific research informatics).
• Must hold unrestricted US Work Authorization (no sponsorship available) and be able to work 3 days per week onsite in the Indianapolis, IN area.
• Exceptional problem-solving mindset, strong adaptability, and the ability to articulate complex technical architecture to cross-functional engineering teams.
• Advanced Python, PySpark, and expert-level SQL.
• Hands-on expertise with Databricks, Snowflake, or AWS/Azure enterprise data ecosystems.
• Extensive experience with Airflow, dbt, Spark, and enterprise data orchestration engines.
• Proven track record building streaming and batch data architectures via REST APIs, message brokers, and database integrations.
• Deep exposure to either scientific/clinical informatics (CDISC/SDTM, LIMS, clinical trials, multi-omics) OR chemical/process engineering data (API manufacturing, batch data, SCADA, MES, OSIsoft PI).

Nice To Haves

• Academic background in Chemical Engineering, Bio-process Engineering, Computer Science, or a related STEM discipline.
• Direct experience working inside regulated GxP environments in the Life Sciences or Specialty Chemicals sectors.
• Certifications: Databricks Certified Data Engineer Senior/Professional, Snowflake SnowPro Core/Advanced, or AWS Data Engineer Associate/Professional.

Responsibilities

• Design, build, and maintain production-grade data pipelines and architecture tailored for scientific, clinical trial, and research informatics data (small/large molecule, genomics, proteomics, LIMS).
• Structure complex, multi-modal clinical and scientific datasets to enable advanced analytics, enterprise reporting, and downstream machine learning models.
• Ingest, harmonize, and model operational technology (OT) and manufacturing process datasets, including API manufacturing pipelines, batch processing data, MES, SCADA, and OSIsoft PI systems.
• Unify disparate laboratory and facility data pipelines into centralized, highly available enterprise data platforms.
• Build robust ETL/ELT pipelines using modern cloud platforms (Databricks, Snowflake, AWS/Azure), PySpark, and SQL.
• Ensure all data pipelines and platform integrations strictly adhere to enterprise governance, data residency, and GxP regulatory standards within a heavily monitored environment.
• Partner directly with process engineers, chemical engineering leads, and research informatics directors to translate operational friction into robust technical specifications.
• Establish engineering best practices, data modeling standards, and pipeline monitoring frameworks across the enterprise data stack.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed