My name is Lily Song and I am a Backend & Data Engineer.
Backend & Data Engineering Experience
I am a Software Engineer specializing in backend development and data engineering.
At JPMorgan Chase, I primarily build and maintain backend systems for the flagship cashback rewards platform,
including a multi-tier rewards engine, real-time cashback notifications, and secure data pipelines
using AWS. I also manage CI/CD pipelines and Dockerized workflows, improving deployment efficiency and
accelerating feature delivery.
ETL & Full-Stack Development
Previously, I led data engineering initiatives at Booz Allen Hamilton and Bruker OST, designing
ETL pipelines with Databricks and Spark, building dashboards and analytics solutions, and automating workflows
to improve performance and scalability. I am also experienced in full-stack development using React, Node,
and Python, delivering web applications and tools that meet client and business needs.
Mechanical Engineering Foundation
My background as a Mechanical Engineer in the defense industry has strengthened my
ability to work under pressure, manage complex projects, and ensure high standards of quality and security.
Certifications & Skills
With certifications in Product Management, TensorFlow, PMI-ACP, and AWS,
I bring a diverse skill set and a proven ability to deliver innovative, efficient,
and reliable solutions.
Below are some of my personal coding projects:
Produced Housing Data Visualization by employing webscraping techniques to gather data from Zillow. Implemented an Airflow-based ETL pipeline to ensure the consistent ingestion of new data, organizing it into bronze, silver, and gold tables for enhanced analysis.
View Project
Email spam identifier made using Kaggle Dataset, trained by TensorFlow and deployed using Flask / Princess. Email is accessed via IMAP and marked as spam based on TensorFlow model.
Upon first load, the website will take a minute to load as the server is starting up.
View Project
Simulation made of a ball bouncing on impact with walls using React.
View Project
Visualizer made to help see the difference in speed between various time complexities.
View Project
Dashboard made using Django which includes user authenication. Users have easy access to create notes, a todo list, or search for google news on this dashboard.
View ProjectA todo app where users can share, edit, and delete tasks with ease. Users can use the messenger to communicate which task is assigned to who. This app was created using Expo, React Native, and Firebase.
Adoption queue made using Java and MySQL to demonstrate the queue data structure, FIFO or first in first out. This queue is based on which animal sat in line the longest, the type of animal, and it's gender.
A web application made using React, Node, and MSSQL where users can rate their dates. In the event that there are multiple reviews, every review can be displayed and the average rating is taken.
JPMorgan Chase, Software Engineer III - 11/2024 - Present
Booz Allen Hamilton, Lead Data Engineer - 04/2023 - 11/2024
Bruker OST, Data Science & Quality Engineer - 07/2021 - 04/2023
WisEngineering, Mechanical Engineer - 07/2019 - 07/2021
Pratt & Whitney, Structures Engineer - 09/2016 - 07/2019
General Dynamics Electric Boat, Mechanical Engineer - 08/2015 - 09/2016
PMI Agile Certified Practitioner (PMI-ACP), 01/2023
AWS Certified Cloud Practitioner, 10/2022
TensorFlow Developer Certificate, 09/2022
Cornell University, Product Management for Engineers Certificate - 08/2023
University of Connecticut, Masters of Engineering, Mechanical Engineering - 12/2018
Binghamton University, Bachelor of Science, Mechanical Engineering - 05/2015
Please fill out the form below if you wish to contact me.