Report Writer, Revenue Cycle
Req # 22452
Department/Skill highlights
- Schedule: Days; flexible schedule opportunities available after probationary period
- Location: Mercycare Building – Janesville, WI OR Remote
- Revenue Cycle Report Writer, Days, Janesville, 80 hrs / 2 wks
Mercyhealth is committed to offering our partners a best place to work and continually evaluates new programs and benefits. We have been recognized locally, regionally and nationally for helping our workers achieve a work/life balance through benefit offerings and innovative programs.
Our unique workplace Culture of Excellence is built upon:
- Employee engagement, empowerment and growth
- Teamwork toward our common goal – providing exceptional health care services with a passion for making lives better
- An atmosphere of caring and quality that cascades throughout the organization
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.
Education and Experience
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.
Certification and Licensure
Has obtained or is willing to acquire the following Epic certifications within the first year of employment: Cogito Fundamentals (or prior equivalent), Clarity Data Model, Revenue Data Model, Resolute Professional Billing Reimbursement Contracts, Resolute Hospital Billing
Special Physical Demands
The Special Physical Demands are considered Essential Job Functions of the position with or without reasonable accommodations.
While performing the duties of this job, the employee is frequently required to sit; use hands to handle, finger, feel; reach, talk and hear. The employee is occasionally required to stand and walk. This is light work exerting up to 25 pounds of force occasionally. Specific vision abilities required by this job include constant close vision. Frequent ability to adjust focus. Prolonged sitting. Manual dexterity needed to operate telephone and keyboard.
EOE&AA/M/F/Vet/Disabled. Mercy is an equal employment opportunity employer functioning under Affirmative Action Plans.
Apply