Implementasi Arsitektur Medallion Open-source untuk Analisis Komparatif Tech Layoffs Global
DOI:
https://doi.org/10.61124/sinta.v3i2.243Keywords:
arsitektur medallion, compound join key, data warehouse, DBT, tech layoffsAbstract
Ekosistem startup Indonesia yang bergantung pada pendanaan ventura asing rentan terhadap gelombang tech layoffs global, tetapi analisisnya kerap terhambat inkonsistensi data geospasial dan biaya infrastruktur cloud yang tinggi. Penelitian ini bertujuan menunjukkan bahwa kombinasi open-source PostgreSQL dan Data Build Tool (DBT) berbasis Arsitektur Medallion mampu menghasilkan analisis komparatif PHK teknologi Indonesia dan global secara akurat tanpa platform berbayar. Metode ELT (Extract, Load, Transform) diterapkan dengan novelty berupa strategi compound join key untuk mengeliminasi anomali duplikasi baris (Cartesian product) akibat ketidakseragaman koordinat geospasial. Sistem berhasil mengeksekusi delapan model data dalam 1,19 detik dengan tingkat keberhasilan uji kualitas 100% (24/24 pengujian) dan zero row inflation. Hasil analisis mengungkap karakteristik spesifik PHK di Indonesia berupa dominasi sektor Transportation sebesar 76,81% dari total 2.721 pekerja yang tersentralisasi di Jakarta, berbeda signifikan dari pola global yang terdiversifikasi pada sektor Consumer dan Retail. Penelitian ini menunjukkan bahwa infrastruktur open-source berbasis PostgreSQL dan DBT mampu menghasilkan performa analitik yang andal dan efisien untuk mendukung analisis komparatif PHK teknologi serta mengidentifikasi konsentrasi kerentanan ekosistem digital nasional pada wilayah tertentu.
References
A. Eweje and F. Ohaegbu, “Advances in Modern Data Stack Architectures for Scalable Data Integration and Business Intelligence,” Int. J. Multidiscip. Res. Growth Eval., vol. 2, no. 5, pp. 538–550, 2021, doi: 10.54660/.IJMRGE.2021.2.5.538-550.
S. R. Cheruku, S. Jain, and A. Aggarwal, “Building Scalable Data Warehouses: Best Practices and Case Studies,” Darpan Int. Res. Anal., vol. 12, no. 01, pp. 80–99, 2024, doi: 10.36676/dira.v12.i1.87.
S. Pasupuleti, “The Medallion Architecture in Data Engineering : A Layered Approach to Data Quality and Governance,” J. Inf. Syst. Eng. Manag., vol. 10, no. 62s, pp. 131–137, 2025, doi: 10.52783/jisem.v10i62s.13557.
R. Lakshmanasamy and G. Ganachari, “Integration of Dbt With Modern Data Stack Technologies,” Int. J. Multidiscip. Res., vol. 5, no. 5, pp. 1–6, 2023, doi: 10.36948/ijfmr.2023.v05i05.19750.
R. Lee, “layoffs.fyi.” [Online]. Available: https://layoffs.fyi/
R. Vale, “Forecasting the 2022-23 tech layoffs using epidemiological models,” pp. 1–8, 2023, doi: 10.48550/arXiv.2305.05210.
M. Armbrust, A. Ghodsi, R. Xin, and M. Zaharia, “Lakehouse : A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics,” in 11th Annual Conference on Innovative Data Systems Research (CIDR ’21), CIDR Association, 2021. [Online]. Available: https://www.semanticscholar.org/paper/Lakehouse%3A-A-New-Generation-of-Open-Platforms-that-Zaharia-Ghodsi/451cf5fc9786ed4f7e1d9877f08d00f8b1262121
A. Safyan, M. U. Khan, M. Soomro, N. Sheikh, A. Rehman, and M. R. Tahir, “CLOUD-NATIVE DATA WAREHOUSING SOLUTIONS: ENHANCING SCALABILITY, SECURITY, AND PERFORMANCE IN BIG DATA ECOSYSTEMS,” Kashf J. Multidiscip. Res., vol. 09, no. 09, pp. 1–17, 2025, doi: 10.71146/kjmr603.
S. Salami, “Hub Star Modeling 2.0 for Medallion Architecture,” 2025, doi: doi.org/10.48550/arXiv.2504.08788.
A. Mayer, “BOOM AND BUST: JOB CHURN IN THE TECHNOLOGY INDUSTRY IN THE COVID-19 PANDEMIC ERA,” 2023. [Online]. Available: https://scholarship.claremont.edu/scripps_theses/2046/
K. A. Hartono, M. I. Fianty, J. A. William, and J. C. Saputra, “Visualisasi Dinamika PHK Global dan Regional Menggunakan Tableau: Dampak Teknologi dan Ekonomi di Era Globalisasi,” J. Inform. dan Teknol., vol. 7, no. 2, pp. 521–532, 2024, doi: 10.29408/jit.v7i2.26487.
P. Hutabalian, B. R. P. Ginting, M. Q. Zaidan, N. Alfisyahrina, and C. Rozikin, “IMPLEMENTASI PIPELINE ETL/ELT DAN MODEL DIMENSIONAL UNTUK ANALISIS PENJUALAN SHOPEE MENGGUNAKAN POSTGRESQL, DOCKER, DAN APACHE SUPERTSET,” J. Inform. dan Tek. Elektro Terap., vol. 13, no. 3, pp. 1321–1332, 2025, doi: 10.23960/jitet.v13i3S1.8093.
P. K. R. Gujjala, “Optimizing ETL Pipelines with Delta Lake and Medallion Architecture : A Scalable Approach for Large-Scale Data,” Int. J. Multidiscip. Res., vol. 6, no. 6, pp. 1–8, 2024, doi: 10.36948/ijfmr.2024.v06i06.55445.
L. Kaptsov, “Applying Postgis for Storage and Processing of Geospatial Data in Logistics System,” Am. J. Eng. Technol., vol. 07, no. 318, pp. 318–327, 2025, doi: 10.37547/tajet/Volume07Issue08-28.
N. R. Ni’mah, A. Larasati, C. N. Laksana, and E. Mohamad, “Business Intelligence System Design Based on Performance Monitoring Dashboard Using Online Analytical Processing (OLAP) Method,” J. Ilm. Tek. Ind., vol. 23, no. 2, pp. 191–204, 2024, doi: 10.23917/jiti.v23i02.6016.
S. Garudasu, I. Khan, and M. M. K. Dandu, “The Role of CI / CD Pipelines in Modern Data Engineering : Automating Deployments for Analytics and Data Science Teams,” IRE Journals, vol. 5, no. 3, pp. 187–201, 2021, [Online]. Available: https://www.researchgate.net/publication/389435463_The_Role_of_CICD_Pipelines_in_Modern_Data_Engineering_Automating_Deployments_for_Analytics_and_Data_Science_Teams
K. Rabuzin, M. Cerjan, and A. Lovrenčić, “Data Warehouse Design – Star Schema Synthesis Algorithm,” TEM J., vol. 14, no. 2, pp. 1707–1714, 2025, doi: https://doi.org/10.18421/TEM142-68.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Abdulhadi Muntashir, Firdaus Satrio Utomo, Rendy Ilyasa, Gladys Andromeda Bilqis, Mohamad Hilman
This work is licensed under a Creative Commons Attribution 4.0 International License.
