Healthcare Revenue Cycle Data Analyst

Job Title: Revenue Cycle Data Analyst
Reports to: Director, Revenue Cycle Performance

Job Summary

The Business Intelligence Analyst plays a critical role by providing analytical support for the Revenue Cycle Management department. The analyst is responsible for the analytical review, modeling, and reporting on revenue-related items such as payer mix, service mix, monthly trending analysis, and volume-related reporting. This position reports to the Director of Revenue Cycle Performance.

Essential Functions and Work Responsibilities

Functional Category: Data Analysis and Database Development

• Provide ad-hoc analysis related to the diagnosis and treatment of infertility for the management team in the area of Revenue Cycle Management.
• Create dashboards and reports that provide insights and value to Senior Leadership and all levels of the organization.
• Expand end-user ability to perform ad-hoc reporting and analytics.
• Develop and present revenue analytics in the area of medical claim-related information.
• Monitor network-wide revenue cycle performance, including volume analyses, over and underpayments, denials, etc.
• Calculate and report on payer mix and contractual adjustments.
• Expand the availability and integrity of revenue-related data.

Required Knowledge, Skills, and Abilities

• Proficient in Microsoft Office applications (Outlook, Excel, Word, PowerPoint).
• Proficient in the creation and use of dashboards/data visualization (e.g., Tableau/PowerBI).
• Exceptional analytical skills and a strong attention to detail.
• Knowledge and experience with SQL.
• Self-starter with exceptional time-management skills and the ability to work independently in a fast-paced, dynamic environment.
• Strong communication skills at all organizational levels.
• Ability to work appropriately with highly confidential data, including Protected Health Information (PHI).

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Required Education:

• Bachelor's degree in Healthcare Administration, Data Analytics, or a related field, or equivalent experience.

Required Work Experience and Qualifications:

• 3+ years of progressively responsible experience focused on data visualization and data analysis.
• Experience with medical and claims data.
• Advanced level Excel skills, including complex formulas and data visualization.
• Prior experience with HIPAA data and policies.
• Strong experience with SQL, including Common Table Expressions (CTEs) and analytic functions.
• Knowledge of Business Intelligence tools such as Tableau, Power BI, SSRS.
• Proven ability to understand business needs and translate them into data structures, reports, and dashboards that support data-driven decision-making.

Other Knowledge, Skills, and Abilities

Mathematical/Financial Skills:

• Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
• Able to analyze data and statistics, draw reasonable conclusions, and compile accurate reports.

Language Skills:

• Ability to read, analyze, and interpret regulations and other documents.
• Strong interpersonal skills with the ability to effectively present information and communicate with co-workers, employees, and others.
• Exceptional written and verbal communication skills, including accurate grammar and business correspondence knowledge.
• Ability to write memos, reports, and correspondence that conform to prescribed style and format.

Reasoning Ability:

• Ability to define problems, collect data, establish facts, and draw valid conclusions.

Other Skills and Abilities:

• Able to establish and maintain cooperative and positive working relationships.
• Organized, detail-oriented, diplomatic, proactive, self-motivated, dependable, and excellence-driven.
• Even-tempered and able to balance multiple tasks with changing deadlines and priorities in a fast-paced environment.
• Ability to work sensitively and effectively with individuals from diverse ethnic and cultural backgrounds.

Benefits:

• Paid Sick Leave (Medix provides paid sick leave according to state and local sick leave ordinances)

• Health Benefits / Dental / Vision (Medix Offers 6 different health plans: 3 Major Medical Plans, 2 Fixed Indemnity Plans (Standard and Preferred), and 1 Minimum Essential Coverage (MEC) Plan. Eligibility for health benefits is based on verifying that an average of 30 hours per week during the first 4 weeks of the work assignment has been met. If you meet eligibility requirements and take action to enroll, you will be covered no earlier than 60 days into your assignment, depending on plan selection(s).)

• 401k (eligible on the first 401k open enrollment date following 6 consecutive months on assignment. 401k Open Enrollment dates are 1/1, 4/1, 7/1, and 10/1)

• Short Term Disability Insurance

• Term Life Insurance Plan

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable federal, state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance (FCIHO), Los Angeles Fair Chance Ordinance for Employers (ULAC), The San Francisco Fair Chance Ordinance (FCO) , and the California Fair Chance Act (CFCA).

This position is subject to a background check based on its job duties, which may include patient care, working with vulnerable populations, access to financial and confidential information, driving, working with heavy machinery, or working in a warehouse or laboratory environment. Due to these job duties, this position has a significant impact on the business operations and reputation, as well as the safety and well-being of individuals who may be cared for as part of the job position or who may interact with staff or clients.

Deadline to apply: October 7, 2024