o
ooikairu

Kai O

@ooikairu

Data Engineer

Malaysia
English, Chinese, Malay
About me
I am a Data Engineer with expertise in building scalable data pipelines, ETL/ELT workflows, and cloud architectures. I have a strong background in Business Analytics and experience across QAQC, consulting, and SAP systems. I specialize in Python, SQL, and Google Cloud Platform to deliver actionable insights.... Read more

Skills

o
ooikairu
Kai O
Offline • 
Average response time: 1 hour

See my services

BI Analytics
I will automate gcp data pipelines and cloud data integration

Work experience

Google

Data Engineer

Google • Full-time

Dec 2024 - Present1 yr 8 mos

- Built scalable SQL workflows using Dataform to enforce version control and data quality checks. - Optimized BigQuery analytics by implementing strategic partitioning, clustering, and materialized views. - Directed multi-stage ETL/ELT pipelines using Cloud Composer (Apache Airflow) for seamless dependency management. - Processed massive datasets by deploying Dataproc clusters to run optimized Apache Spark jobs. - Connected clean warehouse layers to analytics tools like Power BI and Tableau. - Empowered executive leadership and analysts with high-performing, real-time dashboards. - Reduced dashboard latency and query execution times for business users. - ncreased trust in reporting by automating testing and lineage documentation.