Project briefs · Health & Life Sciences

AstraZeneca · Summer 2027

Undergraduate Summer Intern (Frederick, MD): a project built for this posting

A paid 10-week program at AstraZeneca's Frederick biologics manufacturing site, with intern placements across several site functions. Interns must start on 7 June 2027 and graduate after August 2027.

Company
AstraZeneca
Posting title
Undergraduate Summer Internships in Frederick, MD
Location
Frederick, MD
Season
Summer 2027

Checked open on the employer's careers site on 2026-10-21. Read the full posting ↗

What this role is really testing

Data analysis and visualization for process improvementRoot cause analysis and continuous improvement (CI) thinkingClear technical communication to non-specialist audiencesUnderstanding of manufacturing operations metrics (OEE, cycle time, downtime)Structured problem-solving using frameworks like DMAIC or fishbonePresenting findings to site leadership in a professional formatCross-functional collaboration and project scoping

The project

Manufacturing Downtime Pareto Analysis Dashboard

A one-page Excel or Google Sheets dashboard that ingests a sample manufacturing downtime dataset, performs a Pareto analysis to surface the top causes of lost production time, and presents findings with charts and a one-slide executive summary, exactly the kind of data-driven CI deliverable interns produce and present to site leadership at Frederick. This maps directly to the Manufacturing Operations track's emphasis on analyzing data inputs to drive improvements and supporting continuous improvement initiatives.

  1. Create or download a realistic sample dataset (30–50 rows) with columns: Date, Equipment ID, Downtime Category (e.g., mechanical failure, changeover, scheduled maintenance, operator error, material shortage), and Minutes Lost, populate it with plausible variation so no single category dominates trivially, then load it into Excel or Google Sheets.
  2. Build three linked views on a second sheet: (1) a pivot table that sums Minutes Lost by Downtime Category and calculates each category's percentage of total downtime, (2) a Pareto bar-and-line combo chart showing categories ranked highest to lowest with a cumulative-percentage line, and (3) a secondary pivot breaking the top two categories down by Equipment ID so the root cause is traceable, apply conditional formatting to flag any equipment above a threshold you define.
  3. Add a third sheet titled 'CI Recommendation Summary' styled as a clean one-pager with four labeled sections: Problem Statement (what the Pareto reveals), Root Cause Hypothesis (2–3 bullet fishbone-style causes for the top category), Recommended Corrective Actions (2–3 specific, actionable steps a site team could take), and Expected Impact (estimated minutes recovered per week if the top category is reduced by 50%), use a table or text boxes so it reads as a professional leadership handout, not a raw worksheet.
Build this project for free →

Free account. Provieo walks you through it and turns it into a page with a link you can put on your application. This posting comes with you.

Questions

Do I need to know how to code?

No. For roles like this one, Provieo builds the project as a live case-study page: slides, tables and findings you fill in. You bring the thinking.

Where did this project come from?

Provieo read the AstraZeneca posting and generated it on 2026-10-21. If you paste the same posting yourself you may get a different project, so two applicants don't show up with the same one.

Is Provieo connected to AstraZeneca?

No. This is an independent project idea based on a public posting. It does not guarantee an interview.