Lead Data Engineer

BioSpace; Indiana; On-site; USD 110,000 - 150,000; Full time

Job summary

The U.S. Pharmacopeial Convention (USP) is seeking a Data Engineer to build scalable data pipelines and robust data infrastructure to support enterprise analytics and decision-making.

The role focuses on clean, accessible data and collaboration with data scientists, analysts, and stakeholders to derive actionable insights. You will drive data architecture, leverage cloud technologies, and ensure secure, cost-effective deployments while aligning with USP’s mission to protect patient safety

Qualifications

• Bachelor’s degree in a relevant field or equivalent experience.
• 7+ years of experience with big data technologies (Python, PySpark, SQL).
• Experience with AWS data services (Redshift, S3, Glue, Lambda, EventBridge).
• Proven ability to design and operate scalable data pipelines and data platforms.

Responsibilities

• Design and implement scalable data collection, storage, and processing pipelines to support enterprise-wide data needs.
• Implement and maintain data governance frameworks and data quality checks within data pipelines for reliability.
• Build and optimize data models and data marts to support self-service analytics and reporting tools such as Tableau, Looker, and Power BI.
• Partner with data scientists to operationalize models into production-grade pipelines.

Skills

Python

PySpark

SQL

Data modeling

ETL/ELT

Data governance

Airflow

Education

Bachelor’s degree in relevant field (Engineering/Analytics/Data Science/CS/Statistics)

Tools

AWS Redshift

S3

Glue

Lambda

EventBridge

Postgres

Neo4j

Tableau/Power BI

Airflow

Job description

Description

Who is USP?

The U.S. Pharmacopeial Convention (USP) USP is an independent scientific organization that collaborates with the world's top experts in health and science to develop quality standards for medicines, dietary supplements, and food ingredients. USP's fundamental belief that Equity = Excellence manifests in our core value of Passion for Quality through our more than 1,100 talented professionals across five global locations to deliver the mission to strengthen the supply of safe, quality medicines and supplements worldwide.

Brief Job Overview

The Digital product engineering team at USP is seeking a Data Engineer with expertise in building robust data pipelines, managing large-scale data infrastructure, and enabling advanced analytics capabilities. This role is critical to supporting projects that align with our mission to protect patient safety and improve the health of people around the world. We are looking for a professional who understands the value of clean, accessible, and well-organized data, and who enjoys designing systems that empower data scientists, analysts, and business stakeholders to derive actionable insights. The ideal candidate will be passionate about data architecture, cloud technologies, and scalable engineering solutions that drive innovation and impact.

How will YOU create impact here at USP?

• Design and implement scalable data collection, storage, and processing pipelines to support enterprise-wide data needs.
• Implement and maintain data governance frameworks and data quality checks within data pipelines to ensure compliance and reliability.
• Build and optimize data models and data marts to support self-service analytics and reporting tools such as Tableau, Looker, and Power BI
• Partner with data scientists to operationalize models by integrating them into production‑grade pipelines, ensuring scalability, performance, and maintainability.
• Collaborate with cross‑functional stakeholders (business, product, analytics, and engineering teams) to translate business requirements into scalable data solutions and prioritize data initiatives.
• Provide technical leadership and architectural guidance for data platform design, ensuring alignment with enterprise standards and long‑term data strategy.
• Lead design reviews, code reviews, and data architecture discussions to ensure best practices, reusability, and high‑quality deliverables.
• Collaborate with platform, DevOps, and security teams to ensure secure, cost‑effective, and scalable data infrastructure.
• Influence data roadmap and strategy by identifying opportunities for data platform enhancement, automation, and cost optimization.

Who USP is Looking For?

The Successful Candidate Will Have a Demonstrated Understanding Of Our Mission, Commitment To Excellence Through Inclusive And Equitable Behaviors And Practices, Ability To Quickly Build Credibility With Stakeholders, Along With The Following Competencies And Experience

Education

• Bachelor’s degree in relevant field (e.g. Engineering, Analytics or Data Science, Computer Science, Statistics) or equivalent experience.

Experience

• 7+ years of experience in big data technologies such as Python, PySpark, and SQL for processing structured, semi‑structured, and unstructured data.
• Strong experience with AWS data services including Redshift, S3, Glue, Lambda, EventBridge, Postgres, Neo4j (Azure/GCP equivalents such as ADLS, Synapse, ADF acceptable).
• Experience in building batch, micro‑batch, and streaming pipelines (real‑time / near real‑time) using Lambda/Kappa architectures.
• Hands‑on expertise in designing and delivering enterprise‑scale data platforms, including data lakehouse, data warehouse, data lake, and data marts.
• Strong understanding and hands‑on implementation of data modeling techniques including - Data Vault 2.0, Dimensional Modeling, Knowledge Graphs, One Big Table (OBT) approaches (Certification in at least one area preferred)
• Experience with medallion architecture and metadata‑driven data pipeline frameworks.
• Strong expertise in data governance frameworks, including- Data discovery, Data quality, Data security, Hands‑on experience with DQ tools such as Great Expectations, Pydantic, etc.
• Strong SQL and programming skills for data transformation, modeling, and analysis.
• Hands‑on experience in building and maintaining complex ETL/ELT pipelines and managing day‑to‑day data operations.
• Experience with workflow orchestration tools such as Airflow (2+ years or equivalent).
• Knowledge of streaming/event‑driven architectures and modern data processing patterns.
• Good understanding of dashboarding and visualization techniques with tools like Tableau, Power BI, or equivalent.
• Experience with Agile (SAFe) methodologies, CI/CD pipelines, and modern deployment practices for data platforms.
• Exposure to AI/ML concepts, with familiarity in Generative AI patterns (e.g., RAG, chunking techniques) as an added advantage.

Additional Desired Preferences

• Experience with scientific chemistry nomenclature or prior work experience in life sciences, chemistry, or hard sciences or degree in sciences
• Experience with pharmaceutical datasets and nomenclature
• Experience in developing Machine learning & Deep learning models; Familiarity with MLOps and deploying ML models in production environments.
• Ability to explain complex technical issues to a non‑technical audience

Supervisory Responsibilities

No

Benefits

USP provides you with the benefits you need to protect yourself and your family today and tomorrow. From company‑paid time off, comprehensive healthcare options to retirement savings, you can have peace of mind that your personal and financial wellbeing is protected.

Job Category Information Technology

Job Type Full-Time