IT Associate Director - Data and Solutions Architect

Company: Merck Gruppe
Location: Cambridge
Posted on: February 22, 2021

Job Description:

Experience the joy of curiosity, search for a job Click here for additional search options We are experiencing a technical issue with the Careers Website. At--the moment, applications are not possible. We are working on resolving the issue as soon as possible. Thank you for your patience. IT Associate Director - Data and Solutions Architect A career with EMD Serono is an ongoing journey of discovery: our 57,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: The--IT Commercial Data and Solutions Architect position will have three major responsibilities

• Business partner working with Business Excellence (Operational Analytics and Data Science) and Therapeutic Areas to translate analytics requirements and models into work efforts for data integration and quality development team
• Architect and implementation lead for future-state Commercial Data Lake and Warehouse infrastructure and the future state target data model
• Team lead for managing current ETL workflows of data from sources to existing target data model including data mastering processes Location: This role can be based in Rockland, MA or be remote. Who you are: Minimum Qualifications
  • BA/BS in a technical subject area (i.e. Computer Science, Engineering, or related field)
  • 7+ years of experience in data warehousing/business intelligence
  • 3+ years of experience in data integration (ETL) development using Informatica PowerCenter 9.x/10.
  • 2+ years working Amazon Web services such as S3, Redshift, Athena, Glue, etc
  • Experience managing a technical development team of 3+ resources Preferred Qualifications
    • 5+ years of experience in SQL script development using Toad for Oracle 11.x/12.x, or similar
    • 3+ years of experience with UNIX shell scripting
    • 1+ years previous experience with commercial pharmaceutical data
    • Understanding of best data modeling principles and the ability to create and modify complex data models
    • Understanding of standard data integration techniques and ability to recommend and implement appropriate solution based on business intelligence requirements.
    • Able to communicate on a technical and business level.
    • Experience in working with cross-functional, multi-cultural teams as well as skills to manage virtual teams of external vendors.
    • Willingness to travel (up to 10%)
    • Experience with one or more of the following: Tableau, SalesForce.com, GoAnywhere, Dell Boomi 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! 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. Job Requisition ID: 215792 Location: Rockland Career Level: E - Professional (10+ years) Working time model: full-time Careers during Covid-19
      Thank you for visiting our careers website, we are always looking for curious minds to join our teams. We understand how much the world is being impacted by the Covid-19 crisis and we want to assure you that your safety is very important to us. To ensure that everyone's health is protected, instead of a standard face-to-face interview, it is likely that you will be offered alternative digital interview options. US Disclosure
      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. North America Disclosure
      The Company is committed to accessibility in its workplaces, including during the job application process. Applicants who may require accommodation during the application process should speak with our HR Services team at 855 444 5678 from--8:00am--to--5:30pm--ET Monday through Friday.
      Nearest Major Market: Boston
      Job Segment: Solution Architect, Database, Manager, Oracle, Pharmaceutical, Technology, Management, Science

Keywords: Merck Gruppe, Cambridge , IT Associate Director - Data and Solutions Architect, Executive , Cambridge, Massachusetts