Manufacturing and Operational Excellence Data Analyst

12-month contract W2 role; onsite required.

Responsibilities

• Own the data pull and visual assembly for recurring reporting (e.g., project updates).
• Maintain project tracking and status synthesis for daily check-ins and leadership updates.
• Serve as first responder on ad-hoc data and analysis requests from stakeholders.
• Design and build a standardized value stream data architecture with reusable schema definitions.
• Consolidate historical Value Stream Analysis (VSA) work into a single, queryable baseline dataset.
• Build a standard benefits logic library, ROI calculator, and integrated Value Register that ties baseline to intervention to measured outcome.
• Build standard benefits logic library defining calculations for time savings, throughput improvement, cycle time reduction, rework reduction, and cost avoidance.
• Develop ROI calculator tool enabling consistent, defensible benefit quantification.
• Create integrated OpEx Value Register linking baseline → intervention → measured outcome → dollar value with supporting evidence.

Deliverables

Operational Support

• Support daily check-in facilitation (maintain tracker, flag blockers, draft status summaries).
• Ad-hoc data pulls, analysis, and project update requests.
• (Optional) Build a small library of reusable slide layouts for recurring reporting formats.

Value Stream Data Architecture + Benefits Framework

• Standardized value stream baseline schema with canonical definitions for cycle time, queue time, rework loops, gate timestamps, resource allocation, and yield.
• Consolidated historical VSA dataset in standardized schema forming a single, comparable dataset across programs and time periods.
• Build Power BI monitoring dashboards to track TAT trends, flag regressions, and show before/after for active improvement initiatives.
• Documented standard benefits logic with locked assumptions for each benefit type we commonly claim (time savings, throughput improvement, cycle time reduction, rework reduction, cost avoidance).
• Build a lightweight ROI calculator (one tool, select benefit type, plug in values, get a defensible number).

Integrated Value System

• Build the OpEx Value Register: single source of truth logging every initiative with baseline, intervention, measured outcome, benefit type, calculated ROI, and linked evidence.
• Integrate the Value Register with the VSA dataset (shared identifiers, traceable chain from value stream state to intervention to outcome to dollar value).
• Scenario modeling capability using baseline dataset (e.g., "if we cut queue time at Gate X by 20%, what's the expected TAT impact?").
• Establish a repeatable workflow for exec-ready value stories that pulls from the Register and VSA data rather than rebuilding from scratch.

Requirements

• Pharma/biotech manufacturing familiarity (GxP context, tech transfer, batch records).
• Python (data manipulation, visualization, API integration), SQL fluency.
• Experience with lean six sigma and value stream analysis.
• Strong communication skills for value story development.

Preferred Skills

• Experience building slide automation or templated reporting (Power Automate, python-pptx, or similar).
• Power BI dashboard development.
• Snowflake data platform experience.

Pay

$80/HR - $85/HR