Kenley Arai
Sr. Data Engineer
City of Los Angeles,CA
Overview
12
12
years of professional experience
3
3
years of post-secondary education
Work History
Senior Data Engineer
PeerStreet, El Segundo, CA
09.2021
- Identified and refactored sub-optimal PostgreSQL CTEs usage reducing ETL runtime by ~200x
- Researched DocGen product discovering $400,000,000 in new supply
- Lead development of core company data marts using DBT
- Implemented 100% test coverage across all models creating data marts
- Standardized column naming, null values, and time zones reducing data inconsistency to 0%
Data Engineer / Data Analyst
PeerStreet, El Segundo, CA
06.2019 - 09.2021
Engineered and maintained Reverse ETLs using Data Build Tool (DBT) and Fivetran
- Refactored Legacy Airflow ETLs to DBT increasing uptime to 99%
- Developed an AVM (Automated Valuation Model) that estimates the pricing and demand for various zip codes and neighborhoods
- Responsible for calculating, and maintaining key metrics as Lead Product Data Analyst for financial operations, such as volume, revenue, and property count.
- Managed data team for monthly KPI reporting to find insights and actively drive business decisions
Data Engineer
Immersion Neuroscience, Claremont, CA
01.2017 - 06.2019
- Developed analytic tools using Python scientific libraries (e.g Pandas) for laboratory experiments to measure individuals' physiological responses.
- Integrated sensor data cloud upload for real-time physiological sensors data reading.
- Leveraged machine learning experience to clean and process collected data.
Software Engineer
C3 Business Solutions, Santa Ana, CA
06.2017 - 09.2017
- Developed CRUD (Create, Read, Update, Delete) applications using JSP for user portals.
Research Assistant
University Of California, Riverside (Data Mining Lab)
01.2015 - 01.2017
- Integrated cloud storage enabling sensor data to be accessed anywhere in the world in real-time.
- Improved sensor signal quality by 90% in 2015 by changing the light spectrum of the sensor.
Systems Engineer
Phillips, Fractor & CO, Pasadena, CA
01.2009 - 01.2014
- Took initiative to integrate New Relic into each application to monitor and increase stability for user experience.
Education
Bachelor of Science - Computer Science & Computer Engineering
University of California, Riverside
Riverside, CA 05.2014 - 06.2017
Skills
Python
SQL
Data Build Tool (DBT)
PostgreSQL
Data Warehousing
Data Orchestration
Extract, Transform, and Load (ETL)
Reverse ELT
Pandas
Airflow
Data Analytics
Applied Machine Learning
Snowflake
Timeline
Senior Data Engineer
PeerStreet, El Segundo, CA
09.2021
Data Engineer / Data Analyst
PeerStreet, El Segundo, CA
06.2019 - 09.2021
Software Engineer
C3 Business Solutions, Santa Ana, CA
06.2017 - 09.2017
Data Engineer
Immersion Neuroscience, Claremont, CA
01.2017 - 06.2019
Research Assistant
University Of California, Riverside (Data Mining Lab)
01.2015 - 01.2017
Bachelor of Science - Computer Science & Computer Engineering
University of California, Riverside
05.2014 - 06.2017
Systems Engineer
Phillips, Fractor & CO, Pasadena, CA
01.2009 - 01.2014