Sr. Data Engineer

Company: Moderna
Location: Cambridge
Posted on: March 17, 2023

Job Description:

The Role

Do you have a great "can-do" positive attitude? Can you draw conclusions from data using analytical skills? Do you have a passion for understanding the business and presenting information that the business can use to improve processes? Can you do what it takes, and are you committed and strive through with determination and motivation to make this team successful?

It is an exciting time to be a part of the growing Data Engineering team at Moderna. We are driving a well-supported cloud-first strategy to unlock the power of data across the company and help teams to discover, value and act on insights from data that improve the health and well-being of millions of lives across the globe. With our strong data pipeline, this position will play a key role partnering with our Technical Development stakeholders to enable operational analytics for long term success

We are looking for a collaborative and bold Sr. Data Engineer who has experience architecting and implementing technical solutions as part of a greater data analytics strategy. This role is responsible for hands on sourcing, manipulation and delivery of data from enterprise business systems to data lake and data warehouse. This role will help drive Moderna's next phase in the digital journey by modeling and transforming data to achieve actionable business outcomes. The Sr. Data Engineer will create, troubleshoot and support ETL pipelines and the cloud infrastructure involved in the process, will be able to design and maintain comprehensive visualizations using a BI tool.

Here's What You'll Do

• Collaborate with business stakeholders across the Legal and People Analytics teams and other technical team members to acquire and migrate initial data sources that are most relevant to business needs and goals.
  
• Demonstrate deep technical and domain knowledge of relational and non-relation databases, Data Warehouses, Data lakes among other structured and unstructured storage options.
  
• Determine which tools and architectures are best suited to develop a pipeline for a particular data source.
  
• Develop data flow pipelines to extract, transform, and load data from various data sources in various forms, including custom ETL pipelines that enable model and product development.
  
• Write custom scripts to extract data from unstructured/semi-structured sources.
  
  • Provide clear documentation for delivered solutions and processes, integrating documentation with the appropriate corporate stakeholders.
    
  • Identify and implement internal process improvements for data management (automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability).
    
  • Stay current with and adopt new tools and applications to ensure high quality and efficient solutions.
    
  • Build cross-platform data strategy to aggregate multiple sources including manufacturing, equipment, laboratory testing and process development datasets.
    Here's What You'll Need (Minimum Qualifications)
    • BS/BA degree in Computer Science or equivalent in education and experience
      
    • Minimum 8 years of experience designing, developing, testing, and implementing ETL solutions using any enterprise ETL tools
      
    • Experience working in Life Sciences, pharma/biotech, or related field
      
    • Proven experience working with Cloud Environments, AWS preferred
      
    • Experience with Data Prep/Automation tools such as Dataiku
      Here's What You'll Bring to the Table (Preferred Qualifications)
      • Proven experience with BI tools such as Tableau and Spotfire preferred
        
      • Experience working in regulated environments with GXP experience in pharma/biotech strongly preferred
        
      • Extensive knowledge of data warehouse design and data modeling principles, following the most updated and performant standards
        
      • In-depth understanding of database management systems and scripting (SQL, NoSQL and distributed databases)
        
      • Knowledge of relevant Legal and HR systems (e.g. Workday, Agiloft, SAP, Glint), and industry standards applicable to pharmaceutical digital and data information systems
        
      • Scripting experience, Python, Julia, or NodeJs preferred
        
      • Experience with BI tools such as Tableau and Spotfire preferred
        
      • Strong communication skills, a customer service attitude, and demonstrated problem solving ability.
        
      • A desire to make an impact as part of a high-growth, transformational company that is Bold, Relentless, Curious, and Collaborative
        Moderna is pleased to provide you and your family with a comprehensive and innovative suite of benefits, including:
        • Highly competitive and inclusive medical, dental and vision coverage options
        • Flexible Spending Accounts for medical expenses and dependent care expenses
        • Lifestyle Spending Account funds to help you engage in personal enrichment and self-care activities
        • Family care benefits, including subsidized back-up care options and on-demand tutoring
        • Free premium access to fitness, nutrition, and mindfulness classes
        • Exclusive preferred pricing on Peloton fitness equipment
        • Adoption and family-planning benefits
        • Dedicated care coordination support for our LGBTQ+ community
        • Generous paid time off, including:
          --- Vacation, sick time and holidays
          --- Volunteer time to participate within your community
          --- Discretionary year-end shutdown
          --- Paid sabbatical after 5 years; every 3 years thereafter
        • Generous Paid Leave offerings, including 18 weeks of 100% paid parental leave for all new parents
        • 401k match and Financial Planning tools
        • Moderna-paid Life, LTD and STD insurance coverages, as well as voluntary benefit options
        • Complimentary concierge service including home services research, travel booking, and entertainment requests
        • Free parking or subsidized commuter passes
        • Location-specific perks and extras!
          
          Candidates should be aware that Moderna currently maintains a policy requiring all US-based employees to be fully vaccinated against COVID-19 and receive a booster shot once eligible. Newly hired employees must be vaccinated and boosted prior to their employment start date. Moderna is an equal opportunity employer and will provide a reasonable accommodation to those unable to be vaccinated or receive a booster where it is not an undue hardship to the company to do so as provided under federal, state, and local law.
          
          About Moderna
          
          In over 10 years since its inception, Moderna has transformed from a research-stage company advancing programs in the field of messenger RNA (mRNA), to an enterprise with a diverse clinical portfolio of vaccines and therapeutics across seven modalities, a broad intellectual property portfolio in areas including mRNA and lipid nanoparticle formulation, and an integrated manufacturing plant that allows for rapid clinical and commercial production at scale. Moderna maintains alliances with a broad range of domestic and overseas government and commercial collaborators, which has allowed for the pursuit of both groundbreaking science and rapid scaling of manufacturing. Most recently, Moderna's capabilities have come together to allow the authorized use and approval of one of the earliest and most effective vaccines against the COVID-19 pandemic.
          
          Moderna's mRNA platform builds on continuous advances in basic and applied mRNA science, delivery technology and manufacturing, and has allowed the development of therapeutics and vaccines for infectious diseases, immuno-oncology, rare diseases, cardiovascular diseases and autoimmune diseases. Moderna has been named a top biopharmaceutical employer by Science for the past seven years. To learn more, visit www.modernatx.com.
          
          Moderna is a smoke-free, alcohol-free and drug-free work environment.
          
          Moderna is committed to equal employment opportunity and non-discrimination for all employees and qualified applicants without regard to a person's race, color, gender, age, religion, national origin, ancestry, disability, veteran status, genetic information, sexual orientation or any characteristic protected under applicable law. Moderna will make reasonable accommodations for qualified individuals with known disabilities, in accordance with applicable law.

Keywords: Moderna, Cambridge , Sr. Data Engineer, Engineering , Cambridge, Massachusetts