Senior Manager BI Data Architect - Rockland MA

Posted 30 Oct 2023

Rockland, Massachusetts - United States

Req Id 269202


Work Your Magic with us!

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.


Your Role: 


We are seeking an experienced and highly motivated Senior Manager and business Intelligence Data Architect to join our dynamic team. In this role, you will be responsible for understanding complex data sources, architecting, designing, and implementing robust and scalable data solutions that enable the organization to extract actionable insights from complex datasets. You will work closely with cross-functional teams to understand business requirements, design data models, and develop data integration processes to support various analytical initiatives. You will lead, innovate, inspire, and engage with passion by modeling EMD Serono behaviors and working with a sense of urgency to achieve organizational goals.


Additional responsibilities include but are not limited to:


  • Lead data architecture & modeling efforts including Redshift, Snowflake related cloud data products, including the design of data structures and the identification of business transformation logic to support analytical needs.
  • 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 point person for the business & other stakeholders to handle questions concerning the data & reporting.
  • Manage the AWS RedShift Data Source layer with an eye towards best practices, security, and scalability.
  • Deep understanding of database systems and a proven track record of optimizing query performance, enhancing database efficiency, and improving overall system responsiveness.
  • Play a key role in the process of data transformation required for effective reporting, analytics, and visualization.
  • Familiarity with data visualization tools and a proven ability to diagnose, troubleshoot, and resolve data issues in existing dashboards.
  • Willing to learn and use new BI & Datawarehouse tools as we modernize our BI Datawarehouse and Reporting environment.
  • Other duties as assigned.


Who You Are


Minimum Qualifications:

  • BS in a technical discipline (i.e., Computer Science, Engineering, etc.) with 5+ years’ experience or Masters Degree and a minimum of 3+ years or a PhD with a minimum of 2+ years
  • 5+ years of experience working in data warehousing/business intelligence & designing data models
  • 5+ years of experience working in SQL programming language (using Toad for Oracle 11.x/12.x or Redshift)
  • 2+ experience using Tableau or other BI reporting tools
  • Experience in working with cross-functional, multi-cultural teams as well as skills to manage virtual teams of external vendors
  • Understanding of best data modeling principles and the ability to create and modify complex data models
  • Strong analytical, problem-solving, and communication abilities


Preferred Qualifications:

  • Familiarity with data preparation techniques and tools such as Alteryx and Tableau Prep
  • 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, IDQ, glue, Kyligence, etc., and hands-on experience with RedShift
  • Certified Tableau developer/administrator is preferred


Location: Rockland MA, on-site with flex


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

US Equal Employment Opportunities

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.

We are committed to an equitable hiring process for candidates from a diverse range of backgrounds. As part of this commitment, applicants with disabilities may be entitled to reasonable accommodations. Please contact, if a reasonable accommodation is needed or if you otherwise need assistance to participate in the hiring process.

North America Disclosure

If you are a resident of California, Colorado, New York, or Washington, you are eligible to receive additional information about the compensation and benefits, which we will provide upon request. You may contact 855 444 5678 from 8:00am to 5:30pm ET Monday through Friday, for assistance.

Notice on Fraudulent Job Offers

Unfortunately, we are aware of third parties that pretend to represent our company offering unauthorized employment opportunities. If you think a fraudulent source is offering you a job, please have a look at the following information:

Apply Now

Join our Talent Zone

You haven't found quite the right job yet? Join our Talent Zone and stay in touch with us. Be the first one to learn about our new career opportunities and events.

Tell us about yourself and let our Talent Advisors help you find your next career opportunity.