Data Engineer

Description

The U.S. Pharmacopeial Convention (USP) is an independent scientific organization that collaborates with the world’s leading health and science experts to develop rigorous quality standards for medicines, dietary supplements, and food ingredients. At USP, we believe that scientific excellence is driven by a commitment to fairness, integrity, and global collaboration. This belief is embedded in our core value of Passion for Quality and is demonstrated through the contributions of more than 1,300 professionals across twenty global locations, working to strengthen the supply of safe, high-quality medicines worldwide.

At USP, we value inclusive scientific collaboration and recognize that attracting diverse expertise strengthens our ability to develop trusted public health standards. We foster an organizational culture that supports equitable access to mentorship, professional development, and leadership opportunities. Our partnerships, standards, and research reflect our belief that ensuring broad participation in scientific leadership results in stronger, more impactful outcomes for global health.

USP is proud to be an equal employment opportunity employer (EEOE) and is committed to ensuring fair, merit-based selection processes that enable the best scientific minds—regardless of background—to contribute to advancing public health solutions worldwide. We provide reasonable accommodations to individuals with disabilities and uphold policies that create an inclusive and collaborative work environment.

Brief Job Overview

The Data Engineer position is a hands-on non-supervisory role within the Data Strategy & Analytics team. The position is an individual contributor role that will serve a critical function by designing, building, and executing efficient and governed data pipelines. This role is integral to transitioning our development of data assets into production environments. The data engineer will collaborate with the data strategy program manager and data scientists by establishing robust data processing practices and tools in support of a data science capability. The position requires some time overlap for meetings with team members based in other time zones, primarily Eastern Standard Time (EST).

How will YOU create impact here at USP?

As part of our mission to advance scientific rigor and public health standards, you will play a vital role in increasing global access to high-quality medicines through public standards and related programs. USP prioritizes scientific integrity, regulatory excellence, and evidence-based decision-making to ensure health systems worldwide can rely on strong, tested, and globally relevant quality standards.

Additionally, USP’s People and Culture division, in partnership with the Equity Office, invests in leadership and workforce development to equip all employees with the skills to create high-performing, inclusive teams. This includes training in equitable management practices and tools to promote engaged, collaborative, and results-driven work environments.

The Data Engineer has the following responsibilities:

• Design, build, and implement data pipelines to support advanced use cases for product grade data science products
• Manage data ingestion, processing and production process as well as manage tools and platforms
• Integrate external datasets with USP data
• Interface with internal and external teams of data scientists and data engineers on process development
• Collaborate with IT to integrate data warehouse, analytics applications, and data science platforms
• Support transition to agile approaches for data asset development and deployment
• Support transition to a SDLC approach to data asset and data science product development and deployment

Who is USP 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:

• Bachelor’s Degree in Computer Science, Engineering, Mathematics, or related technical area
• Minimum 3 years of data engineering specific experience designing, building, and supporting data pipelines
• Experience in at least one modern relational database
• Strong core SQL development experience and writing efficient SQL
• Very strong development ability in Python including experience working with pandas, numpy, scikit-learn, selenium, beautifulsoup, and regex
• Hands-on experience with ETL/ELT tools and concepts
• Strong communication and collaboration skills with strength in working in teams
• Strong problem solving and time management skills
• Very strong learning agility- ability to pick up new tools and capabilities quickly

Additional Desired Preferences

• Experience with SDLC and Agile work environments
• Experience working in cloud platforms (AWS, Azure, Google Cloud Platform, etc.)
• Proven ability to clearly define priorities and focus on delivering work products
• Ability to handle multiple priorities and complex projects in a fast-paced environment.
• Substantial experience with Git for version control
• Core data modeling ability
• Ability to derive data modeling decisions and data engineering strategy to meet data strategy objectives
• Direct experience supporting Data Science teams in moving from development to production environments
• Prior experience in a scientific based industry or related content area a plus (pharma, life sciences, public health, research, etc.)
• Experience with Apache Spark and/or pySpark
• Experience working in cloud platforms (AWS, Azure, Google Cloud Platform, etc.)
• Experience with Continuous Integration and Continuous Delivery (Deployment) software development approach

Supervisory Responsibilities

None, this is an individual contributor role.

Benefits

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

Note: USP does not accept unsolicited resumes from 3rd party recruitment agencies and is not responsible for fees from recruiters or other agencies except under specific written agreement with USP.