Revenue Cycle Reporting Analyst 1

Mercyhealth Wisconsin and Illinois•Home, WV

5d•$27 - $40

About The Position

Essential Duties and Responsibilities Create summary reports, data extracts, and other financial analyses for management and external vendors. Pull underlying data by creating/modifying SQL queries to run in Epic's Clarity database. Adjust query outputs in Excel, add formulas, charts, and graphs to summarize data and show underlying trends. Link output data to other workbooks to create more complex data models if required. Uses Visual Studio to generate appropriate output format. Uses Excel VBA to automate reports. Build contract models using Epic contract modeling tools. Build contract models in Excel by querying Epic's Clarity database. Refresh underlying claim data in contract models as contract terms change. Build SQL templates to pull patient, claim, department, or enterprise-wide data. Maintains and updates the templates after each Epic upgrade. Thorough understanding of source data systems and their interaction with medical claims. Culture of Excellence Behavior Expectations To perform the job successfully, an individual should demonstrate the following behavior expectations: Quality - Follows policies and procedures; adapts to and manages changes in the environment; Demonstrates accuracy and thoroughness giving attention to details; Looks for ways to improve and promote quality; Applies feedback to improve performance; Manages time and prioritizes effectively to achieve organizational goals. Service - Responds promptly to requests for service and assistance; Follows the Mercyhealth Critical Moments of service; Meets commitments; Abides by MH confidentiality and security agreement; Shows respect and sensitivity for cultural differences; and effectively communicates information to partners; Thinks system wide regarding processes and functions. Partnering - Shows commitment to the Mission of Mercyhealth and Culture of Excellence through all words and actions; Exhibits objectivity and openness to other's views; Demonstrates a high level of participation and engagement in day-to-day work; Gives and welcomes feedback; Generates suggestions for improving work: Embraces teamwork, supports and encourages positive change while giving value to individuals. Cost - Conserves organization resources; Understands fiscal responsibility; Works within approved budget; Develops and implements cost saving measures; contributes to profits and revenue. Mercyhealth is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, disability, or protected veteran status. Mercyhealth offers competitive pay and a comprehensive benefits package including: Medical, Dental, Vision Life & Disability Insurance FSA/HSA Options Generous, accruing paid time off Paid Parental and caregiver leave Career advancement and educational opportunities Tuition and certification reimbursement Certification Reimbursement Well-being Programs Employee Discounts On-Demand Pay Financial Education Annual recognition/awards events Partner appreciation days Family entertainment/attractions discount Community service/improvement opportunities Click here for more details regarding Mercyhealth Careers Benefit Information. At Mercyhealth, we don’t simply hire people, we empower employee-partners who are passionate about making lives better. As an integrated health system, we deliver exceptional, coordinated across seven hospitals, 85 primary and specialty clinics, and a team of over 7,500 professionals serving northern Illinois and southern Wisconsin. Mercyhealth has been nationally recognized for our commitment to our people and culture, including: #1 in the nation on AARP's Best Employers for Workers Over 50 One of Working Mother magazine's 100 Best Companies for Working Mothers A Top 50 Company and Top 10 Nonprofit for Executive Women For over 135 years, Mercyhealth has provided high-quality health care to residents throughout northern Illinois and southern Wisconsin. We have a passion for providing comprehensive health care close to home for area residents through our six hospitals and 85 primary and specialty care locations. As an integrated health system, you can come to us for routine health care, like annual physicals, immunizations and preventive health screenings, as well as highly specialized care, such as neonatal intensive care, heart surgery, stroke care, neurosurgery, cancer treatment and much more. The range of Mercyhealth's specialties and the skills of our doctors, nurses and clinical staff are truly extraordinary.

Requirements

Associates degree with a major in computer science, business, mathematics, engineering, science and 3 years' experience in Revenue Cycle Reporting required. 5 years of experience in lieu of degree.
Required to obtain the following Epic certifications within the one year of hire: Cogito Fundamentals (or prior equivalent), Clarity Data Model, Revenue Data Model.

Nice To Haves

Knowledge of healthcare reimbursement programs, coding, and billing preferred.

Responsibilities

Create summary reports, data extracts, and other financial analyses for management and external vendors.
Pull underlying data by creating/modifying SQL queries to run in Epic's Clarity database.
Adjust query outputs in Excel, add formulas, charts, and graphs to summarize data and show underlying trends.
Link output data to other workbooks to create more complex data models if required.
Uses Visual Studio to generate appropriate output format.
Uses Excel VBA to automate reports.
Build contract models using Epic contract modeling tools.
Build contract models in Excel by querying Epic's Clarity database.
Refresh underlying claim data in contract models as contract terms change.
Build SQL templates to pull patient, claim, department, or enterprise-wide data.
Maintains and updates the templates after each Epic upgrade.
Thorough understanding of source data systems and their interaction with medical claims.