Analytics Engineer

Lee Kang Jie

Engineering data solutions for a cleaner world.

Lee Kang Jie

About

I am an Analytics Engineer with experience in minimising costs and operational disruption for fleet electrification through advanced analytics. My passion lies in creating innovative products and leveraging my engineering expertise to make a tangible environmental impact.

I specialise in building scalable data models and performing data transformation using SQL, Python, and modern stack such as dbt, AWS, and Docker. I am highly cross-functional and adaptable, with experience leading a social enterprise and working in fast-paced startup environments.

In my recent role, I delivered end-to-end analytics solutions for customers, spanning from gathering customer requirements and data harvesting to data transformation and building dashboards for web applications. My key achievements include refactoring 30+ dbt models to eliminate after-hours processing and deploying optimisation models that informed decisions worth up to £2.5M per fleet. I also implemented a data quality framework that combined metadata tracking, validation checks, and source auditing to improve the accuracy, transparency, and reliability of the analytics.

Tech Stack

Python dbt AWS Docker PostgreSQL Snowflake Databricks