CMC Inventory Centralization Intern

POSITION OVERVIEW:

We are seeking a highly organized intern for a 6–8-week project to design and implement a centralized inventory tracking system across:

• Cell Line Development (cell banks, intermediates)
• Drug Substance (DS)
• Drug Product (DP)
• Clinical trial materials

This role will focus on improving visibility, traceability, and data consistency across material types that are currently tracked in multiple systems or formats.

Primary Project Objective

Build a centralized, structured inventory tracker (e.g., Excel or compatible system) that integrates DS, DP, cell line, and clinical inventory into a single source of truth.

RESPONSIBILITIES:

Inventory Mapping & Data Consolidation

• Collect and review existing inventory datasets (spreadsheets, systems, logs)
• Map material categories, attributes, and identifiers across:
• Cell banks and development materials
• DS and DP batches
• Clinical supplies
• Identify gaps, inconsistencies, and duplicate records

Tracker Development

• Design and build a centralized inventory tracker, including:
• Standardized fields (material ID, lot/batch, location, status, expiry, owner)
• Clear categorization across DS, DP, cell line, and clinical materials
• Version control and data integrity structure
• Ensure usability by cross-functional stakeholders

Data Entry & Reconciliation

• Populate tracker with validated inventory data
• Perform reconciliation between source data and compiled tracker
• Highlight discrepancies and risks (e.g., missing data, expired materials)

Process & Documentation

• Document tracker structure and definitions
• Propose a standard process for ongoing inventory updates
• Recommend improvements for long-term scalability

Production Planning

• Export data from different modules of a planning tool (N-Side Lighthouse) into Excel to create charts that present overlapping data sets.

 REQUIREMENTS:

• Currently enrolled in or recently graduated from a Bachelor's or Master's degree program in Life Sciences, Biochemistry, Chemical Engineering, Supply Chain Management, Pharmaceutical Sciences, or related field
• Strong organizational skills with high attention to detail and accuracy in data entry
• Proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, basic data analysis)
• Ability to manage multiple tasks in a deadline-driven, fast-paced environment
• Strong written and verbal communication skills

What You Will Gain

• Real-world experience in a GMP-regulated pharmaceutical operations and supply chain supporting active drug development programs
• Exposure to both biologics and small molecule manufacturing operational landscapes via CDMO partnerships
• Mentorship from experienced CMC and supply chain professionals in the biotech industry