Hospital Risk Pool Financial Analyst
Benefits:
• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Vision insurance
• Wellness resources
Summary:
The Hospital Risk Pool Financial Analyst leads the preparation and delivery of financial, clinical and business analysis. This includes the accurate quantification and measurement of clinical outcomes. In addition, other key responsibilities include the oversight and development of operating plans and financial solutions that promote an environment of effective decision-making, revenue enhancement, cost efficiency, and sound business practices. 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 customers. Candidate will ensure the effective and timely delivery of quality financial/information products and reports to MPM clients. The risk pool analyst 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"
Duties and Responsibilities:
• Obtain and review Hospital Capitation detail and summary reports monthly
• Run paid claims reports monthly and/or quarterly to calculate claims cost
• Run lag report for claims paid and received
• Calculate/update IBNR model using Lag reports and/or other appropriate methodologies
• Prepare Risk Pool summaries by health plan, line of business and aid category.
• Prepare Risk Pool summary with combined health plans
• Prepare Capitation summary by health plan, line of business and by aid category
• Prepare Report of claims by month and type of service
• Disperse reports to hospital client and MSO Financial Analyst
• Prepare and maintain daily cash flow and monthly bank reconciliation
• Prepare and submit any additional requested reports to hospital clients
• Prepare EOM financial and board packages
• Prepare ad-hoc financial analysis as requested by the Controller, CFO and/or the client
• Prepare other financial packages and ad-hoc reports as need for Operations Meeting
• 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 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.
• Optimize efficiency with document generation and reporting.
Minimum Job Requirements:
Education: Bachelor’s degree (Accounting/Finance) or an equivalent combination of education, training and experience is required.
Experience: 3+ 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, 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.
• 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.
• Advanced knowledge of Microsoft Office Suite, including but not limited to Word, Excel, and PowerBi.
• Ability to prioritize time
• Ability to adapt and change gears, take on special projects and work on tasks outside of current scope.
• Strong Microsoft SQL Server – strong SQL (‘select from where’), query tuning, Views, functions, job schedule
• Excel - integrating with SQL Server; pivots; lookups
• Create PowerBI Reports from a myriad of data sources
• Reprocess Excel data using Power query (ETL)
Working Conditions and Physical Effort:
• Regular and reliable attendance is an essential function of the position.
• Work is normally performed in a typical interior/office work environment.
• No or very limited physical effort required. No or very limited exposure to physical risk.
This is a remote position.
Apply Now
Apply Now
• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Vision insurance
• Wellness resources
Summary:
The Hospital Risk Pool Financial Analyst leads the preparation and delivery of financial, clinical and business analysis. This includes the accurate quantification and measurement of clinical outcomes. In addition, other key responsibilities include the oversight and development of operating plans and financial solutions that promote an environment of effective decision-making, revenue enhancement, cost efficiency, and sound business practices. 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 customers. Candidate will ensure the effective and timely delivery of quality financial/information products and reports to MPM clients. The risk pool analyst 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"
Duties and Responsibilities:
• Obtain and review Hospital Capitation detail and summary reports monthly
• Run paid claims reports monthly and/or quarterly to calculate claims cost
• Run lag report for claims paid and received
• Calculate/update IBNR model using Lag reports and/or other appropriate methodologies
• Prepare Risk Pool summaries by health plan, line of business and aid category.
• Prepare Risk Pool summary with combined health plans
• Prepare Capitation summary by health plan, line of business and by aid category
• Prepare Report of claims by month and type of service
• Disperse reports to hospital client and MSO Financial Analyst
• Prepare and maintain daily cash flow and monthly bank reconciliation
• Prepare and submit any additional requested reports to hospital clients
• Prepare EOM financial and board packages
• Prepare ad-hoc financial analysis as requested by the Controller, CFO and/or the client
• Prepare other financial packages and ad-hoc reports as need for Operations Meeting
• 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 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.
• Optimize efficiency with document generation and reporting.
Minimum Job Requirements:
Education: Bachelor’s degree (Accounting/Finance) or an equivalent combination of education, training and experience is required.
Experience: 3+ 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, 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.
• 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.
• Advanced knowledge of Microsoft Office Suite, including but not limited to Word, Excel, and PowerBi.
• Ability to prioritize time
• Ability to adapt and change gears, take on special projects and work on tasks outside of current scope.
• Strong Microsoft SQL Server – strong SQL (‘select from where’), query tuning, Views, functions, job schedule
• Excel - integrating with SQL Server; pivots; lookups
• Create PowerBI Reports from a myriad of data sources
• Reprocess Excel data using Power query (ETL)
Working Conditions and Physical Effort:
• Regular and reliable attendance is an essential function of the position.
• Work is normally performed in a typical interior/office work environment.
• No or very limited physical effort required. No or very limited exposure to physical risk.
This is a remote position.
Apply Now
Apply Now