Financial Consulting Impact

A project to input individual checking, savings, and some credit card transactions into a reproducible pipeline and develop and report on key metrics.

The client offers financial consulting services to underserved individuals seeking financial independence. The financial company aims to help its clients get out of predatory debt, reduce their debt, and, in the long term, increase their income. They achieve this through financial coaching and, most recently, by asking clients to link their savings and checking accounts.

Once clients linked their accounts, the transaction data was stored in an AWS S3 bucket in a JSON format. I wrote an ELT data pipeline that pulled in the data, loaded the data, and transformed the data into the appropriate metrics. Throughout this process, we were able to identify business clients from non-business clients, separate clients with very few transactions to exclude from the computation of their metrics, and accurately include clients that were of interest for further learning. I enhanced their data pipeline to only pull in new records, reducing the lag to update the data.

The final deliverables were the data pipeline code and a reproducible report that calculates their metrics to evaluate how well the financial coaching is working for their clients.