About Client
The client is a billion-dollar home leasing company with an estimated 100,000+ rental homes across the United States.
Background
Home leasing companies heavily rely on data to manage properties, tenant info, finances, and maintenance schedules. Efficient data management ensures organized, accessible, and secure information for seamless operations. Legacy systems like SQL Server have been valuable tools in managing large datasets and performing complex queries. However, as data volumes and the need for real-time analytics increased, these systems faced limitations in processing speed and scalability.
Cloud-based solutions like Snowflake help in resolving these issues. By leveraging the scalability and elasticity of the cloud, Snowflake enables home leasing companies to process large volumes of data rapidly and efficiently. Snowflake’s scalability and optimization empower companies to extract actionable insights efficiently, improving decision-making and operational effectiveness.
Challenges
- Complexity in Maintenance: Managing and optimizing the SQL Server-based EDW, including legacy Microsoft server stack like SSIS (SQL Server Integration Services)was a complex and time-consuming processes
- Performance and Scalability: The scalability of SQL Server was restricted, with its resources shared among analysts and data engineers. When multiple users access it simultaneously, performance suffers, leading to delays in resolving queries and other issues for users
- Operational Costs: The operational costs associated with maintaining and upgrading the SQL Server EDW were high, with estimates reaching approximately $250K, annually
