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 AWS environment.
• Ensure compliance with data governance policies and regulations.
• Troubleshoot and resolve complex data related issues.
• Ensure data pipelines deliver data in a format suitable for Power BI analysis.
• Work with Power BI developers to understand data requirements and optimize data structures for
reporting.
• Troubleshoot data issues related to Power BI dashboards and reports.

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 or Master's degree in Computer Science, Engineering, or a related field.
• Minimum 5+ years of proven experience in data engineering, with a strong focus on AWS
services.
• Proven expertise in AWS data services (Redshift, Glue, S3, Lambda, EMR, Kinesis, etc.).
• Strong proficiency in SQL and Python.
• Experience integrating data with Microsoft Power BI.
• Excellent communication and presentation skills, with the ability to explain complex technical
concepts to non-technical audiences.
• Experience in gathering and documenting user requirements.                                                                                                                                                                                  • Strong problem-solving and analytical skills.
• Ability to work effectively in a collaborative environment.
• Experience in creating easily understood documentation.
• Experience with data modeling and data warehousing concepts.

Additional Desired Preferences

• AWS certifications (e.g., AWS Certified Data Analytics - Specialty).
• Experience with other data visualization tools.
• Experience with Power BI dataflows.
• Experience with DevOps practices and tools.
• Aptitude for identifying problems quickly and developing effective solutions.
• Ability to manage expectations and build relationships with various stakeholders.
• Ability to navigate and resolve conflicts within the team and with stakeholders.

Supervisory Responsibilities

Yes, one senior software engineer.

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.

Compensation
Base Salary Range: USD $131,500.00 – $170,500.00 annually.
Target Annual Bonus: % Varies based on level of role.
Individual compensation packages are based on various factors unique to each candidate’s skill set, experience, qualifications, equity, and other job-related reasons.
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.