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
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) and Health Research Inc. (HRI) Roswell Park Division believe that all persons are entitled to equal employment opportunities, and we do not discriminate against our employees, applicants or job seekers because of their race, color, religion, sex, sexual orientation, gender identity or expression, national origin, creed, age, disability, pregnancy-related condition, military or veteran status, marital or familial status, domestic violence victim status, citizenship status, genetic information, individual’s relationship or association with a member of a protected category or any other protected group status as defined by law.
Reasonable Accommodation Request
RPCIC and HRI are committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the employment process, please email HR-BenefitsandLeaves@roswellpark.org and let us know the nature of your request and your contact information.
Our Core Values
RPCIC and HRI are committed to providing an environment where patients, families, employees and community are treated with courtesy and respect. We support an inclusive environment that nurtures the talents, skills and abilities of each individual to embody and reflect our core values: Innovation, Integrity, Teamwork, Commitment, Compassion and Respect.
Historical Compensation Information Statement
Pursuant to Executive Order 161, no State entity, as defined by the Executive Order, is permitted to ask, or mandate, in any form, that an applicant for employment provide his or her current compensation, or any prior compensation history, until such time as the applicant is extended a conditional offer of employment with compensation. If such information has been requested from you before such time, please contact the Governor’s Office of Employee Relations at (518) 474-6988 or via email at info@goer.ny.gov.
