Introduction
Founded in 1894, the Jewish Social Services Agency (JSSA) is a health and social wellness agency that has become a cornerstone of support in Maryland and the wider National Capital Region. With over 400 employees delivering mental health, senior care, disability support, hospice, adoption, foster care, and transportation services, JSSA needed a modern data infrastructure. To keep pace with growing demand and complexity, the organisation turned to WhereScape to automate its data warehouse and improve operational efficiency.
Pre-WhereScape Challenges
- Manual, fragmented processes: Disparate systems required extensive manual loading, transforming, and maintenance by a single data analyst.
- Risk of increasing staffing costs: Growing data demands suggested new analyst and developer hires that would significantly increase operational costs.
- Slow, labour-intensive reporting: Lack of automation and growing raw data volume made timely reporting and accurate insight difficult.
- Limited scalability: Increasing data complexity and expanding services strained JSSA’s existing, largely manual data infrastructure.
“You’re paying a developer. You’re paying a data analyst. You’re paying a business analyst. That’s going to be a lot.”
– Damilola Benedict, Data Analyst, JSSA
Why WhereScape?
JSSA chose WhereScape to cleanse and automate its data infrastructure and to replace manual, error-prone processes with repeatable, managed workflows. WhereScape RED allowed the organisation to redesign its data warehouse, centralise transformation logic, and reduce the effort needed to maintain millions of lines of code. This meant JSSA could keep pace with its mission-driven growth without constantly expanding the data team.
“It served to get my data structure clean. You have millions of lines of code. Now you can just change that once without going in and changing one after another.”
– Damilola Benedict, Data Analyst, JSSA
The Solution
Automated Data Warehouse Design
WhereScape RED automated the design and development of JSSA’s data warehouse, replacing hand-coded pipelines with generated, reusable processes that are easier to manage and extend as needs evolve.
Clean, Centralised Data Structure
By using WhereScape to clean and standardise data structures, JSSA consolidated logic that previously lived in many places. Central rules and transformations now underpin all reporting, reducing errors and duplication.
Scheduled Workflows and Orchestration
JSSA used WhereScape RED to schedule and execute data transformations and load operations automatically. This orchestration freed the team from repetitive maintenance and enabled more reliable, timely refresh cycles.
Reporting That Grows With the Organisation
With automated pipelines in place, JSSA can now produce accurate reports for hospitals, finance, HR, program management, and leadership. The data warehouse is built to grow alongside the organisation without sacrificing performance.
“It’s been life-changing… It serves so many purposes, it’s been a great experience.”
– Damilola Benedict, Data Analyst, JSSA
Results
🚀 Operational Efficiency Gains
- Manual coding and one-off scripts replaced by automated workflows.
- Data analyst time redirected from maintenance to strategic analysis.
- Stakeholders now receive more timely and reliable reports.
🚀 Cost Savings and Resource Optimisation
- Automation reduced the need to hire additional analysts and developers.
- Budget can be redirected into core community services and programs.
- Lower ongoing maintenance effort for the data environment.
🚀 Scalable, Future-Ready Data Platform
- WhereScape RED scales with increasing data volumes and complexity.
- New data sources can be onboarded without rebuilding pipelines.
- Performance and reliability are maintained as usage grows.
🚀 Data-Driven Culture Across the Agency
- Non-technical users can access curated data and insights more easily.
- Program leaders gain better visibility into outcomes and operations.
- Data is now treated as a strategic asset for service planning.
“You don’t have to be a developer to load, transform, and store your data”
– Damilola Benedict, Data Analyst, JSSA
Supporting a Complex Service Portfolio
JSSA’s services span mental health, senior care, disability support, hospice care, adoption, foster care, and transportation. Each service line generates different types of operational and clinical data. WhereScape’s automation capabilities help bring this complex information together into a coherent data warehouse, making it easier to understand how programs are performing and where resources are most needed.
From Manual Effort to Strategic Insight
Before WhereScape, much of JSSA’s data work was focused on simply loading and transforming data from disparate systems. By automating these processes, JSSA’s data analyst can spend more time exploring trends, supporting leadership with insight, and helping teams across the agency make decisions backed by accurate data.
Building Confidence in Data
Automated, repeatable processes have improved trust in JSSA’s reports. Teams across finance, HR, hospitals, and program management know that their data is sourced from a consistent structure with well-managed logic, making it easier to compare outcomes across services and over time.
Data as a Long-Term Asset
WhereScape RED has transformed JSSA’s approach to data from a necessary operational burden into a long-term strategic asset. As the agency grows and community needs evolve, the underlying data warehouse can adapt quickly—keeping the focus on delivering care rather than wrestling with code.
