Manufacturing and Operational Excellence Data Analyst (Contract)

Atrium Works • Boston, MA

3d • Onsite

About The Position

This role is a Technical Operational Excellence (OpEx) Data Analyst for Vertex Pharmaceutical's Manufacturing Center. It is a 12-month contract W2 role and requires onsite presence.

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.

Nice To Haves

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

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, quarriable 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.
• Support daily check-in facilitation (maintain tracker, flag blockers, draft status summaries).
• Ad-hoc data pulls, analysis and project update requests.
• Build a small library of reusable slide layouts for recurring reporting formats.
• 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, flags regressions, and shows 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).
• 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.

Benefits

• Compensation, medical benefits, fringe benefits and other terms and conditions of employment shall be presented by the third-party agency partner upon offer.
• Eligible for overtime pay, in accordance with federal and state requirements.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed