Team Lead Data Engineer

Who is USP

The U.S. Pharmacopeial Convention (USP) is an independent scientific organization that collaborates with the worlds top authorities in health and science to develop quality standards for medicines dietary supplements and food ingredients. USPs fundamental belief that Equity Excellence manifests in our core value of Passion for Quality through our more than 1300 hardworking 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 workan 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 endusers 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 nontechnical 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 highquality medicines through public standards and related programs. USP prioritizes scientific integrity regulatory excellence and evidencebased decisionmaking to ensure
health systems worldwide can rely on strong tested and globally relevant quality standards. Additionally USPs 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 highperforming inclusive teams. This includes training in equitable management practices and tools to promote engaged collaborative and resultsdriven 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 datarelated 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 nontechnical audiences.
Collaborate with data scientists analysts and other teams to support datadriven 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:
Bachelors or Masters 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 nontechnical audiences.
Experience in gathering and documenting user requirements. Strong problemsolving 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 companypaid time off and comprehensive healthcare options to retirement savings you can have peace of mind that your personal and financial wellbeing is protected.

Compensation
Base Salary Range: USD $131500.00 $170500.00 annually.
Target Annual Bonus: Varies based on level of role.
Individual compensation packages are based on various factors unique to each candidates skill set experience qualifications equity and other jobrelated 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.