Summer Internship: Data Infrastructure Validation Intern

BeiGene

2d•Remote

About The Position

BeOne continues to grow at a rapid pace with challenging and exciting opportunities for experienced professionals. When considering candidates, we look for scientific and business professionals who are highly motivated, collaborative, and most importantly, share our passionate interest in fighting cancer. Note: To be considered for our 2026 Summer Internship program you must be enrolled in a university degree program and cannot be graduating sooner than December 2026. This is a remote role - our ideal candidate will be based on the East Coast and be able to travel to our Hopewell office every other week as needed. We are unable to offer relocation assistance or commuting expenses. Education Required: Interns must be actively enrolled in a university undergrad degree program (entering junior year or above preferred; with a 3.0 GPA) or enrolled in master’s or PhD Program. Currently pursuing a degree in Computer Science, Data Science, AI, or related field. General Description/Scope of Responsibilities (Internship): Data and Analytics Internship offers hands-on experience in data modeling, ETL, visualization, data quality checks, and reporting using SQL, AWS.

Requirements

Understanding of relational data bases, data warehousing, machine learning, Data modeling concepts (star schema, fact/dimension tables)
Strong knowledge in AWS, Redshift, SQL (query optimization, joins, aggregations, CTEs).
Basic experience with Python
Familiarity with REST APIs, AI/LLMs and prompt engineering
Interest in AI/LLMs and prompt engineering.
Familiarity with LLM APIs (e.g., Open AI).

Responsibilities

Data Engineering & Warehousing Understand data models, schemas, and ETL pipelines, create meta data within Amazon Redshift.
Optimize SQL queries for performance.
Support data transformations and create views/materialized views.
Data Validation Create data quality checks on Redshift tables and procedure Create metadata for AI use cases