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

Position: Summer Internship: Data and Analytics Intern (Hybrid - San Carlos, CA)
Summer Internship:
Data and Analytics Intern (Hybrid - San Carlos, CA) page is loaded## Summer Internship:
Data and Analytics Intern (Hybrid - San Carlos, CA) locations:
San Carlostime type:
Full time posted on:
Posted Todayjob requisition :
R33720

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 NL2

SQL 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 Sage Maker) 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/APay Rates:

Masters: $30/hour USDPhD: $35/hour USDGlobal 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…