Aegis Sciences Corporation
Revenue Cycle Management Systems Analyst I
Aegis Sciences Corporation, Nashville, Tennessee, United States, 37247
Revenue Cycle Management Systems Analyst I
The
Revenue Cycle Management (RCM) Systems Analyst I
is responsible for analyzing and optimizing healthcare revenue cycle operations using specialized systems to improve financial performance and ensure timely reimbursement from patients and payers. This role requires strong analytical skills, technical proficiency in SQL, Excel, and PowerBI, and knowledge of healthcare billing processes and regulations. The analyst collaborates with leadership and client-facing teams to deliver actionable insights and support operational excellence.
Essential Duties & Responsibilities
Develop and maintain SQL-based queries and scripts to extract, transform, and analyze data from multiple sources
Build and optimize PowerBI dashboards to visualize KPIs, denial trends, and revenue cycle metrics
Use advanced Excel functions for ad-hoc analysis and recurring reporting needs
Interpret system data, identify performance gaps, and recommend system improvements
Configure RCM software and ensure billing compliance with coding standards (CPT, ICD-10)
Create and maintain reports such as accounts receivable aging, operational performance, and payer compliance
Analyze payer contract compliance and monitor denial trends to identify opportunities for revenue recovery
Respond to internal and external data requests with clear, well-documented reporting outputs
Conduct thorough testing and validation of reports and software updates to ensure accuracy and reliability
Support special projects and initiatives related to billing systems and RCM transformation
Other Duties & Responsibilities
Participate in process improvement initiatives, including definition, measurement, and implementation of controls
Contribute to team goals through collaboration, knowledge sharing, and mentorship
Perform other duties as assigned
Education & Experience
Bachelor’s degree in Finance, Business, Computer Science, Data Analytics, or related field required
A minimum of three (3) years of experience in healthcare revenue cycle analytics or billing systems required
Proven experience with SQL, PowerBI, and advanced Excel required
Strong communication skills and ability to work across teams and levels of the organization
Aegis Sciences Corporation is an Equal Opportunity Employer.
#J-18808-Ljbffr
Revenue Cycle Management (RCM) Systems Analyst I
is responsible for analyzing and optimizing healthcare revenue cycle operations using specialized systems to improve financial performance and ensure timely reimbursement from patients and payers. This role requires strong analytical skills, technical proficiency in SQL, Excel, and PowerBI, and knowledge of healthcare billing processes and regulations. The analyst collaborates with leadership and client-facing teams to deliver actionable insights and support operational excellence.
Essential Duties & Responsibilities
Develop and maintain SQL-based queries and scripts to extract, transform, and analyze data from multiple sources
Build and optimize PowerBI dashboards to visualize KPIs, denial trends, and revenue cycle metrics
Use advanced Excel functions for ad-hoc analysis and recurring reporting needs
Interpret system data, identify performance gaps, and recommend system improvements
Configure RCM software and ensure billing compliance with coding standards (CPT, ICD-10)
Create and maintain reports such as accounts receivable aging, operational performance, and payer compliance
Analyze payer contract compliance and monitor denial trends to identify opportunities for revenue recovery
Respond to internal and external data requests with clear, well-documented reporting outputs
Conduct thorough testing and validation of reports and software updates to ensure accuracy and reliability
Support special projects and initiatives related to billing systems and RCM transformation
Other Duties & Responsibilities
Participate in process improvement initiatives, including definition, measurement, and implementation of controls
Contribute to team goals through collaboration, knowledge sharing, and mentorship
Perform other duties as assigned
Education & Experience
Bachelor’s degree in Finance, Business, Computer Science, Data Analytics, or related field required
A minimum of three (3) years of experience in healthcare revenue cycle analytics or billing systems required
Proven experience with SQL, PowerBI, and advanced Excel required
Strong communication skills and ability to work across teams and levels of the organization
Aegis Sciences Corporation is an Equal Opportunity Employer.
#J-18808-Ljbffr