Sales Operations Data Analyst Intern

Job Title

Sales Operations Data Analyst Intern

Requisition

JR000014773 Sales Operations Data Analyst Intern (Open)

Location

Bridgewater, NJ

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.

Job Description

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.

Summary

• The Commercial Effectiveness Department is seeking a summer intern to join their CRM Strategy and Execution Team to assist with the technology for managing and supporting customer relationships, called Veeva CRM. Throughout the summer, the intern will use tools such as Excel and Salesforce.com to build reports that provide analytics and insights into our data. The intern will be paired with a mentor who will provide guidance, support, and professional development through the duration of the internship. The candidate should have strong analytical and critical thinking skills in order to recommend actionable solutions to management. The candidate should also be able to work in a fast-paced environment and manage time effectively, as ad hoc reporting will be a critical aspect of day-to-day responsibilities. At the end of the internship, the candidate will participate in a capstone presentation to share projects with upper management and explain their impact on Mallinckrodt. This is a hybrid position located in Bridgewater, NJ.

On-site days will be Tuesday and Wednesday. The other days will be remote

Program will start on May 20th and end on August 1st.

Essential Functions

• Assist with the creation of data quality reports 

• Diagnose Master Data inconsistencies within/outside of Veeva CRM 

• Provide analytics that will allow us to enhance strategic project plans to master data 

• Collaborate with IT team to load new data into Veeva and ensure necessary updates to existing data 

• Build reports/dashboards in Salesforce.com to analyze ad hoc issues and provide solutions on a timely basis 

• Utilize Salesforce.com reports to create dashboards that efficiently summarize findings 

• Use Excel tools and functionalities to clean, format, explore, and summarize data 

• Extract and analyze data from Veeva to provide insights to managers, sales representatives, and other department teams 

• Report on monthly sales and expense data 

• Conduct research and reconcile data to identify records with outdated information 

• Assist with the updating/review of training materials 

• Assist Commercial Effectiveness with documenting SOPs across departments 

Minimum Requirements

Education / Experience / Skills:

• Undergraduate or Graduate Student majoring in Business Analytics, Data Analytics, Computer Science, Data Engineering, Data Science, Finance, Accounting, Economics, Business, or another analytical discipline 

• Prior experience in data analytics 

• Required Skills: Excel, PowerPoint, Outlook 

• Ability to work collaboratively in a team-oriented environment 

• Eagerness to learn, adaptability, and a proactive mindset 

• Preferred Skills: Salesforce, Veeva CRM, MS Access,

Organizational Relationship/Scope:

• Throughout the summer, the intern will engage in regular discussions with an assigned mentor, seeking guidance on career development, industry insights, and project-related questions. The intern will report to the manager of the CRM Strategy and Execution Team, but he or she will also be working closely with the other individuals in this team. On a project-to-project basis, the intern will also collaborate with other teams in the Commercial Effectiveness Department, including Marketing Services, Incentive Compensation and Salesforce Enablement, Training, and Field Operations. The intern will also regularly interact with members of our IT team to troubleshoot technology issues as well as obtain a better understanding of our data. 

Disclaimer:

The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification.  They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of employees assigned to this position.