Data Warehouse Intern
FUKU.AISingapore, Singapore, SingaporeOn-Site
Needs a free Superjobs account. You'll finish on FUKU.AI's site.
Skill score
Summary
The intern helps design, build, and maintain real-time data warehouse systems, writing Flink or Spark Streaming jobs and layered ODS, DWD, and DWS models fed by Kafka and MySQL Binlog. It suits a student pursuing a technical degree who has SQL and a programming language and can commit at least four days a week for three months.
- Function
- Data Science
- Estimated salary
- Est. $16k–24k/yr
- Estimated for an internship, Singapore. Not published by the employer.
- Work mode and location
- On-Site, Singapore, Singapore, Singapore
- Employment type
- Internship
Job description
Overview
We are looking for a motivated Data Warehouse Intern to join our team. You will have the opportunity to participate in the design, development, and maintenance of real-time data warehouse systems, work with big data technologies such as Flink, Spark Streaming, and Kafka, and gain hands-on experience in real-time data processing, data modeling, and data pipeline optimization.
Roles and responsibilities
- Participate in the design, development, and maintenance of real-time data warehouse systems.
- Develop real-time data processing jobs using Flink / Spark Streaming.
- Assist in designing real-time data models and building layered data warehouse architectures, including ODS, DWD, and DWS.
- Integrate real-time data sources such as Kafka and MySQL Binlog.
- Assist in optimizing real-time processing performance to ensure data timeliness, accuracy, and reliability.
- Prepare technical documentation and support data quality monitoring.
Skills required
Top skills
- SQL
- Data warehouse concepts
- Dimensional modeling
All skills (9)
- Java, Python or Scala
- Flink
- Spark Streaming
- Kafka
- MySQL Binlog CDC
- Doris
- ClickHouse
- Hudi or Iceberg
- Data pipeline optimization
Qualifications
1. Required Qualifications
- Currently pursuing a Bachelor's degree or above in Computer Science, Software Engineering, Data Science, or a related field.
- Proficient in SQL, with hands-on experience in data processing.
- Familiar with fundamental data warehouse concepts, including dimensional modeling and layered architecture.
- Proficient in at least one programming language: Java, Python, or Scala.
- Available for at least 4 days per week, with a minimum internship commitment of 3 months.
Nice to have
- Hands-on experience with Flink or Spark Streaming.
- Familiarity with big data technologies such as Kafka, Doris, ClickHouse, Hudi, or Iceberg.
- Understanding of MySQL Binlog and Change Data Capture (CDC) data synchronization.
- Previous internship or project experience in data warehousing or big data engineering.
Company info
About FUKU.AI
FUKU.AI is an AI-native hiring operating system that helps companies, especially small and medium enterprises, source, screen, interview and reach out to candidates. Its users are hiring teams who draw on a verified resume database across Asia-Pacific.