I. Responsibilities
- Maintain and optimize in-house data infrastructure including databases (MS SQL Server & PostgreSQL), ETL/ELT pipelines
- Collaborate with development teams to optimize SQL queries and enhance application performance.
- Design, maintain, and develop data pipelines (batch and real-time pipelines) to collect data from multiple sources.
II. Requirements
- Understanding of T-SQL scripting and stored procedure development
- Understanding of using and optimizing SQL/PL SQL and Database (PostgreSQL/SQL Server, MongoDB) is a plus
- Experience using ETL tool SSIS to build and monitor data pipelines, both batch and realtime is a plus
- Experience with object-oriented/object function scripting languages: Python, Scala is a plus
- Knowledge in using BI tools (PowerBI/Qlik/Tableau) is a plus
III. Benefits
- Opportunity to become fulltime employee after 3-months internship
- Receiving mentorship and training from experienced professionals
Share:
