Revenue Cycle Data Integration Specialist

Title:

Revenue Cycle Data Integration Specialist

Job Type:

Regular

Company:

Roswell Park Comprehensive Cancer Center

Department:

Information Technology

Time Type:

Full time

Weekly Hours:

40

FTE:

1

Shift:

First Shift (United States of America)

Summary:

About the Role:
The Revenue Cycle Data Integration Specialist plays a vital role in ensuring the organization has access to accurate, reliable, and actionable revenue cycle data. In this position, you'll work closely with revenue cycle leaders, finance teams, and operational stakeholders to transform complex billing, claims, coding, and vendor data into trusted datasets that support key business decisions.
This role is ideal for a data-focused professional who enjoys solving complex challenges, improving data quality, and creating the foundation for meaningful analytics across a healthcare environment.
The starting annual salary for this position is $112,528 and this can include a full comprehensive benefits package.
What You'll Do:
As a Revenue Cycle Data Integration Specialist, you will:
Build, maintain, and enhance data integration and ETL processes
Extract, transform, validate, and reconcile revenue cycle data from multiple source systems
Support the organization's SQL-based enterprise data warehouse and Microsoft Fabric analytics environment
Develop and maintain analytics-ready datasets to support financial and operational reporting
Investigate and resolve data quality issues, discrepancies, and data anomalies
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 key revenue cycle performance metrics, including claims, denials, and reimbursement trends
Document data workflows, integrations, and data structures to support long-term scalability and reliability
What You'll Bring
We're looking for a highly analytical professional who combines strong technical skills with an understanding of healthcare revenue cycle operations.
Ideal candidates will have:
Experience working with healthcare revenue cycle data, including claims, billing, denials, and reimbursement workflows
Strong SQL skills, including writing, optimizing, and troubleshooting complex queries
Experience supporting ETL processes and enterprise data integration initiatives
Knowledge of data validation, reconciliation, and data quality best practices
Experience working with large datasets and translating business requirements into reliable data solutions
Familiarity with Microsoft Fabric, including data pipelines, dataflows, lakehouses, and warehouses
Experience with PHP- or Python-based ETL processes
Working knowledge of Power BI and existing semantic models
Strong organizational, problem-solving, and communication skills
The ability to manage multiple priorities while working independently and collaboratively
Why You'll Love Working Here:
At Roswell Park, every role contributes to our mission of improving lives through exceptional patient care, innovative research, and operational excellence.
When you join our team, you'll enjoy:
Meaningful work that supports data-driven decisions across a nationally recognized cancer center
Opportunities to partner with leaders throughout 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 your expertise helps support better outcomes for patients and the communities we serve
Make an Impact
If you're passionate about healthcare data, enjoy building trusted data solutions, and want to help drive informed decision-making across a complex healthcare organization, we encourage you to apply for the Revenue Cycle Data Integration Specialist role at Roswell Park.

Qualifications:

Required Education and Experience:
Please note that, for this specific position, Roswell Park Comprehensive Cancer Center does not participate in E-Verify and is unable to employ individuals in OPT STEM status. Additionally, this position is not eligible for H-1B sponsorship
1. Doctorate degree in computer science, engineering, data science, management information systems or a related field; or
2. Master'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
3. Bachelor’s 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
4. Associates degree in computer science, engineering, data science, management information systems or a related field and the equivalent of six (6) years of full-time software development experience; or
5. High School diploma or High School Equivalency diploma with a diploma or certificate in a computer science, or related field and the equivalent of eight (8) years of full-time software development experience.
NOTE:
Degrees must be conferred by an accredited school, college, or university, or by an institution recognized by Roswell Park Comprehensive Cancer Center and/or Health Research Incorporated as adhering to acceptable educational standards.

The ideal candidate has experience supporting healthcare revenue cycle data analytics and understanding of 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 required. Strong proficiency with SQL-based enterprise data warehouses is essential. The candidate must be comfortable writing, optimizing, and maintaining moderately complex SQL queries to support data integration, validation, and downstream consumption. This includes working with large datasets, applying transformational business logic, reconciling data against source applications, validating with business stakeholders, and investigating data anomalies or data quality issues. The position emphasizes data integration and ETL support. Preferred candidates have experience extracting data from vendor systems and supporting transformation and load processes for enterprise analytics. Familiarity with PHP or Python-based ETL processes is important 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 is secondary to data engineering skills with a focus is on enabling accurate and trusted reporting rather than developing advanced visualizations. Candidates should be able to work with existing semantic models, update existing DAX measures, and make minor updates to operational dashboards used by business teams. The successful candidate demonstrates strong attention to detail, effective time management, and the ability to handle multiple requests concurrently with minimal supervision. Clear communication skills and experience collaborating with finance, revenue cycle, and IT partners in a healthcare environment are essential.

Equal Employment Opportunity Statement

Roswell Park Cancer Institute Corporation (RPCIC) is committed to equal employment opportunity. We do not discriminate against employees, applicants, or job seekers on the basis of any characteristic protected by applicable federal, state, or local law. Employment decisions are based on qualifications, performance, and business needs. We are committed to maintaining a fair, respectful workplace where employees are valued for their contributions and supported in advancing our mission.

Reasonable Accommodation Request

Our Core Values

RPCIC is committed to fostering an environment where patients, families, employees, volunteers, and members of our community are treated with dignity, courtesy, and respect. We believe our mission is strengthened when individuals contribute their experiences, perspectives, and ideas and work together toward a common purpose. Our actions are guided by our core values of Innovation, Integrity, Teamwork, Commitment, Compassion, and Respect.

Historical Compensation Information Statement