Rio Anggara Sufilin

Collaborated with the data analytics team to integrate and manage datasets across warehouse and lakehouse systems. Designed and optimized ETL workflows using Apache Airflow and Apache Spark, enhancing automation, scheduling, and data reliability. Implemented a lakehouse architecture with MinIO and integrated Apache Druid for fast, interactive analytics.

Designed and maintained over 20 ETL pipelines using Apache Airflow for social media and ad platform data, supporting analytics for marketing clients. Built robust data warehouse architectures and developed Metabase dashboards for executive insights. Created FastAPI services and Pub/Sub streaming pipelines to ensure seamless data integration.

Collaborated cross-functionally to translate business needs into scalable data infrastructure solutions. Developed and optimized ETL pipelines with Apache Airflow for internal analytics platforms. Implemented user behavior tracking integrations using Segment and created Metabase dashboards to support performance monitoring and decision-making.

Architected ETL pipelines processing over 1M daily POS transactions and built real-time streaming data pipelines using Google Cloud Pub/Sub. Led a data warehouse migration from PostgreSQL to Google BigQuery, significantly improving query performance. Engineered REST APIs using FastAPI for seamless data delivery and upgraded Airflow infrastructure, boosting pipeline performance.

Designed a dimensional data warehouse with ETL pipelines managing over 1 billion retail records. Built automated pipeline workflows for KPI report generation and created a star schema architecture with optimized fact and dimension tables. Developed OLAP cube transformations to support multi-dimensional retail analytics.

Delivered data solutions to clients, collaborating with the business solutions team to meet diverse needs. Built and maintained a sandbox environment for data exploration and prototyping. Automated report generation processes and supported API backtesting with SQL, ensuring data integrity and reliability.

Conducted data analysis to support departmental strategies and goals. Designed and implemented dashboards for enhanced data visualization and reporting. Automated recurring reports, improving reporting efficiency by reducing manual intervention.

Grade: 3.47 GPA

Graduated with a 3.47 GPA. Studied Informatics Engineering, focusing on practical applications within the field.