Analytics Engineer Intern
Jan 2025 - Aug 2025
Pandai
Federal Territory of Kuala Lumpur, Malaysia · Hybrid
-
Converted bronze to silver layer in medallion architecture using DBT into 10+ structured fact, dimension, junction, and hybrid tables.
-
Developed real time funnel chart in Metabase to track teacher engagement population of using chatbot AI feature.
-
Created and maintained 5+ Looker Studio dashboard projects with real-time data visualization, fixing scorecard streak issues and year filter configurations.
-
Delivered 50+ data service requests across 5+ departments, encompassing data extraction, ad hoc report, SQL query development, dashboard creation/optimization/fix in Looker Studio and Metabase to enable data-driven
decision making for marketing campaigns, sales initiatives, and business operations.
-
Developed an automated data quality check pipeline to validate row counts consistency across 50+ tables in MySQL, PostgreSQL, and BigQuery databases, using Apache Airflow and Docker containerization.
Data Management Analyst Intern
Mar 2024 - May 2024
Telkom University Information Systems Major Department
Bandung, West Java, Indonesia · Remote
-
Designed and developed a real-time dashboard to visualize data for over 50 students in the Information Systems International Class using Microsoft Excel through Pivot Table, COUNTIF, and UNIQUE formulas.
- Supported the development of data documentation and database management including name, entry year, student ID, international exposure, university partner, and country operating Microsoft Forms, ensuring seamless integration of incoming data with the dashboard for real time updates.
