Dataplex-consulting

DATAPLEX-CONSULTINGbuyer room · privateManage buyer room

Warehouse-native CMS/healthcare data products delivered as analysis-ready tables. This table (DWV.BENEFITS_DATA__PREMIUMS_DEDUCTIBLES on Snowflake, cms_research_dwv.benefits_data__premiums_deductibles on Databricks) carries Medicare Advantage and Part D premium amounts, deductibles, out-of-pocket maximums and full cost-sharing structures by plan — 840 data columns plus 5 lineage columns, keyed on Contract ID (H-number) and Plan ID, with 2019 to 2027 harmonised into one schema. It is one table inside a much larger catalogue: MA enrollment by SCP and SCC, MA contract service area, plan service-area county mapping, covered services, B19B benefit packages, quarterly Part D formulary/pharmacy-network/pricing files, an NPPES provider dataset refreshed weekly, Medicaid provider-level claims, and a provenance-traced CMS prior-authorisation compliance intelligence set with a payer directory and metrics-posting registry.