To meet growing operational demands, we needed a scalable data pipeline that could unify financial and property data from diverse sources like Salesforce, Google Sheets, and external APIs. The goal was to automate ingestion, enforce consistent transformation logic, and maintain high data quality. Equally important was enabling real-time access to key insights through dashboards, ensuring finance and operations teams could make fast, data-driven decisions without relying on manual reporting.