40,000 40+ 50,000 50+ The client, a US-based mentor network, runs nationwide programs that pair mentors with people who need daily support. Yet critical data sat in two siloes: a legacy SQL store and Salesforce. The split created three urgent gaps No common keys tie Salesforce and SQL together, which resulted in duplicate or missing mentor records leading the staff to hunt through both databases and risk overlooking history A sluggish export-import routine pulled Salesforce data into SQL once a day driving manual effort that forced teams to lose hours each week building simple metrics Names, addresses, and IDs differ between sources as leaders questioned the numbers, slowing decisions and raising red flags with compliance reviewers for data risks Impact Delivered Migrated to a single master hub Cleaned with 0 duplicates Empowered with reliable data updates Full change logs help the client pass HIPAA checks with ease A new SQL Server hub now stores the golden record for every mentor Hub, Link, and Satellite tables keep history while preserving source-level detail Unique keys for each record end merge conflicts and speed look-ups Power BI dashboards surface up-to-date mentor counts, placements, and gaps without manual extracts Incremental jobs load, cleanse, and validate 1 M rows on a defined schedule
staff members for daily care programs
states’ presence across US
people benefit every year
years in operation
serving communities Business Case
Data Integration
Reporting
Data Quality
50 GB structured
data1 Million mentor
records500 + employees
Audit trails
locked in Our Solution
Central Master Repository
Data Vault Layer
Hash-Key Generation
Self-Service Analytics
ETL with SSIS
Tech Stack
Snowflake
Power BI
Salesforce
