Financial Analyst (Data) - Revenue Cycle Management

FiSource Group

Financial Analyst (Data) - Revenue Cycle Management

Tempe, AZ
Full Time
Paid
  • Responsibilities

    The Role:

    This role is open with one of our top healthcare clients. The Financial Analyst/Senior Financial Analyst - RCM will take the lead on developing tools, methodologies, and data analytics to support the Revenue Cycle Management/Billing team in monitoring client financial data and performance metrics. This role will collaborate with the RCM Client Success Team to analyze charges, payments, encounters, A/R, and denials data for clients, and improve performance by decreasing the percentage of denials, improving collections on claims, and identifying practice/payor trends.

    Opportunity Highlights:

    • Opportunity to take on a visible, impactful role, working directly under the Corporate Finance Manager, and supporting the lifeblood of the company – the RCM process. This role will perform data analysis that will directly drive and maximize the company’s top line performance.
    • Leverage advanced SQL and Data Analytics tools to manipulate, analyze, and present critical data, and tell highly informative stories for a core group of internal customers and deliverables.
    • Join a company that seeks to develop and grow talent, where leaders have moved up from individual contributors to Director, VP, and even C-level roles.
    • Long-term career path towards owning and building a full analytics function within Revenue Cycle Management.
    • Play a key role in a company mission that will transform and improve a healthcare system in need of evolution and improved accessibility.
    • Enjoy a flexible, straight forward, open-door management style. Work hard but also enjoy balance and camaraderie in a culture comprising down-to-earth people, no-drama attitudes, and a team mindset.
    • Key Performance Metrics & Objectives:

      • Lead execution of RCM data collection, reporting, analysis, and delivery of key metrics, developing and maintaining consistent, actionable data for the billing department.
      • Leverage skills in SQL, Power Query, and Excel to pull / manipulate large data sets from core systems such as the NextGen patient management, Microsoft Dynamics ERP, and ADP.
      • Work with the billing team to determine analytics needs, and develop data sets and analyses in Excel (and PowerBI to a lesser extent) that illuminate revenue cycle trends and answer question/solve issues regarding RCM performance.
      • Manage the SQL query and data collection process from query writing to validation - Design SQL queries from scratch, research and validate relationships across multiple tables and databases, and validate output against source systems and existing reports to ensure accuracy.

        Core Day-to-Day Accountabilities:

      • Identify opportunities to improve revenue and collection performance through analysis of charges, claim denials, payments, accounts receivable, and escalated client metrics.
      • Monitor operational key performance indicators to identify the root cause of poor performing metrics and make recommendations for improvement.
      • Assist management in developing meaningful reports, KPIs and summaries that provide support to the RCM team.
      • Generate standard and custom statistical and analytical reports as requested by RCM Leadership using the NextGen patient management system, Microsoft Excel, and/or SQL.
      • Complete Ad Hoc report requests as assigned by management.
      • Establish complementary and collaborative relationships with appropriate stakeholders/committee members, and RCM Leadership.
      • Maintain and/or automate frequency-based reports and dashboards, and manage any update/enhancement requests from RCM leadership
      • Think critically about the business – continuously ask WHY, determine the story behind the data, and translate this into answers to questions and solutions to problems.

        Core Competencies:

    • 3 years of experience in financial/data analysis. Healthcare industry experience is required. 
    •  Deep understanding of database concepts and structures, including ability to write, troubleshoot, and validate queries using T-SQL or similar language.
    • Mastery of business intelligence visualization tools including Power BI.
    • Working experience in creating, maintaining and troubleshooting data and reports, with in-depth data validation of new reports/queries against source systems and existing reporting products.
    • Advanced excel skills such as the ability to use formulas, VLOOKUPS, HLOOKUPS, and index matches to analyze data, tables, and formatting. Strong skills in Power Query and Power Pivot.
    • Demonstrated expertise OR aptitude for learning concepts in medical billing, front-office, physician practice management, claims processing and root cause analysis, and healthcare business processes.
    • Deep knowledge or willingness to build knowledge of the revenue cycle process for claim submission, medical insurance policies, ICD-10 and CPT coding guidelines, common denial reasons, Fee for Service, Capitation, and Workers Compensation.
    • Excellent time management skills in order to produce timely reporting, including the ability to swiftly move between projects to support high-priority, short turn around, ad hoc requests. Ability to quickly get up to speed with new systems and unfamiliar data relationships.
    • Experience delivering reporting to C-Suite / Board-level stakeholders, and working with outside partners.
    • Bachelor’s Degree, MBA a plus.
    • Strong plus for experience with Great Plains, FRx Reporting, and/or Crystal Reporting.

      Core Company / Team Fit Characteristics:

    • Independent. You think for yourself and self-motivate to deliver work product on time. You take the initiative to dig deep and learn, speak up with ideas, while asking questions and for help when needed.
    • Creative Problem Solver. You are tenacious and persistent in finding answers, determining root causes of outliers, and in figuring out creative solutions to solve team or business problems.
    • Sense of humor. You’re looking for a team that is professional and delivers excellent work product, but all with a sense of humor and willingness to relax and have fun together.
    • Flexible. You are willing to flex and roll with the punches when priorities shift or when there is a need to shift urgency to a new or different project.
    • Highly Ethical. You bring integrity to everything you do and maintain the utmost confidentiality in working with sensitive data.
  • Compensation
    $110,000 per year