Drive data quality, standardization, and insight generation across the company's core Oracle operational suite, ensuring absolute data integrity in a regulated healthcare environment and transforming raw transactional data into actionable business intelligence to optimize cost-per-case, enhance inventory accuracy, and accelerate the revenue cycle.
Requirements
- Expert-level SQL skills for complex database querying, including experience navigating Oracle tables/views.
- Proficiency in Python or R, with experience in statistical modeling, time series analysis, and machine learning libraries.
- Experience developing advanced visualizations using industry-leading tools (Tableau, Power BI).
- Demonstrable experience working with large-scale Enterprise Data Warehouses (EDW) in a regulated environment.
- Proven practical experience analyzing, querying, and understanding the complex data models within at least two of the following Oracle applications (EBS or Fusion): Oracle Supply Chain Management (SCM) & Inventory, Oracle Procurement, Oracle Revenue Cycle Management (RCM).
- Familiarity with clinical coding standards (CPT, ICD-10) as they relate to procedure costing and RCM data.
- Understanding of HIPAA, HITECH, and general healthcare data governance standards.
Responsibilities
- Design and implement automated data validation frameworks specific to healthcare operations, ensuring transactional data (e.g., supply usage, procedure charging, contract pricing) is accurate.
- Develop reports and monitoring tools to detect anomalies and discrepancies that could impact regulatory reporting, financial audits (e.g., SOX implications), or compliance with GPO contracts and payer rules.
- Specifically focus on validating the link between inventory consumption (SCM) and patient billing (RCM) data to prevent charge capture errors, ensuring accurate patient bills and maximizing appropriate reimbursement.
- Investigate and diagnose data errors originating in Oracle system configurations (EBS or Fusion), ensuring the integrity of critical data points like item master definitions, vendor codes, and pricing tiers.
- Define, standardize, and institutionalize critical operational metrics across the organization, such as: Inventory Accuracy Rate for Critical Supplies, Procurement Compliance Rate (Off-Contract Spend), Days of Supply (DOS) for high-value pharmaceuticals and implants, Cost-Per-Case Variance analysis (linking supply cost to procedure type), Claims Denial Rate Analysis linked to operational inputs.
- Develop and maintain standardized operational reports and interactive dashboards (e.g., Tableau, Power BI) focused on optimizing the efficiency and spend within the OR, Clinics, and centralized purchasing departments.
- Develop sophisticated models to forecast demand volatility (e.g., flu season spikes, pandemic-related surges) for critical supplies and pharmaceuticals, minimizing shortages and excess waste.
Other
- Serve as the technical data expert for functional Oracle teams (Finance, Clinical Operations, Materials Management), bridging the gap between business needs and data structure.
- Document data lineage, metric definitions, and model methodologies to ensure transparency and trust in derived insights across the enterprise.
- Excellent collaboration and communication skills, with the ability to present complex analytical findings to clinical and executive audiences.
- 2+ years of experience in a specialized data science, BI, or analytics role, working within a large healthcare system, hospital, or payer environment.
- Certification in Oracle applications or cloud platforms is a plus.
