Jonathan
Santoso
Analytics Engineer · Senior Data Analyst
Experience
Senior Data Analyst — PT Sunday Insurance Indonesia, Jakarta
- ›Built a dbt-based data warehouse from scratch, replacing manual Excel processes that took the business team 4–6 hours daily — reducing processing time to under 10 minutes per entity and enabling cross-functional access for underwriting, claims, and marketing teams.
- ›Automated monthly performance reporting across key insurance metrics — Gross Written Premium, Net Written Premium, ceded premium, and loss ratio — eliminating 4–6 hours of manual preparation per cycle.
- ›Developed Tableau dashboards used directly by the Board of Directors, covering loss ratio, net premium, and reinsurance performance across general and health insurance lines.
- ›Served as the primary data point of contact for the Board of Directors, delivering weekly portfolio reviews and ad-hoc analysis on active accounts and loss ratio performance.
- ›Modelled insurance data in dbt covering health plan utilization, general insurance performance (motor, engineering, marine cargo), and reinsurance metrics — replacing manual vlookup-based Excel workflows.
- ›Prepared and maintained accurate business performance data across key financial and operational metrics to support strategic decision-making.
Business Intelligence Analyst — PT Freeport Indonesia, Jakarta
- ›Contributed to a legacy on-premise Teradata to Snowflake cloud migration, enhancing and building ETL pipelines to support scalable data infrastructure across mining operations.
- ›Built and maintained data mart layers using SAP BusinessObjects Universe, developing specialized reports monitoring equipment performance, crew efficiency, and operational KPIs for the underground mining (UOMS) division.
- ›Developed Power BI dashboards for the dewatering operations team, monitoring pump usage and performance metrics across mining operations.
- ›Participated in daily scrum ceremonies as part of the UOMS project, maintaining alignment on delivery timelines across cross-functional mining operations teams.
Projects
Production Tools
Pharma Price Optimizer
Compares drug prices across three online pharmacies against a regulatory price database to surface the best deal for each product.
Motor Insurance Price Crawler
Scheduled scraper that pulls motor-insurance premium rates from insurer APIs and stores structured results in Excel for competitive analysis.
Health Claim Data Puller
Browser-automation tool that logs into a legacy health-claim portal, extracts claim records, and surfaces them through a Streamlit UI.
User Export Automation
Fetches filtered user-data exports from Metabase, applies business rules, formats Excel output, and uploads the results to Google Drive automatically.
Claims Portal Scraper
Scrapes a ColdFusion-based claims portal, syncs records to PostgreSQL, and provides a Streamlit dashboard for claim status tracking.
NAS → Cloud Sync
Mounts a network-attached storage share over SMB and mirrors new or changed files to Google Drive, logging every transfer to Google Sheets.
Claim Report Pipeline
Reads claim reports from Gmail, computes period-over-period diffs, and drafts summary emails with Google Drive attachment links for review.
Monthly Report Tool
End-to-end monthly reporting tool that pulls data from Metabase, generates Excel pivot summaries, and presents a Streamlit interface for review.
Data, Analytics & Earlier Work
Bitter-Pill Pharmacy Data Warehouse
End-to-end data warehouse for a fictional pharmacy chain: SSIS ETL pipelines, OLAP cube, and pivot-table reporting on sales and inventory.
IMDb Movies Dashboard
Interactive Power BI dashboard exploring IMDb ratings, genres, and trends across thousands of film titles.
COVID-19 Indonesia Dashboard
Power BI dashboard tracking daily confirmed cases, recoveries, and fatalities across provinces in Indonesia through September 2021.
Retail SQL Query Project
Collection of DQL (Data Query Language) queries against a retail database — joins, aggregations, subqueries, and window functions.
Company Database Design
Designed and implemented a relational database for a company with full ERD, DDL schema, DML seed data, and SELECT query demonstrations.
SQL LeetCode Solutions
Solutions to 25+ SQL problems on LeetCode covering joins, ranking functions, aggregations, and date logic — organised by problem number.
Data Engineering Zoomcamp
Week-1 homework from the DataTalks.Club Data Engineering Zoomcamp: containerised data ingestion pipeline loading NYC taxi data into PostgreSQL.
MLBB Meta Advisor
AI-powered web app for Mobile Legends: Bang Bang — recommends hero picks and counter-picks based on the current patch meta.
Point of Sale (POS) App
Desktop POS application for retail stores built with Java Swing and MySQL — handles sales entry, stock updates, and user login.
Game Catalog (Stim)
Java desktop app for browsing and managing a game library with MySQL persistence — built as a university project.
Skills
Languages & Query
Cloud & Warehouse
BI & Reporting
Engineering
Certifications & Publication
Power BI Data Analyst Associate
Microsoft Certified
Azure Data Fundamentals
Microsoft Certified
Certified Data Analyst
Tableau
Python Essentials 1
Cisco
Foundations: Data, Data, Everywhere
Sentiment Analysis on Google Play Store User Reviews of Digital Bank Applications in Indonesia
Springer · March 2024