General Summary:
To assist the Revenue Management and Risk Adjustment department (RMRA) in ensuring the Financial Reporting and Analysis responsibilities for the oversight of the Revenue Management and/or Risk Adjustment programs for all government funded product lines. Under direction of Department Manager:
Principal Duties and Responsibilities:
Coordination of weekly and ad hoc data submissions, monitoring data for accurate tracking and reporting of medical, drug claim data and membership data to CMS EDPS and Edge Server. Produce, distribute, monthly, quarterly, and annual key performance indicators (KPI's) and error/rejection detail for all report submissions and external vendor support system data correction.
Premium reconciliation reports for monthly financial close; file payment issues with CMS and monitor response; monitor MMR, MOR, MAO-002, and MAO-004 loads; estimate risk adjustment premium impact for final reconciliation with CMS; allocation of premium to at-risk.
Develop and enhance reporting capabilities for financial and operational performance.
Annual financial reporting activities including CMS bid filings, HCR Premium Development, RFP on financial Risk Adjustment projects, Employer Group Rate Renewals, financial audits, CMS Attestations, premium and member revenue budgets, Medical Loss Ratio reporting.
Produce reports to provide M&B discrepancies in the premium payments from CMS. Team with Membership & Billing staff to identify and resolve enrollment, claims, provider and premium discrepancies. Develop detail to support reporting discrepancies to CMS for discrepancies outside of M&B's influence.
Monitor CMS material and calls for required compliance and system or process changes. Work with management on design and implementation of the changes.
Development and maintenance of departmental policies and procedures for audit purposes and support department in adhering to HAP Compliance department requirements. Complete routine monitoring of departmental procedures and documentation to demonstrate internal (MAR) and external (CMS) audit readiness.
Coordinate and assign tasks related to testing IT projects and new system related initiatives and CMS software releases.
Analyze department reports to identify data integrity issues, system and programming problems, and work with management to develop and implement improvement solutions.
Assist department in performing routine assignments, ad-hoc projects and meeting established deadlines. Engage assistance of departmental support analysts in completion of required responsibilities where appropriate.
Perform other related duties as assigned.
Education/Experience Required:
Bachelor's degree in Accounting, Finance, Business Administration or a related field (must include financial or accounting related course work). Master's degree preferred (Finance, Business Administration, etc.)
Completion of Advanced Access, Excel, GQL, Cognos, or SQL training preferred.
Two (2) years of Accounting/Finance business related experience required.
Two (2) years managing projects and initiatives designed to improve business operations required.
Three (3) to Five (5) years of experience developing, analyzing, interpreting & trending data preferred.
Experience with Medicare Advantage, Medicare Part D, Medicaid or Qualified Health Plans preferred.
Experience in health care finance preferred.
Affordable Care Act (ACA) experience or knowledge preferred.
Knowledge of Alteryx One preferred.
Proficient knowledge of Windows - Excel and/or Access.
Proficient at using various data sources to develop relevant reporting tools, and to use those tools to enhance processes and procedures.
Knowledge of accounting and financial reporting principles and business functions.
Ability to research, analyze, interpret, trend, and implement process improvement initiatives.
Ability to collect and prepare data for written/oral presentation - report creation and generation.
The ability to work effectively with all levels within the organization.
Excellent written and verbal communication skills.
Well defined problem solving and decision-making skills.
Knowledge of Facets or other Health Insurance Claims/Membership systems preferred.
Knowledge of Medicare and/or Medicare Advantage processes preferred
Experience with Cognos, SQL Developer, GQL reporting tool, CDW, Data Factory. preferred.
Additional Information