Analytics Engineer, Revenue Cycle, Full time - Day

UChicago Medicine is seeking an Analytics Engineer, Revenue Cycle to build and maintain data infrastructure for hospital billing and revenue cycle reporting. The role transforms data from multiple source systems into reliable, modeled datasets and supports analytics, reporting, data quality, and stakeholder needs.

Responsibilities:

• Develop and maintain data models (star schema/dimensional models) that support consistent, reusable reporting across the revenue cycle
• Build and optimize semantic models, views, and datasets that power dashboards and self-service reporting (e.g. CPT reimbursement, underpayments, service line analysis)
• Define and standardize business logic and metric definitions so they're calculated consistently across reports
• Explore and implement AI-powered and predictive analytics tools to identify trends, anomalies, and risk patterns in billing and payment data (e.g., denial and underpayment patterns, unexpected payor behavior, downgrades)
• Partner with stakeholders to build highly effective data analytics tools that improve self service reporting and analyst productivity
• Design, build, and maintain data pipelines that ingest billing, claims, denials, and payment data from multiple source systems (e.g. Epic, Blue Cross Blue Shield, clearinghouses)
• Monitor and troubleshoot pipeline failures, performance issues, and data anomalies
• Implement data quality checks, validation rules, and reconciliation processes to catch discrepancies before they reach reporting
• Document data lineage, transformation logic, and metric definitions for transparency and auditability
• Partner with report analysts to understand reporting needs and ensure underlying data structures support them efficiently
• Support ad hoc data/report requests and root-cause investigations into revenue cycle reporting discrepancies

Requirements:

• Bachelor's Degree required in Computer Science, Data Science, Statistics or a related field
• 3+ years of experience in analytics engineering, data engineering, or a similar role required
• Strong Programming and data analysis skills including SQL, Python, statistical analysis and predictive modeling required
• Experience building data models and working with cloud data platforms (e.g., Azure, Snowflake, Databricks, or similar) required
• Experience with a modern data transformation approach (e.g., data build tools (dbt), stored procedures, or similar) required
• Experience integrating and reconciling data across multiple, disparate source systems required
• Experience with data visualization and self-service analytics enablement using PowerBI or Tableau required
• Must have strong issue tracking and resolution skills, and the ability to cope in a fast-paced environment
• Must be able to prioritize, organize, and assess work to meet aggressive deadlines
• Must have experience with Microsoft Excel, Word, Visio and Powerpoint
• Capable of working well in a diverse, multi-disciplinary team and successfully interacting with others at all levels of the organization, including remote teams
• Excellent interpersonal, written and oral communication skills, and effective presentation skills
• Ability to plan and facilitate meetings with diverse participants
• Ability to maintain a professional attitude and demeanor in both normal and pressure situations
• Proven skills in problem solving
• Master's Degree preferred
• Familiarity with hospital revenue cycle concepts (charge capture, claims, denials, A/R, payer mix)
• Epic experience
• Microsoft Fabric Analytics Engineer Associate Certification
• Other Microsoft SQL/BI, Epic, Tableau or related certifications