Team Lead, Data Engineer

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

We are seeking a highly motivated and experienced Team Lead Data Engineer to join our dynamic team. This role demands a strong technical foundation in AWS data services, coupled with exceptional communication and collaboration skills, and experience in integrating data for use in Microsoft Power BI. You will be responsible for designing, building, and maintaining scalable data pipelines and infrastructure on AWS, while also acting as a key liaison between technical teams and end-users, and ensuring data is readily available and optimized for Power BI reporting and analytics. Your ability to translate complex technical concepts into clear, actionable insights for non-technical stakeholders is crucial.

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 Team Lead Data Engineer has the following responsibilities:

• Design, develop, and implement robust data pipelines and data warehousing solutions using
AWS services (e.g., Redshift, Glue, S3, Lambda, EMR, Kinesis).
• Optimize data storage, retrieval, and processing for performance and scalability.
• Manage and maintain AWS data infrastructure, ensuring high availability and reliability.
• Develop and maintain ETL/ELT processes to ingest, transform, and load data from diverse
sources, with a focus on preparing data for Power BI consumption.
• Implement data quality checks and monitoring to ensure data accuracy and consistency.
• Automate data pipeline processes for efficiency and reliability.
• Act as a primary point of contact for data-related inquiries from business users and stakeholders,
including those using Power BI.
• Gather and analyze user requirements, translating them into technical specifications, and also
understand the requirements of data needed for effective Power BI dashboards.
• Clearly communicate technical concepts and solutions to non-technical audiences.
• Collaborate with data scientists, analysts, and other teams to support data-driven initiatives.
• Create and maintain documentation for data pipelines and data infrastructure, geared toward both
technical and non technical audiences, and also include documentation on how data is structured
for Power BI.
• Design and implement data models that support analytical and operational needs, and also
optimize data models for Power BI performance.
• Contribute to the development of data architecture and best practices.
• Implement and maintain data security measures within the A