Principal Financial Healthcare Data Analyst (Hybrid​/Troy, MI

General Summary

Under the direction of the director, the Principal Financial Healthcare Data Analyst is responsible for completing comprehensive quantitative, financial, and operational analysis related to government program revenue. This position is responsible for building, maintaining, and enhancing data models, automated reporting processes, dashboards, and analytical tools to meet Health Alliance Plan’s revenue reporting needs. The position will use internal and external data, modern data interrogation and visualization tools, and emerging technologies, including artificial intelligence (AI)-enabled productivity and analytics tools such as Microsoft Copilot, where appropriate and consistent with company policies, to improve reporting efficiency, insight generation, and decision support.

The position will provide expertise in automated reporting processes and procedures, analytical reporting, data quality review, and recommendations for meeting reporting goals. The position will collaborate with data stewards, technical teams, and subject matter experts to ensure financial goals are met and reporting outputs are complete, accurate, and well-controlled. The position will provide technical and analytical expertise to other internal departments and assist in presenting to and advising upper management and key stakeholders on forecasted plan revenue, project valuation, risk score impact on revenue, and recommended solutions.

The position will serve as a subject matter expert in Accounting and Finance for Centers for Medicare & Medicaid Services (CMS) Hierarchical Condition Category (HCC) Risk Adjustment and its role in managing CMS revenue.

• Under the direction of the Director, utilize internal and external data sources to design, implement, and maintain data models for monthly accounting cycle reporting of government program anticipated revenue, annual reporting of Medical Loss Ratio (MLR), and annual accounting of subsidized pharmacy program funds related to Medicare Advantage Part C, Medicare Advantage Part D, and Medicare-Medicaid Program reporting.
• Monitor, interpret, disseminate information, and implement changes, as applicable to Medicare programs, based on Centers for Medicare & Medicaid Services (CMS) and/or State ongoing communications to health plans specific to the financial analyst role.
• Design and implement appropriate processes, quality checks, and control mechanisms to ensure that data models, data extracts, table updates, artificial intelligence (AI)-assisted outputs, and reporting logic are complete, accurate, explainable, and appropriately documented.
• Utilize data sets, financial acumen, and appropriate analytical tools to estimate the impact on revenue accruals for financial reporting and to report risk scores. Prepare and deliver well-organized reports that reflect risk adjustment project valuation, the basis for recommendations to revenue accruals, and the analytic methods used to determine findings.
• Serve as a primary user of the Hierarchical Condition Category (HCC) Risk Adjustment vendor application. Monitor vendor systems for assessment data submission and acceptance status, progress of risk projects, use of vendor supplemental data to assist in risk adjustment project pricing, and ongoing assessment of data integrity and completeness issues that may impact risk adjustment project valuation.
• Design processes to produce automated reports, dashboards, and data extracts at multiple reporting levels required within the organization, including contract, benefit plan, provider organization, and group levels.
• Support leadership in the development and implementation of strategic financial initiatives, product offerings, and other strategic business programs through the extraction, analysis and summarization of appropriate data sets and benchmarks. Support to such projects include but are not limited to annual bid preparation, employer group rate renewals, financial reporting for Henry Ford Health corporate initiatives.
• Use modern productivity, analytics, and automation technologies, including artificial intelligence (AI)-enabled tools such as Microsoft…