Senior Data Engineer

About USP 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. USP believes 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. Job Overview We are seeking a high‑energy, hands‑on Data Engineer to design, build, and maintain scalable, production‑grade data pipelines across our AWS‑based data platform. This role will own end‑to‑end pipeline delivery—from enterprise system ingestion to creating analytics‑ready datasets—while working closely with Data Architects, Analytics teams, and business stakeholders. You will help evolve our AWS Lakehouse architecture and shape best practices. Impact 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. Our People and Culture division, in partnership with the Equity Office, invests in training to equip employees with skills that create high‑performing, inclusive teams. Responsibilities Data Pipeline Development: Design, develop, and maintain scalable ELT pipelines with reusable ingestion frameworks supporting batch and event‑driven workflows across diverse sources including ERPs, APIs, vendor files, and relational databases. AWS Cloud Data Engineering: Build and optimize AWS‑native data pipelines implementing a Medallion Lakehouse architecture with a focus on performance and cost efficiency. Infrastructure, CI/CD & DevOps: Provision and manage AWS infrastructure via Terraform, maintaining CI/CD pipelines with GitOps practices, automated testing, logging, alerting, and recovery mechanisms for production systems. Data Modeling & Transformation: Design and implement dimensional models, Gold‑layer datasets, and scalable vendor file ingestion patterns using SQL, Python, and PySpark, with robust handling of schema drift, audit tracking, and query optimization through partitioning, clustering, and materialization strategies. Data Quality & Governance: Implement automated data validation, anomaly detection, and lineage tracking within pipelines while supporting metadata management. Reporting & Power BI Support: Troubleshoot and resolve complex data issues while ensuring pipelines deliver data in formats optimized for Power BI; collaborate with Power BI developers to align data structures with reporting requirements and resolve dashboard‑related data issues. Collaboration & Continuous Improvement: Partner with Architects and Analytics teams to translate business needs into technical solutions, actively contributing to code reviews, architecture discussions, sprint planning, and more. Qualifications Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent combination of education and experience. Minimum 7+ years of data engineering experience, with strong expertise in AWS services and hands‑on work with big data and distributed data technologies in the AWS cloud environment. Strong proficiency in Python and SQL with experience in PySpark/Spark. Hands‑on experience building and operating data pipelines on AWS (Glue, Step Functions, Lambda, S3, Athena, SNS, SQS, Redshift, etc.). Demonstrated experience with event‑driven pipeline architectures. Experience ingesting and processing vendor‑supplied data files on a large scale. Practical experience implementing Medallion (Bronze/Silver/Gold) architecture in a data lake or Lakehouse environment. Experience with Terraform for cloud infrastructure provisioning. Experience with CI/CD tooling (e.g., Bitbucket, GitHub, AWS CodePipeline) for data pipeline deployments. Strong grasp of data warehousing concepts (star schema, dimensional modeling, SCD). Experience integrating data with Microsoft Power BI or similar BI tools. Experience with UNIX/Linux including basic commands and shell scripting. Production experience with monitoring, troubleshooting, and on‑call support for data pipelines. Experience with Agile engineering practices. Desired Preferences Hands‑on integration experience with Oracle EBS as a data source. Experience with data quality frameworks (e.g., Great Expectations, dbt tests). Experience with AWS CDK or CloudFormation in addition to Terraform. Knowledge of data catalog and data lineage tools (e.g., Alation, Collibra). AWS certifications (e.g., AWS Certified Data Engineer, AWS Certified Solutions Architect). Supervisory Responsibilities None, this is an individual contributor role. Benefits USP provides company‑paid time off, comprehensive health care options, and retirement savings plans to protect you and your family. We offer a supportive, inclusive work environment with mentorship, professional development, and career advancement opportunities. Compensation Base Salary Range: USD $112,700.00 – $146,900.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. Equal Opportunity USP is 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 public health solutions worldwide. We provide reasonable accommodations for individuals with disabilities and uphold inclusive policies. For further information, please review the Know Your Rights notice from the Department of Labor ( Job Category: Information Technology Job Type: Full‑Time #J-18808-Ljbffr BioSpace