Automating Data Processing and Migration for a Global Real Estate Platform
DBB Software built a fully automated data pipeline for JLL's commercial real estate platform, replacing manual dataset refresh workflows with event-driven Azure Functions that pull, process, validate, and publish property data without human intervention.
Industry
Real Estate & Property Management
Service
Infrastructure Services
Team
2 Full-Stack Engineers, 1 QA Engineer
Project State
March 2020 - 2021
Country
United States
About the Client
Our client, Jones Lang LaSalle (JLL), is a global leader in commercial real estate services. As a Fortune 500 company, JLL provides property management, investment management, and development services across 80 countries, employing over 91,000 people. Their goal is to shape the future of real estate with innovative, technology-driven solutions.
The Client's Initial Request
JLL engaged DBB Software to automate the pipelines that pull and process a large real estate property dataset, replacing a manual process that required managers to submit refresh requests whenever data updates were needed.
Pipeline Automation
Replace the manual, request-based dataset refresh process with a fully automated pipeline that pulls, processes, and publishes property data on a defined schedule and in response to events
01
Data Transformation and Validation
Ensure incoming datasets are properly transformed, validated, and unified before reaching the platform, reducing errors and inconsistencies in property listings
02
Operational Efficiency
Eliminate the need for managers to manually trigger dataset refreshes, freeing teams to focus on higher-value tasks instead of routine data management
03
Data Freshness
Guarantee that the platform always serves up-to-date property information by automating the entire data lifecycle from source to production
04
Solutions We Delivered
DBB Software designed and implemented a new automated process workflow that handles the full data lifecycle, from pulling source data through transformation and validation to publishing refreshed datasets, using event-driven and time-scheduled Azure Functions:
Automated Data Pull Pipeline
The team established time-scheduled Azure Functions that automatically pull the real estate property dataset from source systems on a defined cadence. This replaced the previous workflow, where managers had to manually raise a request each time the dataset needed refreshing, ensuring data was always current without human intervention.
Event-Driven Processing and Transformation
When a new dataset is uploaded to Azure Storage as a blob, event-based triggers automatically invoke transformation and processing functions. These Azure Functions handle data migration, normalization, and unification, converting raw source data into a consistent format that the platform can consume.
Validation and Quality Assurance
Built-in validation steps within the pipeline ensure that every dataset refresh meets data quality standards before being published to production. This automated quality gate catches inconsistencies and errors that previously went undetected in the manual process, improving the reliability of property listings across the platform.
Results Achieved
Fully Automated Data Pipeline
The entire dataset lifecycle, pull, process, validate, and refresh, runs without manual intervention, replacing a request-based workflow that depended on managers raising tickets for each update.
Eliminated Manual Workload
Property managers no longer need to submit requests to refresh datasets. The automated pipeline handles scheduled and event-triggered updates, freeing teams to focus on higher-value operations.
Always Up-to-Date Property Data
Automated scheduling and event-driven triggers ensure the platform delivers up-to-date property information, eliminating the delays inherent in the previous manual refresh cycle.
Improved Regional Performance
Automated transformation and validation steps standardize incoming data and catch errors before they reach production, reducing data quality issues across the platform's property listings.
Automate Your Data Workflows for Faster, Cleaner Results
Replace manual data processes with automated pipelines that keep your platform accurate and up to date.
Contact Us
"Our 10 years of expertise are embedded in our pre-built solutions, so you don’t need to start from scratch. We set everything up 50% faster.
Interested? Fill out the form and book a free consultation!”
Mina Morkos
Business Development Manager
