Summer Internship: Data Management Intern (Remote)

BeiGene

1d • 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. Internship program dates: June 8 - August 21, 2026 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 out of east coast and come to Hopewell office every other week. We are unable to offer relocation assistance. 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. We are seeking a motivated AI & Data Engineering Intern to help design and build an AI-powered bot that interfaces with our enterprise data warehouse hosted on Amazon Redshift. This role blends data engineering, AI/ML integration, and backend development to enable intelligent querying, analytics automation, and conversational data access.

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., OpenAI).
• 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.

Responsibilities

• AI Bot Development Assist in designing and building an AI-powered chatbot interface for querying Redshift data.
• Implement Natural Language to SQL (NL2SQL) pipelines.
• Integrate Large Language Models (LLMs) via APIs.
• Build prompt engineering workflows and evaluation pipelines.
• 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.
• Backend & Integration Develop backend services (Python preferred) to connect AI services with Redshift.
• Implement APIs for chatbot interaction.
• Handle authentication and secure query execution.
• Work with AWS services such as: AWS Lambda Amazon S3 Amazon API Gateway

Benefits

• Medical
• Dental
• Vision
• 401(k)
• FSA/HSA
• Life Insurance
• Paid Time Off
• Wellness
• opportunity to own shares of BeOne Medicines Ltd. stock because all employees are eligible for discretionary equity awards and to voluntarily participate in the Employee Stock Purchase Plan

What This Job Offers

• Career Level: Intern