Remote Excel Spreadsheet Jobs in Iowa (NOW HIRING)

Within the Stead Family Department of Pediatrics, assist with Operating Budget development, submission and implementation. Oversee monthly accounting, workflow, reporting, variance analysis and reconciliation processes. Perform financial analysis and develop proforma for business and strategic initiatives.

This position is eligible for remote work. Remote work must be performed at a location within the state of Iowa and comply with the remote work program and related policies.

Financial Oversight, Reporting & Analysis

Incentive Plan Administration

• Create, validate, and disseminate incentive plan reports.

• Track RVUs across providers.

• Manage penalty tracking including Charge Lag, Documentation Deficiency, Bumped Clinic, Compliance, and DRG (CDI) Queries.

Ad Hoc Reporting & Financial Tracking

• Respond to ad hoc report requests from providers and executive leadership

• Assist the Finance Manager with annual budget preparation and salary posting

• Complete mandatory reconciliations and report following pre-established processes.

• Assess variance reports on revenue, expense, and other statistical measures. Prepare highly specialized reports as requested.

Financial Analysis and Planning

• Perform complex financial and statistical analysis utilizing expert knowledge of financial systems.

• Utilize decision support/data warehouse systems to develop proforma and business analysis for programmatic and strategic initiatives.

Revenue Cycle Management 

Billing, Coding & Payor Relations

• Participate in monthly crossdepartment meetings and act as a liaison for denials, appeals, payer relations, and coding inquiries.

• Address unresolved patient billing questions and manage patient followup communications.

• Manage CARTS ad hoc requests and oversee PreService CARTS workflows.

• Provide coding support to providers, including guidance on new services, workflow questions, and chargemaster inquiries.

• Act as the HCIS build contact for new services, ensuring accurate charge capture and system configuration.

Metabolic Formula Coordination

• Maintain and update the Formula Orders Spreadsheet, including pricing and documentation accuracy.

• Serve as the primary contact for PCD/PFS questions related to metabolic formula processes and Charity Care considerations.

HCIS, Chargemaster & Provider Specialty Codes

• Manage new bill area setup, provider/APP bill area requests, and Allowed Services reviews.

• Coordinate bill area mapping for revenue across divisions.

• Serve as the liaison for Provider Credentialing with CSO, PCD, and HR, validating new provider taxonomy and Medicare assignments.

Compliance with Policies, Regulations and Laws and Operational Oversight

• Advise and guide divisions within department on compliance requirements related to billing, coding, and revenue cycle processes, ensuring adherence to organizational policies, regulatory standards, and applicable laws.

Leadership and Training

• Deliver bestpractice training to staff and support ongoing education related to revenue cycle processes.

• Recommend and assist in developing training solutions that improve the accuracy, efficiency, and effectiveness of financial transactions, billing practices, and coding processes.

• Advise departmental leadership on appropriate financial controls and compliance requirements related to billing, coding, and revenue cycle operations.

• May provide functional and or administrative supervision (direction, assignments, feedback, coaching and counseling) to assure outcomes are achieved.

Strategic Planning

• Assist in coordination/preparation of analysis for strategic plans in support of DEO/ administrator.

Education Requirements

• Bachelor's degree in business administration/accounting/finance/management information system, or an equivalent combination of education and experience.

Required Qualifications

• Knowledge of medical coding and revenue cycle processes (CPT/ICD codes, chargemaster, payer billing workflows).

• Minimum of three years' experience in finance and or an accounting related field.

• Advanced Excel skills including Pivot tables, VLookup, Sumifs.

• Demonstrated experience with database queries or computer programing.

• Demonstrated excellent verbal and written communication and interpersonal skills.

Desired Qualifications

• Experience with medical coding and revenue cycle processes.

• Experience with healthcare billing systems (HCIS, Epic, or similar).

Position and Application details:

In order to be considered for an interview, applicants must upload the following documents and mark them as a "Relevant File" to the submission:

• Resume

• Cover Letter

Job openings are posted for a minimum of 7 calendar days and may be removed from posting and filled any time after the original posting period has ended.

Successful candidates will be required to self-disclose any conviction history and will be subject to a criminal background check and credential/education verification. Up to 5 professional references will be requested at a later step in the recruitment process.

For additional questions, please contact pedsuichildrenshr@healthcare.uiowa.edu

This position is not eligible for University sponsorship for employment authorization.