Lawrence Lai
Senior Data Engineer
Boston, Massachusetts, United States
Summary
👤
Senior🎓
Top SchoolLawrence Lai is a Senior Data Engineer with 11 years of experience building and optimizing ETL pipelines, data warehouses, and ingestion tools for biopharma and agtech at PatientsLikeMe, Indigo Ag, and John Burns Research. He brings deep expertise in PySpark, Airflow, Snowflake/dbt, AWS, and high-volume data processing at the gigabyte-to-terabyte scale, having designed and maintained 100+ schema tables and hundreds of ETL tasks. A PhD-trained chemical engineer from MIT, he blends rigorous computational modeling and statistical methods with production data engineering to support biological and geospatial research. He’s delivered data-driven UIs and ingestion apps (Plotly Dash, Rails/React) and automated legacy migrations to cloud platforms. Outside of engineering he’s a 1st Dan Taekwondo black belt, reflecting a disciplined, experimentation-driven approach to problem solving.
11 years of coding experience
5 years of employment as a software developer
Doctor of Philosophy - PhD Chemical Engineering, Doctor of Philosophy - PhD Chemical Engineering at Massachusetts Institute of TechnologyBachelor of Science - BS Chemical Engineering, Bachelor of Science - BS Chemical Engineering at University of Michigan
Chinese, English
Github Skills (30)
kinetics10
reaction10
chemistry10
thermodynamics10
systems-biology10
mechanism10
chemical-engineering9
materials-informatics9
python9
database9
warehouse2
postgresql2
data-warehouse2
spark2
prototyping2
Programming languages (5)
Github contributions (5)
laitcl/ChatroomAnalytics
Jun 2019 - Jul 2019
Lawrence Lai Insight Data Engineering Project
Contributions:27 commits, 6 PRs, 45 pushes in 19 days
laiwarehouseinsight-data-engineeringdata-engineeringspark
laitcl/laitcl-Website
May 2018 - May 2024
Personal Website
Contributions:12 PRs, 40 pushes, 6 branches in 6 years
react
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.