Overview
Work History
Education
Skills
Timeline
Generic

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
Kenley AraiSr. Data Engineer