Summer Internship: Data and Analytics Intern (Hybrid - San Carlos, CA)

Descrizione del lavoro:

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

This is an in person role - our ideal candidate will come to San Carlos office every week Tuesday & Wednesdays or other days as needed. 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.

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 data bases, data warehousing, machine learning, Data modeling concepts (star schema, fact/dimension tables)
Hands-on experience on 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

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
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.

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