Revenue Cycle Data Integration Specialist

Roswell Park Comprehensive Cancer Center

About The Position

The Revenue Cycle Data Integration Specialist ensures access to accurate, reliable, and actionable revenue cycle data. The role works with revenue cycle leaders, finance teams, and operational stakeholders to transform billing, claims, coding, and vendor data into trusted datasets that support business decisions. The position focuses on building and maintaining data integration and ETL processes, preparing analytics-ready datasets, supporting a SQL-based enterprise data warehouse and Microsoft Fabric analytics environment, and helping ensure data quality and consistency. It also supports Power BI reporting and revenue cycle performance metrics while documenting workflows, integrations, and data structures. The role is part of Roswell Park Comprehensive Cancer Center’s Information Technology department and contributes to the organization’s patient-care, research, and operational mission.

Requirements

  • One of the following education and experience combinations: doctorate in computer science, engineering, data science, management information systems, or a related field; master's degree in one of those fields plus the equivalent of two years of full-time software development experience; bachelor's degree in one of those fields plus the equivalent of four years of full-time software development experience; associate degree in one of those fields plus the equivalent of six years of full-time software development experience; or high school diploma or equivalency with a computer science or related-field diploma or certificate plus the equivalent of eight years of full-time software development experience.
  • Degrees must be conferred by an accredited school, college, or university, or an institution recognized by Roswell Park Comprehensive Cancer Center and/or Health Research Incorporated as adhering to acceptable educational standards.
  • Experience supporting healthcare revenue cycle data analytics, including an understanding of claims, billing, and denials workflows and the claims, billing, and denials lifecycle.
  • Familiarity with revenue cycle workflows, HFMA key performance indicators, payer denials, and claim edits.
  • Strong proficiency with SQL-based enterprise data warehouses, including writing, optimizing, troubleshooting, and maintaining moderately complex queries.
  • Experience supporting ETL processes and enterprise data integration initiatives.
  • Knowledge of data validation, reconciliation, and data quality best practices.
  • Ability to work with large datasets, apply transformational business logic, reconcile data against source applications, validate with business stakeholders, and investigate data anomalies or quality issues.
  • Understanding of ETL concepts, including incremental loading, dependency management, refresh orchestration, and error handling.
  • Familiarity with PHP- or Python-based ETL processes to maintain existing jobs.
  • Strong organizational, problem-solving, communication, and time-management skills; ability to manage multiple requests or priorities with minimal supervision and work independently and collaboratively.
  • Clear communication and collaboration skills with finance, revenue cycle, and IT partners in a healthcare environment.

Nice To Haves

  • Hands-on experience with Microsoft Fabric, including data pipelines, dataflows, lakehouses, and warehouses.
  • Power BI experience, including working with existing semantic models, updating DAX measures, and making minor operational dashboard updates.

Responsibilities

  • Build, maintain, and enhance data integration and ETL processes.
  • Extract, transform, validate, and reconcile revenue cycle data from multiple source systems.
  • Support the SQL-based enterprise data warehouse and Microsoft Fabric analytics environment.
  • Develop and maintain analytics-ready datasets for financial and operational reporting.
  • Investigate and resolve data quality issues, discrepancies, anomalies, and inconsistencies.
  • Apply business rules and logic to ensure data accuracy and consistency.
  • Collaborate with revenue cycle, finance, operational, and IT teams to understand reporting and data needs.
  • Support Power BI dashboards and revenue cycle performance metrics, including claims, denials, and reimbursement trends.
  • Document data workflows, integrations, and data structures to support scalability and reliability.
  • Support data extraction from vendor systems and transformation and load processes for enterprise analytics.
  • Maintain existing PHP- or Python-based ETL jobs.
  • Work with existing Power BI semantic models, update existing DAX measures, and make minor updates to operational dashboards.

Benefits

  • The starting annual salary can include a full comprehensive benefits package.
  • Meaningful work supporting data-driven decisions at a nationally recognized cancer center.
  • Opportunities to partner with leaders across revenue cycle, finance, operations, and technology.
  • Exposure to modern data platforms and analytics technologies, including Microsoft Fabric and Power BI.
  • A collaborative environment that values innovation, continuous improvement, and professional growth.
  • A mission-driven culture where expertise supports better outcomes for patients and communities.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service