DataSF (City & County of San Francisco) | Senior Data Engineer | Hybrid (in San Francisco) | Full-time | $156k-$196k
DataSF is looking for a Senior Data Engineer to help us build out the city's central Snowflake platform, which will ultimately power the majority of SF's analytics, open data, and ML efforts. This role is a mix of data infrastructure (CI/CD, terraform), building pipelines (ADF, dbt, Python), and platform eng and admin (Snowflake). See the position description for more info.
We're looking for folks with:
- Strong SQL and Python skills
- Deep data modeling experience
- Data infrastructure and devops experience (terraform, Actions)
I was being a bit glib/imprecise before, but I'm specifically talking about the Northwestern Memorial campus downtown Chicago [0]. That location qualifies for 340B as a Rural Referral Center (RRC), and got itself reclassified by CMS/HRSA as rural to do so, despite being in the middle of downtown. RRCs need to meet a lower threshold of Disproportionate Share Hospital (DSH) adjustment percentage (8% vs the usual 11.75%). Northwestern Memorial needs to be an RRC because it doesn't meet the higher DSH threshold.
AFAIK, the other hospitals/clinics under the Northwestern umbrella don't really factor into whether the downtown Northwestern Memorial campus qualifies for 340B (insofar as they all have their own CCNs and qualify independently). In this case, Northwestern Memorial qualifies because it a) got reclassified as rural b) became an RRC (likely based on its staff specialty mix) c) meets the RRC DSH threshold of >= 8%.
Northwestern Memorial does treat a lot of rural patients, so maybe it does deserve 340B. That said, it seems clear that it's not they type of struggling safety-net/rural hospital 340B was originally intended to subsidize.
Hi, I wrote this article and largely agree with you. 340B is important and without it many hospitals likely wouldn't survive. However, it's pretty evident at this point that 340B has expanded beyond its original intent.
For example, Northwestern University (in the middle of downtown Chicago) got itself reclassified as a rural hospital in order to participate in the program.
Moreover, it's grown extremely rapidly over the past ~5 years, and the gravity of the program is starting to create bizarre second-order effects like the one outlined.
My intent with this article is just to highlight some of those effects, not to advocate for eliminating 340B.
Also, not bankrolled by pharma, just a researcher for Turquoise Health (a healthtech startup). I get to dig around in their data and publish occasionally, but editorial control / opinions are my own.
DataSF is looking for a Senior Data Engineer to help us build out the city's central Snowflake platform, which will ultimately power the majority of SF's analytics, open data, and ML efforts. This role is a mix of data infrastructure (CI/CD, terraform), building pipelines (ADF, dbt, Python), and platform eng and admin (Snowflake). See the position description for more info.
We're looking for folks with:
- Strong SQL and Python skills
- Deep data modeling experience
- Data infrastructure and devops experience (terraform, Actions)
- dbt and Snowflake experience are a big plus
- Know their way around a terminal
Apply here: https://careers.sf.gov/role/?id=3743990013401756