Job Title Supply Chain Intern Requisition JR000014794 Supply Chain Intern (Open) Location Hobart, NY Additional Locations Job Description Summary Mallinckrodt is a company united around a central pursuit – improving outcomes for underserved patients with severe and critical conditions. As a purpose-driven organization with a broad network and relentless determination, we create products, delivery systems and solutions for patients whose needs have not been met. Mallinckrodt is a global business consisting of multiple wholly owned subsidiaries that develop, manufacture, market and distribute specialty and generic pharmaceutical products and therapies. With locations in the US, Canada, Europe and Asia, culture is one of the most important aspects of our organization. Who we are at the core of our company - how we think, feel and work together means everything. We are anchored in our values of Patient Centricity, Innovation, Collaboration and Integrity. The Company's Specialty Brands reportable segment's areas of focus include autoimmune and rare diseases in specialty areas like neurology, rheumatology, hepatology, nephrology, pulmonology, ophthalmology and oncology; immunotherapy and neonatal respiratory critical care therapies; analgesics; gastrointestinal products. Its Specialty Generics reportable segment includes specialty generic drugs and active pharmaceutical ingredients. We are focused on listening for needs and delivering solutions. We provide medicines to address unmet patient needs, stemming from 155 years of using our unique strengths, experience and expertise to help improve people's lives. We know that we contribute to something that matters because we make quality products that impact patient lives. We have built an inclusive community and recognize the importance of every employee as a whole person – inside and outside of work. Our dynamic work environment provides unique experiences for employees to grow and develop. We are moving forward – come with us. The Program Mallinckrodt is offering an 11-week internship program, which provides an immersive experience in the world of pharmaceuticals. As an MNK Intern, you will have the opportunity to contribute to meaningful and impactful work that compliments the degree you are pursuing. Here, you will be able to apply what you’ve learned in the classroom to a corporate environment. In addition, our internship program is designed to include networking opportunities across the company, professional development workshops, and community service. Mallinckrodt is united around our mission – Listening for needs. Delivering solutions. Join us to get a sense of what it’s like to work at Mallinckrodt and gain the real-world experience you are seeking. Job Description Implements and maintains smooth operation and physical design of databases. Conducts performance tuning of indexes and databases in general. Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements. Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization. May develop stored procedures and/or triggers. Document work instructions for use of planning tools and best practices for data-gathering across Pharmaceuticals. Perform detailed data manipulation and analysis concerning Planning, to include forecasting, net requirements, inventory management, backorder recovery, service, pharmaceutical quota management, Sales & Operations Planning process, and other relevant issues. Maintain functionality of the current Microsoft Access databases while designing, developing, testing, and implementing new databases and reports in such programs as Microsoft Access, Microsoft Excel, SQL, utilizing information from the data warehouse. Develop automated process for Planning Schedules to be pulled directly out of ERP.Essential FunctionsProblem Solving: Rigorously and systematically connects information, processes and events by organizing divergent information and searching for common themes, patterns, and causal connections. Undertakes a complex task by breaking it down into manageable parts in a systematic, detailed way. Thinks of several possible explanations or alternatives for a situation and anticipates potential obstacles and develops contingency plans to overcome them. Uses intelligence, common sense, hard work and tenacity to solve particularly difficult or complicated challenges.Attention to Detail/Focus: Is thorough and precise in accomplishing a task through concern for all the areas involved, no matter how small. Monitors and checks work or information and plans and organizes time and resources efficiently. Double-checks the accuracy of information and work product to provide accurate and consistent work. Provides information on a timely basis and in a usable form to others who need to act on it. Compares observations of finished work to what is expected to find inconsistencies.Composure: Is cool under pressure; does not become defensive or irritated when times are tough; is considered mature; can be counted onto hold things together during tough times; can handle stress; is knocked off balance by the unexpected; doesn’t show frustration when resisted or blocked; is a settling influence in a crisis.Positive Attitude/Engagement: Shows commitment/dedication and accountability in one’s work; and follows through on all aspects. Takes personal responsibility for resolving problems brought to one’s attention. Goes beyond expectations in the assignment/task, or job description without being asked. Minimum Requirements Education / Experience / Skills: + Undergraduate degree in process, in a supply chain, business or related field. Preferred Skills/ Qualifications: + Strong computer skills, experienced in Microsoft products. + Advanced Excel skills. Compensation: $23.00 - $25.00/hour At Mallinckrodt, we know that we contribute to something that matters because we make quality products that impact patient lives. Our dynamic work environment provides unique experiences for employees to grow and develop. Invest in your own career with Mallinckrodt and let’s do something dynamic together. Mallinckrodt provides equal employment opportunities to applicants and employees without regard to race; color; gender; gender identity; sexual orientation; religions practices and observances; national origin; pregnancy, childbirth, or related medical conditions; protected veteran status; disability; or any other category protected by law. Additional information on Mallinckrodt’s hiring practices may be found by clicking (https://secure.compliance360.com/ext/ESLKi3LFkqY=)