CMS provider data pipeline
Python ETL that loads nursing home provider data from data.cms.gov into SQL Server. Each run checks the latest processing date and loads only new data.
- Python
- SQL Server
- REST API
Data engineering · Analytics · Finance
Joseph Benichou
I build the pipelines that bring data in, the reports teams run every day, and the financial analysis built on them. Since 2022 I've done that for a network of about 50 skilled nursing and assisted living facilities. Before that I worked in treasury, so I know what finance needs from the numbers.
- Based in
- Great Neck, NY
- Now
- Centers Health Care, since 2022
- Before
- Treasury for 18 nursing homes
- Degree
- B.S. Finance, Yeshiva University
- Stack
- SQL Server, SSRS, Python, Power BI
Impact
Manual work, before and after
Hours per cycle for finance processes I rebuilt with SQL, Python, and SSRS.
| Process | Before | After | Saved |
|---|---|---|---|
| Every month | |||
| Health insurance invoicingAbout 50 facilities | 32 hrs | 2 hrs | 30 hrs |
| Accounts payable run100+ vendor cash files | 8 hrs | 1 hr | 7 hrs |
| Monthly total | 40 hrs | 3 hrs | 37 hrs |
| Each cost-report cycle | |||
| RHCF cost report prep15 reports per facility, 50 facilities | ~1 week | < 2 hrs | ~1 week |
Tens of thousands
of dollars a year in incorrect billing stopped by compliance checks that flag inactive employees and duplicate facility charges.
$100K+
in owed funds recovered as a Treasury Analyst by working through HUD loan agreements, required facility improvements, and reimbursement approvals.
Selected work
What I've built
Grouped by the kind of work. Most of it was built at Centers Health Care for finance, quality, and operations teams.
Data engineering
Pipelines, integrations, and automation that move data from source systems into clean tables and finished files.
Accounts payable automation
Python and SQL pipeline that produces 100+ vendor-specific cash management files each month and removes most manual data entry.
- Python
- SQL Server
Health insurance invoicing
Matches provider files to internal SQL data through crosswalk tables, then generates SSRS invoices for about 50 facilities. Compliance checks flag inactive employees and duplicate facility charges before invoices go out.
- SQL Server
- SSRS
Adult day care census
Python script on the Jotform API that gives 9 adult day care centers a real-time census, replacing daily Excel tracking and monthly recaps, with automated reminder emails.
- Python
- Jotform API
Also: a PBJ staff-turnover workflow with an exclusion table, prefilled review links, approval routing, and email reminders, and an insurance eligibility check that tests hours across three rolling weeks.
Analytics and reporting
Reports, audits, and analysis that answer a specific question for the people making the decision.
Star Ratings monthly reporting
Automated monthly CMS Star Ratings reporting with comparisons against 1, 12, and 24 months earlier. Tracks measure changes such as the planned FY2028 removal of the healthcare personnel and resident vaccination measures.
Inspection scoring audit
Recalculated health inspection scores for New York facilities using CMS methodology and found three calculation errors: Cycle 2 weighting, IDR-flagged citations, and an excluded F-tag. Also replicated Special Focus Facility scoring and the Five-Star staffing domain.
- Excel
Medicare LOS, monthly In QA
Multi-facility Medicare SNF length-of-stay report with rolling three-month benchmarks and readmissions built into the stay logic.
- SQL Server
- SSRS
Brooklyn crash analysis
Analyzed 496,632 NYPD-reported collisions in Brooklyn from 2012 to 2026 and turned them into recommendations for a city council audience: leading causes, crash timing, the worst ZIP codes and streets, and vehicle mix.
- NYC Open Data
Also: Power BI reports built with bookmarks and field parameters, weekly overtime reporting in SSRS, a PCC lab-orders dashboard, and antipsychotic-rate and discharge-to-home reporting.
Finance
Valuation, treasury, and cost reporting where the numbers have to tie out.
SEC to Excel DCF tool
Python tool that turns a ticker into an 8-sheet Excel DCF built from SEC filings, with every forecast cell a live formula. Run end to end on Apple, Costco, P&G, and Ensign.
- Python
- SEC EDGAR API
- Excel
Treasury and cash management
At Plainview Healthcare Partners: weekly cash-flow analysis for the CFO across 18 nursing homes, 30+ wire and ACH transfers a day, and $100K+ in owed funds recovered through HUD loan agreement review.
- Bill.com
- Intacct
- Excel
RHCF cost report
Fifteen SQL queries formatted in SSRS for Excel upload, replacing 15 hand-built reports per facility across 50 facilities.
- SQL Server
- SSRS
- Excel
Nursing home REIT tenant quality In progress
Matching the operators behind Omega, Sabra, and CareTrust to CMS quality data to test whether star ratings and staffing show up in the rent coverage those REITs report.
- Python
- SEC filings
- CMS data
Also: a cost audit of more than 450 shared mailboxes for the CFO, using a Jotform delegate review.
Side project · Live
Keviut קביעות
A free web app for keeping a daily Torah learning schedule. Pick a program, mark each day learned or missed, see exactly where to pick back up, and count chazarah (review).
I designed and launched it on my own domain, hosted on Cloudflare Pages.
Open Keviut.com ↗Programs
- Daf Yomi
- Amud Yomi
- Oraysa
- Mishnah Yomit
- Nach Yomi
- Shnayim Mikra
- Halacha
- Custom plans
In the app
Experience
Where I've worked
2022 – Present
Senior Data Analyst
Centers Health Care · New York, NY · Promoted Feb 2025, Data Analyst Feb 2022 – Jan 2025
- Build interactive reports in SSRS Report Builder that support decisions across multiple departments.
- Run ad hoc analysis in SQL, Python, and Excel for cross-functional teams.
- Mentor junior analysts and delegate projects to keep delivery on time.
2021 – 2022
Treasury Analyst
Plainview Healthcare Partners · Lynbrook, NY
- Managed bank accounts and delivered weekly cash-flow analysis to the CFO and Controller across 18 nursing homes.
- Executed 30+ wire and ACH transfers a day, from thousands to millions of dollars.
- Streamlined invoicing and billing for about 30 entities in Bill.com and Intacct.
- Recovered more than $100K in owed funds through HUD loan agreement review and reimbursement approvals.
2015 – 2017
Earlier, in finance
- Investment Banking Summer Analyst Sunrise Securities, 2017
- Sales Intern Fortis Lux Financial of MassMutual, 2016
- Operations Intern E1 Asset Management, 2015
Education
Education and training
- Yeshiva University, Sy Syms School of BusinessB.S. Finance, minor in Economics, 2019 · GPA 3.5 · NCAA golf and volleyball
- Adkins Matchett & ToyFinancial Modeling and Valuation, summers 2015 and 2016 · DCF, LBO, M&A, trading comparables
- Aish HaTorah, JerusalemTalmudic Law, 2018 – 2020
Toolkit
Toolkit
- Data engineeringPython (pandas, pyodbc, openpyxl), REST APIs, SQL Server stored procedures, incremental loads, data quality checks
- Analytics and BISQL (window functions, temp tables), SSRS Report Builder, Power BI (bookmarks, field parameters), Excel
- FinanceFinancial modeling and valuation (DCF, LBO, comps), cash management, cost reporting, Bill.com, Intacct
- LanguagesEnglish, French, Hebrew (basic)