Ichsanul Amal
Data Engineer / Analytics Engineer building reliable pipelines, data models, and measurable outcomes. Semarang, Indonesia LinkedIn | GitHub | Digital Garden
Summary
Experienced problem solver adept in leveraging information systems and business acumen to improve & optimize organizational value. Lifelong learner with strong tech skills, excels in teamwork, and quick to grasp concepts.
Experience
Data Engineer | Accenture
Sep 2024 – Present | Semarang, Indonesia
- Implemented data profiling and data quality checks across Hive, Oracle, PostgreSQL.
- Developed Python scripts, including Airflow DAGs, for ad-hoc ETL processes and system monitoring.
- Optimized PostgreSQL queries, functions, and stored procedures.
- Automated migration of ~4,000 configurations, eliminating manual effort.
- Developed datamarts and documented business lineage for DQ dashboards.
Database Engineer | NTI (Telkomsel’s Project)
Aug 2023 – Apr 2024 | Jakarta, Indonesia
- Developed and optimized data models for the Network Service Measurement & Benchmarking unit.
- Managed and monitored databases (BigQuery, PostgreSQL) and ETL pipelines using Airflow, improving data ingestion from various sources (databases, CSVs, REST APIs).
- Enhanced PostgreSQL performance through indexing, partitioning, and window analytic functions; created multi-function, stored procedures, and maintained FDW databases.
- Initiated data build tool (dbt) for modular SQL and faster development.
Research Intern | IR-NLP Lab CSUI
Feb 2023 – Jun 2023 | Depok, Indonesia
- Analyzed and integrated student feedback data from e-learning systems using Python.
- Performed aspect-based sentiment analysis and built a user-friendly dashboard to assess learning aspects.
- Designed, developed, and deployed web & database applications using Flask and integrating them with data visualization tools.
Data Engineer Intern | Traveloka
Aug 2022 – Dec 2022 | Tangerang, Indonesia
- Implemented data warehouse models for hotel and transport BU, utilizing SQL and dbt (data build tool).
- Migrated and optimized data warehouse assets using BigQuery and Python adhering to Kimball principles.
- Monitored ETL pipeline and performed data backfill using Airflow.
- Developed dashboards using Google Data Studio to monitor and optimize BigQuery resources.
Teaching Assistant | University of Indonesia
Sep 2020 – Jan 2022 | Depok, Indonesia
- Teaching Assistant for Fundamental Programming (Python), Calculus, and Operating System courses.
- Assess and assist the students with weekly lab sessions, assignment work, and assignment demos (interviews).
Education
University of Indonesia
Bachelor of Computer Science | Information Systems | 2019 – 2023 | Depok, Indonesia GPA: 3.77/4.0
Skills
- Languages: Python, JavaScript, Java
- Databases / DWH: PostgreSQL, BigQuery
- Orchestration / Transform: Airflow, dbt (Data Build Tool)
- Big Data / Streaming: Hadoop, Spark, Kafka
- Cloud: Google Cloud Platform (GCP)
- BI: Looker Studio
- AI: LangChain, Gemini CLI, Model Context Protocol
- Infra: Linux, Docker, Kubernetes
Certifications
- Data Engineering with AWS (Udacity)
- Generative AI (Udacity)