Merck Group
Managers, Data Analysis and Reporting
Job Description
Work Your Magic with us! Start your next chapter and join EMD Serono.
Ready to explore, break barriers, and discover more? We know you’ve got big plans – so do we! Our colleagues across the globe love innovating with science and technology to enrich people’s lives with our solutions in Healthcare, Life Science, and Electronics. Together, we dream big and are passionate about caring for our rich mix of people, customers, patients, and planet. That’s why we are always looking for curious minds that see themselves imagining the unimaginable with us.
United As One for Patients, our purpose in Healthcare is to help create, improve and prolong lives. We develop medicines, intelligent devices and innovative technologies in therapeutic areas such as Oncology, Neurology and Fertility. Our teams work together across 6 continents with passion and relentless curiosity in order to help patients at every stage of life. Joining our Healthcare team is becoming part of a diverse, inclusive and flexible working culture, presenting great opportunities for personal development and career advancement across the globe.
Managers, Data Analysis and Reporting
Job Location: EMD Serono, Inc., One Technology Place, Rockland, MA 02370
Responsibilities:
- Work with the Business Excellence commercial team and handle different data sets in Redshift and Oracle about MSPDI, iBond, product Rx, Payer data and company sales/shipment data to support daily activities and provide ad-hoc support to users whenever needed;
- Analyze data to provide insight into commercial activities and answer business questions to support a data-driven business decision;
- Develop different Tableau extracts, Custom SQL and Redshift extracts for report creation needs;
- Incorporate different Tableau best practices to optimize and maintain different reports and extracts;
- Integrate different SQL best practices to optimize the SQL query for different Redshift extracts;
- Create ad-hoc reports to support the users for different POA meetings;
- Work closely with the BE Field Planning and Operations team to automate the bonus payout statements and develop reports for different TA teams; and
- Engage with other stakeholders at EMD to understand business objectives and provide BI solution to support business decision.
Requirements & Qualifications:
- Demonstrated ability extracting, transforming and maintaining data in Enterprise Data Warehouse gained through at least two (2) years of work experience;
- Demonstrated ability identifying and working with key stakeholders and capturing, categorizing and interpreting stakeholder requirements gained through at least two (2) years of work experience;
- Demonstrated ability serving as the point of contact for business users for report requests/ad hoc questions about data gained through at least two (2) years of work experience; and
- Demonstrated knowledge of Advanced SQL Server, Oracle, Tableau and Redshift AWS gained through at least two (2) years of work experience.
All years of experience may be gained concurrently.
Telecommuting is an option as long as the individual is based in the Rockland, Massachusetts region as three (3) days of in-office work per week will be required.
This position is eligible for EMD Serono’s Employee Referral Program.
Applicants can send resumes to EMD Serono, Inc., 400 Summit Drive, Burlington, Massachusetts 01803 (Attn: Req# 274088) or apply online at https://www.emdgroup.com/en/careers/job-search.html
What we offer: We are curious minds that come from a broad range of backgrounds, perspectives, and life experiences. We celebrate all dimensions of diversity and believe that it drives excellence and innovation, strengthening our ability to lead in science and technology. We are committed to creating access and opportunities for all to develop and grow at your own pace. Join us in building a culture of inclusion and belonging that impacts millions and empowers everyone to work their magic and champion human progress!
Apply now and become a part of our diverse team!
If you would like to know more about what diversity, equity, and inclusion means to us, please visit https://www.emdgroup.com/en/company/press-positions.html