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.
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:
•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)
•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 https://jobs.vibrantm.com
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.