Associate Director, Pharmaceutical Data Engineer

Build modern pharmaceutical data foundations and automation to power end-to-end clinical and commercial supply chain decision-making.

• Design and implement modern data foundations by designing, building, and deploying scalable data pipelines
• Deliver data and analytics more effectively using innovation and technology solutions such as Databricks, Python, and Agentic AI
• Create WebApps for Proof-of-Concept solutions that can be industrialized later in the React Platform
• Streamline processes by reducing manual work through advanced automation and machine learning
• Advance the Data Strategy and support transition to future-ready systems and intelligent data architectures
• Engineer analytics-ready data foundations by designing, building, and optimizing pipelines and architectures using Databricks, Python, Dataverse, and advanced SQL
• Transform operational data from SAP, MES, LIMS, and other sources across drug substance and drug product manufacturing and supply operations into accessible, analytics-ready datasets
• Translate requirements between business and technology by gathering stakeholder needs and converting them into clear business requirements and precise technical specifications
• Collaborate with supply chain planners, quality teams, and manufacturing stakeholders across drug substance and drug product functions
• Develop agentic AI workflows and machine learning models to automate decision-making and generate proactive business insights
• Build and deploy user-friendly WebApps that support business operations, data entry, and interaction with underlying data models
• Manage code quality using modern development tools (VS Code) and AI coding assistants (Cline) with GitHub version control for scripts, applications, and data models
• Partner on systems architecture with data architects to support scalable, secure, and efficient data models for both analytical and transactional workloads
• Document and enable adoption by documenting processes, code, data models, and system architectures, and providing training and technical support as new technologies roll out

Requirements

• Strong expertise in Python and advanced SQL
• Deep, hands-on Databricks Lakehouse experience including Delta Lake and Unity Catalog for data governance
• Proven experience building custom data products and rapid-prototype front ends (Streamlit/React)
• Strong familiarity with SAP (or similar ERP/manufacturing systems) as a primary source for complex supply chain and manufacturing data
• Proven track record gathering complex requirements from non-technical stakeholders and translating them into actionable technical roadmaps
• Familiarity with or strong interest in Agentic Modeling, Large Language Models (LLMs), and integrating AI agents into workflows (for example, Copilot Studio)
• Proven Agile/Scrum experience using Jira Cloud and Confluence for multi-system technical documentation
• High comfort using VS Code and leveraging AI-assisted coding tools
• Strong GitHub experience for version control, pull requests (PRs), and CI/CD pipelines
• Strong analytical and problem-solving skills for complex data challenges
• Ability to build trust-based relationships across technical and non-technical stakeholders
• Excellent written and verbal communication skills for clear technical communication across global audiences
• Independent decision-making with a proactive approach to leading projects and delivering results

Technologies

• Python, SQL
• Databricks, Databricks Lakehouse architecture, Delta Lake, Unity Catalog
• Dataverse
• SAP, MES, LIMS
• VS Code, Cline, GitHub (PRs), CI/CD
• Streamlit, React, Copilot Studio
• Jira Cloud, Confluence
• Agentic AI, Agentic Modeling, Large Language Models (LLMs), machine learning
• React Platform, WebApps
• SAP (MM/PP/QM/SD modules)

Education & Experience

• M.S. in Computer Science, Data Science, Engineering, Supply Chain Management, Operations Research, or a closely-related field with at least 5 years of industrial, pharmaceutical, or relevant data engineering experience
• B.S. in Computer Science, Data Science, Engineering, Supply Chain Management, Operations Research, Management Information Systems (MIS), or a closely-related quantitative field with at least 7 years of industrial, pharmaceutical, or relevant data engineering experience

Benefits

• Medical, dental, vision healthcare and other insurance benefits (for employee and family)
• Retirement benefits, including 401(k)
• Paid holidays
• Vacation
• Compassionate and sick days
• Annual bonus and long-term incentive, if applicable

Preferred Domain Knowledge

• Familiarity with pharmaceutical drug substance or drug product supply chain operations, including process orders, batch genealogy, MRP/MPS planning, tech transfer, quality management, or global distribution
• Experience working with SAP (MM/PP/QM/SD modules) or related manufacturing execution systems (MES/LIMS) is a strong plus

• Location: West Point, PA (onsite), USA
• Work arrangement: Hybrid
• Salary: $129,000 - $203,100 per year
• Employee status: Regular
• Requisition ID: R424311
• Posting end date: 11/13/2026 (effective until 11:59:59PM on the day before)
• Flexible work arrangements: Hybrid
• Employee status: Regular
• Primary location: USA - Pennsylvania - West Point