Revenue Cycle Data Integration Analyst

Roswell Park Comprehensive Cancer Center

About The Position

The Revenue Cycle Data Integration Analyst supports the extraction, transformation, and delivery of reliable revenue cycle data to enable financial and operational reporting across the organization. This role works closely with revenue cycle leadership, finance teams, and operational stakeholders to ensure data from billing, claims, coding, and vendor systems is accurately integrated into the organization’s SQL-based enterprise data warehouse and Microsoft Fabric analytics environments and ensure that data structures and workflows are well-documented. The analyst plays a key role in maintaining and enhancing ETL processes, supporting data integrations from vendor systems, and applying business logic to create analytics‑ready datasets. This includes validating financial and claims data, reconciling results to source systems, and proactively identifying and resolving data quality issues. The role emphasizes SQL, ETL workflows, and Microsoft Fabric ingestion patterns to ensure consistency, scalability, and trust in analytics. While not primarily a reporting role, the position also supports revenue cycle reporting and analytics by contributing to Power BI dashboards used to monitor HFMA key performance indicators, claim denials, claim edits, and performance metrics. The analyst is expected to understand reporting requirements, collaborate with stakeholders, and support operational and executive decision‑making. The successful candidate will possess strong analytical skills, an understanding of healthcare revenue cycle data, and the ability to collaborate with business stakeholders. The starting annual salary for this position is $91,298 and this can include a full comprehensive benefits package.

Requirements

Master's degree in computer science, engineering, data science, management information systems or a related field; or
Bachelor’s degree in computer science, engineering, data science, management information systems or a related field and the equivalent of two (2) years of full-time software development experience; or
Associates degree in computer science, engineering, data science, management information systems or a related field and the equivalent of four (4) years of full-time software development experience; or
High School diploma or High School Equivalency diploma with a diploma or certificate in a computer science, or related field and the equivalent of six (6) years of full-time software development experience.
Strong proficiency with SQL-based enterprise data warehouses is essential.
Comfortable writing, optimizing, and maintaining moderately complex SQL queries to support data integration, validation, and downstream consumption.
Experience extracting data from vendor systems and supporting transformation and load processes for enterprise analytics.
Demonstrates strong attention to detail, effective time management, and the ability to handle multiple requests concurrently.
Clear communication skills and experience collaborating with finance, revenue cycle, and IT partners in a healthcare environment are essential.

Nice To Haves

Experience supporting healthcare revenue cycle data analytics across the claims, billing, and denials lifecycle, with an emphasis on preparing reliable, analytics‑ready datasets.
Familiarity with revenue cycle workflows, HFMA key performance indicators, payer denials and claim edits is preferred.
Familiarity with PHP or Python-based ETL processes is beneficial for maintaining existing jobs.
Hands‑on experience with Microsoft Fabric is strongly preferred, including working with data pipelines, dataflows, lakehouses, and warehouses.
A solid understanding of ETL concepts such as incremental loading, dependency management, refresh orchestration, and error handling is expected.
Power BI experience is preferred, but secondary to data engineering skills with a focus is on enabling accurate and trusted reporting rather than advanced visualization.
Candidates should be able to work with existing semantic models, develop or update DAX measures, and update operational dashboards used by business teams.

Responsibilities

Supports the extraction, transformation, and delivery of reliable revenue cycle data.
Works closely with revenue cycle leadership, finance teams, and operational stakeholders.
Ensures data from billing, claims, coding, and vendor systems is accurately integrated.
Maintains and enhances ETL processes.
Supports data integrations from vendor systems.
Applies business logic to create analytics‑ready datasets.
Validates financial and claims data.
Reconciles results to source systems.
Identifies and resolves data quality issues.
Supports revenue cycle reporting and analytics by contributing to Power BI dashboards.
Understands reporting requirements and collaborates with stakeholders.
Supports operational and executive decision‑making.