Data Analytics Intern
HSBC•Guangzhou, RI
About The Position
In this position, you will: Participate in building and optimizing RAG for retrieving from knowledge bases/documents and combining with large models to generate programs (SQL, Python). Design and debug prompts to automatically generate or complete SQL and Python code templates, and verify the correctness and robustness of the generated results. Implement, test, and deploy small services in the team's code repository, write unit tests, and participate in code reviews. Design automated evaluation metrics (e.g., generation accuracy, query performance), and iterate on models and retrieval strategies based on feedback.
Requirements
- Computer Science, Software Engineering, Data Science, or related major student or recent graduate.
- Proficient in Python, able to read and modify moderately complex code.
- Project or internship experience, familiar with Git workflow, unit testing, and basic software engineering practices.
- Practical experience or experimentation with Retrieval-Augmented Generation (RAG), able to explain design ideas and practical cases for generating SQL/code.
- Familiar with relational databases and SQL, able to use SQL for data extraction and verification, with basic data analysis methods.
- Strong learning ability, able to break down complex problems and express them clearly in documentation.
Nice To Haves
- Experience using OpenAI or local LLMs, familiar with prompt engineering.
- Ability to create automated validation scripts for generated code.
- Familiarity with web scraping development and practical experience with web scraping projects.
Responsibilities
- Participate in building and optimizing RAG for retrieving from knowledge bases/documents and combining with large models to generate programs (SQL, Python).
- Design and debug prompts to automatically generate or complete SQL and Python code templates, and verify the correctness and robustness of the generated results.
- Implement, test, and deploy small services in the team's code repository, write unit tests, and participate in code reviews.
- Design automated evaluation metrics (e.g., generation accuracy, query performance), and iterate on models and retrieval strategies based on feedback.
Benefits
- Continuous professional development
- Flexible work arrangements
- Growth opportunities
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Career Level
Intern
