Senior Data Warehouse Architect

Added: 11/10/2021

REF: 16246

Contract: Permanent

Location: Medford, Massachusetts, United States

Company Overview

We are a  life sciences company developing products that help to solve issues facing plant health, human health, and animal health.
We are designing products to create a future with a cleaner environment, healthier people, and a stronger food supply chain.

Senior Data Warehouse Architect

We are seeking a Data Warehouse Architect to join our team. This person will own/build the data warehouse solutions. Ideally, we are seeking someone who is very hands-on and ambitious with strong experience in Data Warehouse Architecture. This person must be able to deliver end-to-end data solutions.

Day to day responsibilities:

  • Collaborate with Data team peers, stakeholders, and end-users to
  • Manage Data Warehouse Database and associated data systems on Cloud ex. Azure Data Factory, Snowflake, Redshift
  • Develop and support scripts for data loading, unloading, and maintenance
  • Follow standards for designing data marts and data warehouses
  • Be the technical leader in your field & collaborate with peers
  • Evaluate new database technologies and products
  • Review code and implementations
  • Write documentation on design, architecture, solutions, and training materials

Must have:

  • Biotech or Pharma Industry Experience
  • Bachelors Computer Science or related field
  • 6+ years of IT experience
  • ETL/ ELT experience
  • Experience with Data Warehouse principles
  • Experience in cloud data warehouse design/data integration 
  • 4+ years of General database administration
  • SQL/NoSQL expertise
  • Strong experience working in the Azure ecosystem
  • 4+ years of experience integrating data
  • 4+ years of experience writing software preferable in Python and/or Java

Nice to have:

  • Experience in IT/Analytics teams of biotech organizations. Familiarity with research/scientific computing challenges.
  • Experience with Analytic BI tools such as Tableau, Power BI
  • 4+ years of experience with data modeling
  • 4+ years of hands-on experience designing and developing scalable applications
  • DevOps and Agile Development experience


Apply Now

Complete the form below to apply for the Senior Data Warehouse Architect role:

Add Your CV

Alternatively select from

View all jobs