Job Title

　　Senior Inventory Control Analyst

　　Requisition

　　JR000013809 Senior Inventory Control Analyst (Open)

　　Location

　　St. Louis, MO (Pharma) - USA032

　　Additional Locations

　　St. Louis, MO

　　Job Description

　　SUMMARY OF POSITION:

　　Create, maintain, and utilize data analysis tools that connect ERP systems data within the organization that are required for planning, inventory management, and reporting. Maintain functionality of Microsoft Access databases and other reporting and visualization tools 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. Coordinate and manage physical inventories and cycle counts. Manage projects as well as participate on teams regarding key business initiatives. Support ad hoc requirements.

　　ESSENTIAL FUNCTIONS:

　　Coordinates and manages physical inventory and cycle count processes. Works closely with manufacturing, materials management and warehousing and finance groups to provide guidance on inventory variance reconciliation to ensure only appropriate adjustments are taken. Documents variances and adjustments to facilitate root cause analysis and corrective actions to prevent recurrence and assure a high level of inventory accuracy, leading to reduced inventory levels and carrying costs.

　　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. Maintains security and integrity controls. Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization. May develop stored procedures and/or triggers.

　　Perform detailed data manipulation and analysis concerning, planning, forecasting, net requirements, inventory management, backorder recovery, service, pharmaceutical quota management, Sales & Operations Planning process, and other relevant issues.

　　Must have the ability to identify issues, problems, and opportunities and develop technical resolution option and share with Managers as appropriate.

　　Work closely with IS support to assess system-related issues and ensure appropriate IS actions are communicated and delivered.

　　Develop, maintain, and train others on the make-up of these analytical tools to support planning, inventory management and reporting.

　　Document work instructions for use of tools and best practices for data-gathering across Pharmaceuticals.

　　Investigate new supply chain and inventory control concepts through continued education, seminars, training, and/or other research avenues, including those offered internally.

　　Support Managers of Supply Chain Planning as required.

　　MINIMUM REQUIREMENTS:

　　Education:

　　Bachelor's degree in business or related field. Equivalent experience will be considered.Experience:

　　Minimum of five years' experience in business analyst or equivalent experience

　　Proficiency required in SQL Server, Visual Basic, Microsoft Access, and Excel

　　Preferred Skills/Qualifications:

　　APICS certification, familiarity with DRP/MRPII systems, JD Edwards World, JD Edwards E1, BPCS, JDA Master Planning, JDA S&OP, JDA Demand/Collab, JDE WorldWriter and AS400 Query preferred.

　　Understanding of supply chain principles preferred.

　　Other Skills:

　　Proven analytical/problem solving skills.

　　Ability to analyze and effectively communicate recommendations based on analysis. Strong data extraction skills required.

　　Excellent written and oral communication skills.

　　Strong organization and time management skills.

　　Ability to handle and appropriately prioritize multiple projects, with a drive to satisfy deadlines.

　　Ability to work independently.

　　ORGANIZATIONAL RELATIONSHIP/SCOPE:

　　Frequent interaction with all aspects of Supply Chain.

　　WORKING CONDITIONS:

　　The work environment is an office setting. Occasionally the duties may require visiting manufacturing and/or warehouse facilities. These settings may be noisy and may require hearing protection. Hard hat and

　　Mallinckrodt is a global specialty p harmaceutical business that develops, manufactures, markets and distributes specialty pharmaceutical products. Areas of focus include therapeutic drugs for autoimmune and rare disease specialty areas like neurology, rheumatology, nephrology, ophthalmology and pulmonology; immunotherapy and neonatal respiratory critical care therapies; and analgesics and central nervous system drugs. The company's core strengths include the acquisition and management of highly regulated raw materials; deep regulatory expertise; and specialized chemistry, formulation and manufacturing capabilities. The company's Specialty Brands segment includes branded medicines; its Specialty Generics segment includes specialty generic drugs, active pharmaceutical ingredients and external manufacturing.

　　To learn more about Mallinckrodt, visit www.mallinckrodt.com.

　　Mallinckrodt Pharmaceuticals (“the Company”) maintains a continuing policy of non-discrimination in employment. The Company is an equal opportunity employer and complies with all applicable laws prohibiting discrimination based upon age, ancestry, color, religious creed (including religious dress and grooming practices), disability (mental and physical), marital status, medical condition, genetic information, military and veteran status, national origin (including language use restrictions), political activities or affiliation, race, sex (including pregnancy, child birth, breastfeeding and medical conditions related to pregnancy, child birth or breastfeeding), gender, gender identity and gender expression, sexual orientation, as well as any other category protected by law. Furthermore, it is our policy to provide equal opportunity to individuals with disabilities and protected veterans in all phases of the employment process and in compliance with applicable federal, state, and local laws and regulations on every location in which the company has facilities. This policy of non-discrimination shall include, but not be limited to, the following employment decisions and practices: recruiting, hiring; promotions; demotions or transfers; layoffs; recalls; terminations; rates of pay or other forms of compensation; selection for training, including apprenticeship; and recruitment or recruitment advertising.

　　Mallinckrodt Pharmaceuticals is required to report certain payments or transfers of value (such as expense reimbursement, meals, transportation) made to U.S.-licensed healthcare professionals in compliance with the federal Physician Payment Sunshine Act (i.e. Open Payments) and certain state laws.