Financial Analyst Data Revenue Cycle Management Job at Fisource Group in Tempe

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 over many years from individual contributors to Director, VP, and even C-level roles. 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, in a healthcare business or similar business model that generates large data sets; preferred multi-site/state experience. 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.