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.

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

Required to obtain the following Epic certifications within the one year of hire: Cogito Fundamentals (or prior equivalent), Clarity Data Model, Revenue Data Model.

Skills and Abilities
Knowledge of healthcare reimbursement programs, coding, and billing preferred.
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.

Level of Supervision

Supervises

N/A

PAY RANGE:

$26.63 - $39.95

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