Senior Software Engineer
Root Insurance, Columbus, Ohio
May 2019-present
- Developed and maintained a Data Warehouse Build and Scheduling system sourcing from Amazon S3, various external APIs, and RDS instances and targeting Amazon Redshift, built using Ruby on Rails
- Designed serverless data processing pipelines using AWS Glue to ingest 100s of terabytes of semi-structured JSON policy rating data into AWS Redshift and develop ETL to load a rating data mart to be used by the Data Science, Analytics, and Actuarial Science teams
- Helped expand server and client implementations using Rails and React Native into new markets such as California, referencing state insurance laws and working closely with project managers, designers, and other engineers to increase total market population