The U.S. Pharmacopeial Convention (USP) Senior Data Engineer - Remote in Rockville, Maryland
Who is USP?
The U.S. Pharmacopeial Convention (USP) USP is an independent scientific organization that collaborates with the world's top experts 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,100 talented professionals across five global locations to deliver the mission to strengthen the supply of safe, quality medicines and supplements worldwide.
Brief Job Overview
Are you passionate about transforming data into valuable insights? Do you want to shape data infrastructure to help integrate new digital and informatics capabilities to an organization? The Informatics Pilots & Operations (IP&O) team at USP is looking an individual that thrives in a fast-paced, collaborative environment, with a deep understanding of data architecture, ETL/ELT processes, and performance optimization.
As a Senior Data Engineer, you will play a critical role in designing and maintaining the data infrastructure and pipeline of our data-driven initiatives. You will have the opportunity to take on a strategic role in prototyping and shaping sustainable solutions to handle complex data challenges.
In this role, you will not only contribute to the technical aspects of data engineering, but also have the opportunity to interact with other leaders within the organization. Your ability to communicate and influence effectively with cross-functional teams, and stay at the forefront of emerging data technologies will be instrumental in driving our data engineering capabilities forward.
The Informatics Pilots & Operations (IP&O) Department identifies, validates, and builds informatics and digital relevant capabilities such as AI that will enrich, or create new ways of working at USP and/or the products we provide to our stakeholders. IP&O does so through development of solution-oriented prototypes to inform scale-up decisions.
How will YOU create impact here at USP?
Data Architecture and Infrastructure:
Design, prototype, and recommend scalable and robust data infrastructure that supports data ingestion, storage, processing, and retrieval.
Evaluate and select appropriate technologies, tools, and frameworks to enhance the data engineering capabilities.
Collaborate with data stewards and business users to integrate data governance practices and standards.
Data Integration and ETL/ELT:
Develop and maintain efficient and scalable data pipelines and ETL/ELT processes to acquire and transform data from various sources into usable formats.
Ensure the consistency, accuracy, and quality of data throughout the ETL/ELT process.
Monitor and troubleshoot data integration processes to identify and resolve issues and bottlenecks.
Identify and implement strategies to optimize data processing and storage performance, including partitioning, indexing, and caching techniques.
Collaborate with infrastructure teams to ensure scalability and reliability of data systems.
Conduct performance tuning and optimization of SQL queries and data processing jobs.
Collaboration and Leadership:
Collaborate and communicate effectively with cross-functional teams, including data scientists, analysts, software engineers, and business stakeholders, to experiment and understand data requirements and deliver effective data solutions.
Stay updated with emerging trends and technologies in the data engineering field and make recommendations for adoption.
Perform other duties as assigned.
Who USP is 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, Information Systems, or a related field.
5+ years of experience in data engineering or a similar role.
Strong proficiency in programming languages including Python, and willingness to learn additional languages.
Deep understanding of relational and non-relational databases, data modeling, and SQL.
Experience with big data technologies and frameworks such as Hadoop, Spark, or Kafka.
Proficiency in data integration and ETL/ELT tools like Apache Airflow or Informatica.
Experience with cloud-based data platforms such as AWS, GCP, or Azure.
Familiarity with data governance principles and data quality frameworks.
Strong problem-solving and troubleshooting skills.
Excellent communication and collaboration abilities, including ability to explain highly technical or complex issues to a non-technical audience.
Comfortable with task ambiguity and change.
Demonstrated ability to implement tasks independently and efficiently.
Additional Desired Preferences
Ability to write code in Scala, Java, or R.
Data visualization skills.
Familiarity with knowledge graph/graph database and AI capabilities including NLP, deep learning, and/or other AI models and systems.
Technical Master’s degree.
USP provides you with the benefits you need to protect yourself and your family today and tomorrow. From company-paid time off, comprehensive healthcare options to retirement savings, you can have peace of mind that your personal and financial wellbeing is protected.
COVID-19 Vaccination Policy (will apply to the selected candidate(s) hired):
As a condition of employment with the United States Pharmacopeial Convention's (USP) duty to provide and maintain a workplace free of known hazards, all employees and contingent staff hired after July 1st, 2021, must be fully vaccinated unless a reasonable accommodation is approved. Your recruiter will advise accordingly.
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—from the standards we make to the partnerships and conversations we cultivate. An environment where every employee feels fully empowered and valued irrespective of, but not limited to, personality, 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.
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.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)
Job Category Information Technology
Job Type Full-Time