Senior Financial Reporting Data Analyst

Summary

The Senior Financial Reporting Data Analyst provides avenues for management to make important decisions through detecting trends, creating reports, and communicating them.  Helps the Contracting and Operations department during negotiations by determining impacts under different scenarios.  Be involved with Data Analyst (DA) team in support of financial operations through the development, programing, maintenance and organization of the automated extraction of data from various sources.  Ideal Candidate should have experience working through large data sets, identifying data schematics to determine the appropriateness of sources and have the necessary background to understand contract rates, financial statements and accounting entries.  Candidate must complete additional assignments and projects as required and be a key supporting resource for Sr. Finance Supervisor, Finance Manager, Director of Finance, VP Finance/Corporate Controller, and CFO or other team members.

Duties and Responsibilities:

• Design, and if needed, improve upon existing reporting requirements with all clients’ financial performance by required segments (by Health Plan and Lines of Business, Aid Category) using the ERP software and reports pulled from operational system (EZ-Cap).
• Accurately analyze reports, identifying changes and key trends, then effectively communicate findings to FA and management.
• Work with Senior Financial Data Analyst in utilizing Power BI to facilitate additional financial performance reports by Primary Care Provider.  Also with streamlined views of key cost areas to be shared with other departments and clients.
• Work with Contracting and Operations department in designing, building and maintaining contract rate tables in SQL and develop an automated process to reconcile expected payment to payment received as outlined in the contract for all required reporting segments.
• Work with Contracting and Operations department during health plan negotiations by determining financial impacts of different capitation rates and Division of Financial Responsibility (DoFR) scenarios for all required reporting segments.
• Build and maintain databases and perform periodic updates as necessary to ensure accuracy and relevance.
• Regularly examine data reports to locate and resolve any issues throughout by working with Financial Analyst (FA) and Data Analyst (DA) teams.
• Assist DA team working with department management to identify areas of business process improvement.  Includes examining, assessing, and documenting business operations and procedures to ensure data integrity and process optimization.
• Assist in automating data-entry intensive tasks such as month-end report validations or financial entries preparation.
• Prepare ad-hoc business reports as requested by Sr. Finance Supervisor, Finance Manager, Director of Finance, VP Finance/Corporate Controller, CFO and/or the client.

Minimum Job Requirements:

• Bachelor’s degree or an equivalent combination of education, training and experience as a Financial or Business Analyst is required.
• 5+ years of Physician Organization or Health Plan, Hospital Finance and/or Health Plan experience (operations, objectives, processes and information flow).
• Definitive understanding of provider and health plan contracting, delineation of risk, medical terminology and standard industry reimbursement methodologies required.  Knowledge of CPT, HCPC, DRG, ICD-9, ICD-10 and NDC coding a plus.
• Strong understanding and experience using MS Excel (VBA’s, macros, Pivot tables, lookups, Power Pivot), & Access required.
  • Integrating with SQL Server
  • Reprocess Excel data using Power Query (ETL)
  • Loading data from Excel into SQL Server via SSIS
• Strong Crystal/SQL knowledge and background
• Familiarity with Sage100, EZ-Cap
• Strong background with MS Power BI and Tableau a plus.

Knowledge, Skills, and Abilities Required:

• Must be highly analytical & possess a strong grasp of finance concepts such as financial statement analysis, accounting entries.

• Work accurately and efficiently, meet deadlines under pressure and provide actionable reporting is required.
• Strong analytical thinking to determine reasonableness and the ability to provide meaningful solutions.
• Detail-oriented, tendency to pay close attention to small details that could impact results and be proactive communicating them.
• Ability to work complex projects independently with minimal oversight.
• Success managing and multi-tasking across multiple reports, projects and tasks with ongoing deadlines
• Ability to communicate clearly and effectively.
• Strong interpersonal skills and ability to interact with multiple departments and management
• Maintains information in a confidential manner and complies with HIPAA laws according to policy.

Salary Range:

• $95,000 - $130,000 per year