# Mario Caesar

> Mario Caesar is a Senior Data Engineer in Indonesia building reliable data pipelines, warehouses, and data quality systems for finance, operations, and analytics.

Canonical page: https://caesarmar.io/

## Work experience

### Senior Data Engineer (Data Warehouse & Infrastructure) - Kredit Pintar Indonesia (Advance Intelligence Group)

Dec 2025 - Present

Built the warehouse pipelines behind Finance reconciliation and customer lifecycle reporting. Automated recurring escrow work and data requests, introduced validation and restartable processing, and made key datasets easier for Finance, Product, and Marketing teams to use each day.

Technologies: Scala / Spark, Data Warehousing, Data Quality, Reconciliation

[Company website](https://www.kreditpintar.com/)

### Senior Data Engineer (People Data) - Agoda

Mar 2025 - May 2025

Reworked Greenhouse and Bridge ingestion with parallel Python loading, SQL pre-fetching, and batched API requests, cutting runtimes from about 2.5 hours to 45 minutes and 3 hours to 30 minutes respectively. Mentored five analysts in Python and reviewed their ETL contributions for reliability and team standards.

Technologies: Python ETL, SQL Server, Parallel Ingestion

[Company website](https://www.agoda.com/)

### Mid-Data Engineer - Allo Bank Indonesia

Sep 2024 - Mar 2025

Consolidated around 20 reporting pipelines into a dbt workflow, reducing runtime from about 60 to 35 minutes, and rebuilt Business Summary ETL to deliver dashboards two hours earlier. Partnered with Data Operations on automated reconciliation checks and alerts, while tuning data marts for finance, risk, regulatory, and operational reporting.

Technologies: dbt Modeling, Airflow Checks, Regulatory Reporting

[Company website](https://www.allobank.com/)

### Data Engineer & Analytics - Krom Bank Indonesia (Kredivo Group)

Dec 2023 - Sep 2024

Built configuration-driven ingestion and automated schema propagation, reducing new-pipeline development effort by about two days and recurring schema failures from weekly to roughly once every three weeks. Established BigQuery PII classification and masking workflows with a one-day SLA, and onboarded around 10 source tables into Confluent CDC pipelines.

Technologies: CDC Pipelines, BigQuery, PII Governance

[Company website](https://krom.id/)

### Data Engineer & Analytics - FinAccel Teknologi Indonesia (Kredivo Group)

Jun 2022 - Dec 2023

Rebuilt Operations reporting with Airflow and PySpark, reducing runtime from 30 to 18 minutes while meeting its daily SLA. Migrated Freshdesk ingestion from AWS Lambda to GCP Cloud Functions with a separate operational datastore, and developed a governed collector-cost mart with stakeholder-validated metrics for monthly monitoring.

Technologies: PySpark ETL, GCP Functions, Event Streaming

[Company website](https://kredivocorp.com/)

## Public portfolio sections

- [Data engineering projects](https://caesarmar.io/projects/index.md)
- [Certifications & Credentials](https://caesarmar.io/certifications/index.md)
- [Mentoring, speaking and judging](https://caesarmar.io/mentoring-speaking/index.md)
- [Data Sketch](https://datasketch.caesarmar.io/index.md)