Manager, Business Intelligence Architect and Reporting

Posted 16 Mar 2020

Rockland, Massachusetts - United States

Req Id 204755


A career with EMD Serono is an ongoing journey of discovery: our 56,000 people are shaping how the world lives, works and plays through next generation advancements in healthcare, life science and performance materials. For more than 350 years and across the world we have passionately pursued our curiosity to find novel and vibrant ways of enhancing the lives of others. EMD Serono is a business of Merck KGaA, Darmstadt, Germany.

Your role:
You will be responsible for understanding complex data sources and points of integration; preparing data for reporting, developing actionable and accessible dashboards and reports based on user objective, and supporting data warehouse design. Work with the key stakeholders in scoping out and translating requirements for new reporting initiatives. Retrieve, organize, and manipulate data from the Enterprise Data Warehouse and other databases. This will require programming (SQL) to create Tableau extracts. Act as a technical lead/architect for development efforts within the reporting (e.g. Tableau) environment. Act as a point person for the business to handle ad hoc requests and questions concerning the data & reporting. Manage the AWS RedShift Data Source layer with an eye towards best practices, security, and scalability.


Who you are:
Minimum Qualifications:

•Bachelor Degree in a technical discipline (i.e. Computer Science, Engineering, etc.)
•5+ years of experience designing reports and dashboards using Tableau
•4+ years of experience working in data warehousing/business intelligence
•4+ years of experience working in SQL programming language (using Toad for Oracle 11.x/12.x or Redshift)


Preferred Qualifications:
•Familiarity with data preparation techniques and tools such as Alteryx and Tableau Prep
•Understanding of best data modeling principles and the ability to create and modify complex data models
•Experience in working with cross-functional, multi-cultural teams as well as skills to manage virtual teams of external vendors
•Proven ability to execute multiple tasks efficiently and effectively
•Self-motivated, independent and possesses the ability to learn quickly
•Strong written and verbal communication skills
•Previous experience with pharmaceutical data
•Working knowledge of Amazon Web Services offerings and hands on experience with RedShift
•Certified Tableau developer/administrator is preferred



What we offer: With us, there are always opportunities to break new ground. We empower you to fulfil your ambitions, and our diverse businesses offer various career moves to seek new horizons. We trust you with responsibility early on and support you to draw your own career map that is responsive to your aspirations and priorities in life. Join us and bring your curiosity to life!

Curious? Apply and find more information at

The Company is an Equal Employment Opportunity employer. No employee or applicant for employment will be discriminated against on the basis of race, color, religion, age, sex, sexual orientation, national origin, ancestry, disability, military or veteran status, genetic information, gender identity, transgender status, marital status, or any other classification protected by applicable federal, state, or local law. This policy of Equal Employment Opportunity applies to all policies and programs relating to recruitment and hiring, promotion, compensation, benefits, discipline, termination, and all other terms and conditions of employment. Any applicant or employee who believes they have been discriminated against by the Company or anyone acting on behalf of the Company must report any concerns to their Human Resources Business Partner, Legal, or Compliance immediately. The Company will not retaliate against any individual because they made a good faith report of discrimination.


Apply Now

Let’s stay connected

Do you want to receive company news and information about career opportunities tailored to your preferences? Sign up here. You want to check the status of your application or change your candidate profile? Enter our job portal.


You have accessed, but for users from your part of the world, we originally designed the following web presence

Let's go

Share Disclaimer

By sharing this content, you are consenting to share your data to this social media provider. More information are available in our Privacy Statement