Developed a scalable data-generation feature for the HealthRex/CDSS repository, focusing on Moonshot’s critical care and ACP billing analytics. Leveraging BigQuery and advanced SQL, the work introduced a new script that extracts and joins data from treatment teams, clinical notes, and CPT codes using common table expressions. The solution identifies 'code blue' and 'ACP' notes, associating them with relevant billing information to create data-ready billing datasets. This approach established a foundation for automated billing analytics, enabling faster and more accurate insights for downstream processes. The work demonstrated depth in data engineering, emphasizing maintainability and extensibility within the existing analytics pipeline.