AI & Data Engineering Intern

Job Description

About BeOne

BeOne continues to grow at a rapid pace with challenging and exciting opportunities for experienced professionals. We look for scientific and business professionals who are highly motivated, collaborative, and most importantly, share our passionate interest in fighting cancer.

Internship Program Details

• Program Dates: June 8 – August 21, 2026
• Location: In-person role at our San Carlos office every Tuesday & Wednesday or other days as needed.
• Relocation: We are unable to offer relocation assistance.
• Education Required:
  • Actively enrolled in a university undergrad degree program (entering junior year or above preferred; with a 3.0 GPA).
  • OR enrolled in a master’s or PhD Program.
  • Currently pursuing a degree in Computer Science, Data Science, AI, or a related field.

AI & Data Engineering Intern

General Description/Scope of Responsibilities

This internship offers hands-on experience in data modeling, ETL, visualization, data quality checks, and reporting using SQL and 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.

Key Responsibilities

🔹 AI Bot Development

• Assist in designing and building an AI-powered chatbot interface for querying Redshift data.
• Implement NL2SQL pipelines (Natural Language to SQL) to translate user prompts into executable code.
• Metadata Management: Create and maintain table/column descriptions within Redshift to provide the LLM with necessary context.
• Prompt Engineering: Build and test evaluation pipelines to ensure generated SQL is accurate and functional.

🔹 Data Engineering & Redshift Optimization

• Schema Interpretation: Understand Redshift data models and create comprehensive metadata/documentation to feed into the AI context.
• Query Guardrails: Write and optimize SQL queries while implementing logic to prevent “expensive” or “destructive” queries.
• Performance Tuning: Support data transformations and create views/materialized views to simplify the data structure for the AI Input.

🔹 Backend & AWS Integration

• Service Development: Build Python-based backend services (FastAPI/Flask) to handle the flow between the UI, the LLM, and Redshift.
• Secure Execution: Handle authentication and secure query execution.
• Cloud Infrastructure: Work with AWS services including:
  • AWS Lambda for serverless execution.
  • Amazon Bedrock (or SageMaker) for accessing LLMs.
  • AWS Secrets Manager for secure Redshift credential handling.
• Microsoft Outlook Integration with AWS.

Qualifications

• Understanding of relational databases, data warehousing, machine learning, and data modeling concepts (star schema, fact/dimension tables).
• Hands-on experience with Databricks.
• 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).

Travel

N/A

Pay Rates

• Masters: $30/hour USD
• PhD: $35/hour USD

Salary Range: $ – $ per hour.

BeOne is committed to fair and equitable compensation practices. Actual compensation packages are determined by several factors that are unique to each candidate, including but not limited to job-related skills, depth of experience, certifications, relevant education or training, and specific work location. Packages may vary by location due to differences in the cost of labor. The recruiter can share more about the specific salary range for a preferred location during the hiring process. Please note that the listed range reflects the base salary or hourly range only. Non-Commercial roles are eligible to participate in the annual bonus plan, and Commercial roles are eligible to participate in an incentive compensation plan. All Company employees have the 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. The Company has a comprehensive benefits package that includes Medical, Dental, Vision, 401(k), FSA/HSA, Life Insurance, Paid Time Off, and Wellness.

Global Competencies

When we exhibit our values of Patients First, Driving Excellence, Bold Ingenuity, and Collaborative Spirit, through our twelve global competencies below, we help get more affordable medicines to more patients around the world.

• Fosters Teamwork
• Provides and Solicits Honest and Actionable Feedback
• Self-Awareness
• Acts Inclusively
• Demonstrates Initiative
• Entrepreneurial Mindset
• Continuous Learning
• Embraces Change
• Results-Oriented
• Analytical Thinking/Data Analysis
• Financial Excellence
• Communicates with Clarity

Equal Opportunity Employer

We are proud to be an equal opportunity employer. BeOne does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need. In order to ensure reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Era Veterans’ Readjustment Assistance Act of 1974, Title I of the Americans with Disabilities Act of 1990, and any other applicable federal, state or local laws, applicants who require reasonable accommodation in the job application process may contact accommodationsus@beonemed.com.