Hybrid (in-person at san carlos office on tuesdays and wednesdays)
Ai bot development
Nl2sql pipelines
Data engineering & redshift optimization
BeOne Medicines is seeking a Data and Analytics Intern for a summer internship in San Carlos, California. The role requires an undergraduate or graduate student with experience in data modeling, SQL, and AWS, focusing on developing an AI-powered chatbot interacting with enterprise data
Job Summary
The Data and Analytics Internship offers hands-on experience in data modeling, ETL, visualization, data quality checks, and reporting using SQL, AWS.
Key responsibilities include assisting in designing and building an AI-powered chatbot interface for querying Redshift data and implementing NL2SQL pipelines.
The role blends data engineering, AI/ML integration, and backend development to enable intelligent querying, analytics automation, and conversational data access.
Matching Summary
Match Score: 85
BeOne Medicines is seeking a Data and Analytics Intern for a summer internship in San Carlos, California. The role requires an undergraduate or graduate student with experience in data modeling, SQL, and AWS, focusing on developing an AI-powered chatbot interacting with enterprise data.
Salary
Masters: $30/hour USD; PhD: $35/hour USD; Benefits: Medical, Dental, Vision, 401(k), FSA/HSA, Life Insurance, Paid Time Off, and Wellness
Skills & Requirements
Must-have
AI Bot Development
NL2SQL pipelines
Data Engineering & Redshift Optimization
Backend & AWS Integration
SQL query optimization
Python-based backend services
Nice-to-have
Collaborative and motivated professionals
Passionate interest in fighting cancer
Continuous Learning
Analytical Thinking/Data Analysis
Key Requirements
Actively enrolled in university undergrad (junior year or above preferred) or master’s/PhD program
3.0 GPA
Degree in Computer Science, Data Science, AI, or related field
Understanding of relational databases, data warehousing, machine learning, Data modeling concepts
Hands-on experience on Databricks
Strong knowledge in AWS, Redshift, SQL
Basic experience with Python
Familiarity with REST APIs, AI/LLMs and prompt engineering