Job Description Job Description The Hospital Risk Pool Financial Analyst Lead manages and oversees the Team of Hospital Risk Pool Financial Analysts in preparation and delivery of financial reports, clinical presentation, and business analysis. This includes the accurate quantification and measurement of clinical outcomes. In addition, other key responsibilities include the oversight and development of processes as it applies to the tasks involved in preparation of financial reports, Board decks and client joint operations committees meeting materials. Candidate will work closely with other hospital teams to develop and package financial products and other reports catered to meet the specific needs of MPM Clients. Candidate will spearhead operationalizing the transition of the accounting functions and financial reporting into the ERP. Candidate will ensure the effective and timely delivery of quality financial/information products and reports to MPM clients. The Risk Pool Analyst Lead is a key liaison and "front-line" financial resource between Hospital Operations and Finance leadership and serves to create a forward-focused guiding vision and environment of "no surprises". The Lead will provide the reporting overview and represent the Finance team at all client joint operations committees or meeting (JOC or JOM). The Lead will be the subject matter expert of how each tasks is performed and will develop the SOP’s to establish proper controls in the quality of the reports produced by the Team of Hospital Risk Pool Financial Analysts. Duties and Responsibilities: Review and validate Hospital Capitation detail and summary reports monthly to ensure Analysts have captured in the financial reports accurately Oversee the identification of cost drivers and drill down with the Team utilizing paid claims reports monthly and/or quarterly to calculate claims cost Analyze and review lag report for claims paid and received Calculate/update IBNR model using Lag reports and/or other appropriate methodologies Recommend IBNR levels based on analysis performed Oversee and review the preparation of Risk Pool summaries by health plan, line of business and aid category. Oversee and review the preparation Risk Pool summary with combined health plans Oversee and review the preparation Capitation summary by health plan, line of business and by aid category Oversee and review the preparation of the report of claims by month and type of service Disperse reports to hospital client and Leadership and present at appropriate client JOMs Oversee and review the preparation and maintenance of daily cash flow and monthly bank reconciliation Oversee and review the preparation and submit any additional requested reports to hospital clients Oversee and review the preparation EOM financial and board packages Oversee and review the preparation ad-hoc financial analysis as requested by the Senior Manager, Supervisor, Controller, CFO and/or the client Oversee and review the preparation of other financial packages and ad-hoc reports as needed to present for Operations Meeting (JOM) Build automation of data mining needed for Risk Pool financial reporting Develops and validates queries through SQL for the successful extraction of appropriate data. Create ad hoc reporting and queries as needed to respond to management inquiries. Examine, assess, and document business operations and apply standardized procedures to ensure data integrity and process optimization. Create, review and analyze hospital financial risk pools to ensure a complete understanding of the performance of each hospital risk pool and all factors that influence its performance. Identify issues that require additional investigation and evaluation, as well as, validate discrepancies and coordinate with internal and external departments to ensure accuracy. Prepare reports on a regular basis; ad hoc, monthly and quarterly for internal use and for clients, as well as, prescheduled joint operations meetings (JOMs). Respond to inquiries from hospital clients and other departments related to hospital client needs. Prepare the narrative required to present current performance of the risk pool to clients Lead and hold meetings with clients, Analysts and internal Leadership and be able to speak to issues and concerns that may arise Lead optimized efficiency with document generation and reporting Oversee and spearhead the transition of the risk pool financial report into ERP; creating and mapping of the GL COA Oversee and spearhead the creation of effective SOP and its proper documentation for new and existing process Train teammates in completion of tasks and ensure correct application of SOP Review risk pool contracts and interpret them into a schedule of payments for tracking purposes and ensure timely settlement payments are made Ensure timely delivery of accurate reports to Client as required by Client contract and/or agreement Utilize and create PowerBI Reports from a myriad of data sources Review and monitor subordinate performance and provide necessary improvement plan for underperforming teammate as well as prepare the necessary disciplinary documentation as required by Human Resources and Leadership Minimum Job Requirements: Education: Bachelor’s degree (Accounting/Finance) or an equivalent combination of education, training and experience is required. Experience: 5 years of Physician Organization or Health Plan, Hospital Finance and/or Health Plan experience Definitive understanding of provider and health plan contracting, delineation of risk, medical terminology and standard industry reimbursement methodologies required. License/Certification/Special Training: SQL, Microsoft Suite with focus on Access and Excel, PowerBi Knowledge, Skills, and Abilities Required: Demonstrates advanced knowledge with Excel integrating with SQL Server; pivots; lookups Reprocess Excel data using Power query (ETL) Strong Microsoft SQL Server – strong SQL (‘select from where’), query tuning, Views, functions, job schedule Demonstrates advanced knowledge in Power Point and other Microsoft Office Systems required. Must be highly analytical and possess a strong grasp of finance concepts such as capital budgeting, discounted cash flow, financial statement analysis and forecasting. Strong Accounting background Ability to communicate clearly and effectively, work accurately, meet deadlines and provide effective reporting is required. Excellent interpersonal skills required to develop and maintain effective working relationships across all levels within the organization. Ability to work both independently and as part of a team. Meets tight deadlines and provides accurate information. Demonstrate ability to plan, organize and manage modest projects successfully. Detail -oriented, excellent proof reading and editing skills. Must be able to learn unfamiliar concepts quickly Requisite poise, judgment, and trustworthiness to represent MSO to internal and external groups Must work effectively in a team environment and able a supportive contributor or leader in team matters. Must conduct him or herself professionally and be capable of developing and maintaining positive, service oriented relationships with all levels of healthcare professionals, both internal and external to MPM, as well as Board members, administration and others. Must be able to plan, coordinate and prioritize resources. Maintains information in a confidential manner and complies with HIPAA laws according to policy. Ability to prioritize time and ability to adapt and change gears, take on special projects and work on tasks outside of current scope. Salary Range: $115,000 - $120,000 annually