Data Engineer / Senior Data Engineer, Digital & Innovation

Who is USP?

The U.S. Pharmacopeial Convention (USP) is an independent scientific organization that collaborates with the world's top authorities 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,300 hard-working professionals across twenty global locations to deliver the mission to strengthen the supply of safe, quality medicines and supplements worldwide.

At USP, we value inclusivity for all. We recognize the importance of building an organizational culture with meaningful opportunities for mentorship and professional growth. From the standards we create, the partnerships we build, and the conversations we foster, we affirm the value of Diversity, Equity, Inclusion, and Belonging in building a world where everyone can be confident of quality in health and healthcare.

USP is proud to be an equal employment opportunity employer (EEOE) and affirmative action employer. We are committed to creating an inclusive environment in all aspects of our work—an environment where every employee feels fully empowered and valued irrespective of, but not limited to, race, ethnicity, physical and mental abilities, education, religion, gender identity, and expression, life experience, sexual orientation, country of origin, regional differences, work experience, and family status. We are committed to working with and providing reasonable accommodation to individuals with disabilities.

Brief Job Overview

The Digital & Innovation group at USP is seeking a Data Engineer with skills in Data Modelling, Data Transformation to be able to build innovative Data Products. We are seeking someone who understands the power of data and enjoys communicating the insights and help create an unified experience across our ecosystem.

How will YOU create impact here at USP?

In this role at USP, you contribute to USP's public health mission of increasing equitable access to high-quality, safe medicine and improving global health through public standards and related programs. In addition, as part of our commitment to our employees, Global, People, and Culture, in partnership with the Equity Office, regularly invests in the professional development of all people managers. This includes training in inclusive management styles and other competencies necessary to ensure engaged and productive work environments.

• Use data collection and storing techniques to manage and cascade data in a scalable environment.
• Constantly review and upgrade the systems on data governance principles and data quality rules.
• Derive meaningful insights using analytical tools like Tableau, Looker, Power BI for making relevant business decisions.
• Use ML models designed by data scientists to capture AI usecases and deliver AI based programs with high quality.

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:

Education:

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

Experience:

 Data Engineer: Minimum 3-6 years of experience with big data technologies like Azure Data Lake, Synapse, PySpark, Azure Data Factory (ADF), AWS Redshift , S3, SQL Server ,MLOps or their equivalent.

Senior Data Engineer:  Minimum 6-8 years of experience with big data technologies like Azure Data Lake, Synapse, PySpark, Azure Data Factory (ADF), AWS Redshift , S3, SQL Server ,MLOps or their equivalent.

 Experience in implementing complex ETL pipelines day-to-day operations.

• Experience in Agile Development and code deployment and CI-CD pipelines.
• Experience in job orchestration using Airflow or equivalent.
• Experience in AI/ML, specially Gen AI concepts on Rag patterns, chunking techniques.
• Exposure on knowledge graphs is a plus.
• Build, Design and Deliver enterprise data programs.
• Proficiency in implementing data quality rules.
• Proficiency in analytical tools like Tableau, Power BI or equivalent.
• Experience with security models and development on large data sets.
• Experience in data quality management tools.
• Work closely with different stakeholders: Business owners, users, product managers, program managers, architects, engineering managers & developers, etc. to translate business needs and product requirements to well-documented engineering solutions.
• Ensuring data quality and consistency: Ensure data quality and consistency across various sources.
• Strong working knowledge on Python.
• Designing and contributing to best practices: Design and contribute to best practices in Enterprise Data Warehouse (EDW) architecture.

Additional Desired Preferences

Desired preferences are to showcase any additional preferred levels of expertise to perform the role. Reminder: any items listed in this section are not requirements nor disqualifies for candidate consideration.

• 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 working with knowledge graphs
• Ability to explain complex technical issues to a non-technical audience
• Self-directed and able to handle multiple concurrent projects and prioritize tasks independently
• Able to make tough decisions when trade-offs are required to deliver results
• Strong communication skills required: Verbal, written, and interpersonal

Supervisory Responsibilities

No

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.