Microsoft-access Opportunity Near You ∙ Page 8

Scheduled Hours

40

Position Summary

Position serves as lead staff specialist for the school level clinical financial reporting, analysis, integrations, allocations and special projects. Responsible for managing net revenue recognition and account receivable (AR) valuation related to patient revenue. This role requires strong data analytic skills, ability to learn new software programs, understand underlying model calculations, and implement practical solutions to complex problems. Prior experience with month-end close processes, including journal entries, and advanced Excel skills strongly preferred.

Job Description

Leads, directs and oversees school level financial objectives including, but not limited to:

• Integrations – Maintain, manage, and analyze Epic – Workday Integration as it relates to clinical revenues including all related reporting and revenue recognition requirements.
• Net Revenue – Manage Kodiak Revenue Cycle Analytics (RCA) tool on daily and monthly basis to calculate AR valuation, along with producing analysis on Patient Net Revenue projections.
• Accounting – Complete reconciliation related to Patient Revenues. Review the integrity and quality of general ledger reporting, including the Foundation Data Model, preparing needed journal entries, and auditing of financial data.
• Analysis - Provides recommendations to senior leadership related to results of ad hoc and other special projects as assigned.
• Reporting - Gathers data requirements for new reporting needs and tests reports created by the financial reporting team.
• Allocations - Create, maintain, manage, and analyze financial allocation results.
• Planning - Prepare budgets, forecasting, and financial models.
• Other duties as assigned.

Working Conditions:
Job Location/Working Conditions

• Normal office environment

Physical Effort

• Typically sitting at a desk or table

Equipment

• Office equipment

The above statements are intended to describe the general nature and level of work performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all job duties performed by the personnel so classified. Management reserves the right to revise or amend duties at any time.

Required Qualifications

Education:

Bachelor’s degree or combination of education and/or experience may substitute for minimum education.

Certifications:

No specific certification is required for this position.

Work Experience:

Financial Systems Analysis, Administration, And Reporting With Ibm Cognos Or Other Business Intelligence Tools And/Or Budgeting Software (4 Years)

Skills:

Not Applicable

Driver's License:

A driver's license is not required for this position.

More About This Job

Preferred Qualifications:

• Knowledge of pivot tables is strongly preferred.

Preferred Qualifications

Education:

M.B.A. - Master of Business Administration

Certifications:

Certified Public Accountant (CPA) - American Institute of Certified Public Accountants , Certified Public Accountant (CPA) - Illinois Department of Financial and Professional Regulation, Certified Public Accountant (CPA) - Missouri Division of Professional Registration

Work Experience:

No additional work experience beyond what is stated in the Required Qualifications section.

Skills:

Analytical Thinking, Challenge Driven, Data Assessment, Deadline Management, Decision Making, Enterprise Resource Planning (ERP), Financial Analysis, Financial Data, Microsoft Access, Microsoft Excel, Microsoft Word, Multitasking, Oral Communications, Pivot Tables, Problem Solving, Project Administration, Self Motivation, Service Oriented, Solution Finding, Stress Management, Teamwork, Workday Financials, Working Independently, Written Communication

Grade

G13

Salary Range

$65,900.00 - $112,700.00 / Annually

The salary range reflects base salaries paid for positions in a given job grade across the University. Individual rates within the range will be determined by factors including one's qualifications and performance, equity with others in the department, market rates for positions within the same grade and department budget.

Questions

For frequently asked questions about the application process, please refer to our External Applicant FAQ.

Accommodation

If you are unable to use our online application system and would like an accommodation, please email [email protected] or call the dedicated accommodation inquiry number at 314-935-1149 and leave a voicemail with the nature of your request.

All qualified individuals must be able to perform the essential functions of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees with disabilities to perform the essential functions of their job, absent undue hardship.

Pre-Employment Screening

All external candidates receiving an offer for employment will be required to submit to pre-employment screening for this position. The screenings will include criminal background check and, as applicable for the position, other background checks, drug screen, an employment and education or licensure/certification verification, physical examination, certain vaccinations and/or governmental registry checks. All offers are contingent upon successful completion of required screening.

Benefits Statement

Personal

• Up to 22 days of vacation, 10 recognized holidays, and sick time.

• Competitive health insurance packages with priority appointments and lower copays/coinsurance.

• Take advantage of our free Metro transit U-Pass for eligible employees.

• WashU provides eligible employees with a defined contribution (403(b)) Retirement Savings Plan, which combines employee contributions and university contributions starting at 7%.

Wellness

• Wellness challenges, annual health screenings, mental health resources, mindfulness programs and courses, employee assistance program (EAP), financial resources, access to dietitians, and more!

Family

• We offer 4 weeks of caregiver leave to bond with your new child. Family care resources are also available for your continued childcare needs. Need adult care? We’ve got you covered.

• WashU covers the cost of tuition for you and your family, including dependent undergraduate-level college tuition up to 100% at WashU and 40% elsewhere after seven years with us.

For policies, detailed benefits, and eligibility, please visit: https://hr.wustl.edu/benefits/

EEO Statement

Washington University in St. Louis is committed to the principles and practices of equal employment opportunity and especially encourages applications by those from underrepresented groups. It is the University’s policy to provide equal opportunity and access to persons in all job titles without regard to race, ethnicity, color, national origin, age, religion, sex, sexual orientation, gender identity or expression, disability, protected veteran status, or genetic information.

Washington University is dedicated to building a community of individuals who are committed to contributing to an inclusive environment – fostering respect for all and welcoming individuals from diverse backgrounds, experiences and perspectives. Individuals with a commitment to these values are encouraged to apply.