Healthcare Data Analytics Jobs in Michigan (NOW HIRING)

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 Copilot, Microsoft Power BI, Microsoft Excel, structured query language (SQL), and other approved data interrogation tools, to enhance analysis, summarize findings, identify trends, and improve the efficiency and consistency of recurring financial reporting.

Coordinate with leadership and multiple departments within the organization, including but not limited to Actuarial Services, Underwriting, Financial Analysis, Financial Services, Risk Adjustment, Information Technology (IT)-Business Intelligence, Provider Services, Network Management, Data Analytics, and Henry Ford Health Revenue Cycle for expertise in government programs, payment methods, revenue attribution, and risk adjustment.

Design and implement appropriate processes and control mechanisms to ensure that generated reports reconcile to the general ledger. Maintain documentation for reported accruals to support financial audit requirements and future reconciliation with Centers for Medicare & Medicaid Services (CMS) payments.

Coordinate and communicate business unit functional requirements and technical solutions with Information Technology (IT) capability resources by designing and documenting functional specifications. Develop and maintain policies and procedures specific to government revenue, risk score reporting, data governance, and appropriate use of approved analytics and artificial intelligence (AI)-enabled tools.

Represent government program revenue and Risk Adjustment reporting needs on corporate subcommittees and workgroups when upgrades or changes are made to company or vendor systems or processes. Serve as a subject matter expert contributing to the development and tracking of internal dashboards, key performance indicators (KPIs), and other management reporting tools.

Coordinate technical modifications with internal teams, including Information Technology (IT)-Business Intelligence, Risk Adjustment, and vendors, such as data extraction, automation enhancements, dashboard updates, reporting logic, and table updates to correct configuration issues affecting monthly reporting processes as required.

Utilize Centers for Medicare & Medicaid Services (CMS) government program regulatory communications and knowledge of Risk Adjustment program operations, Risk Adjustment payment methods, and Hierarchical Condition Category (HCC) coding to assess the impact on government program financial reporting.

Identify and drive continuous improvement initiatives that improve the efficiency, accuracy, transparency, and effectiveness of reports and reporting processes, including responsible use of automation, artificial intelligence (AI)-enabled tools, and modern analytics platforms.

Perform other duties as assigned.

Bachelor’s degree in Computer Information Systems, Statistics, Business, Accounting, Finance, Health Care Services Management, or other technical and quantitative focus.

Minimum of five (5) years of progressive analytical experience in healthcare data, managed care operations, finance, accounting, or related business analytics, preferably in Medicare programs, with experience related to revenue, payment methods, and Hierarchical Condition Category (HCC) risk adjustment principles.

Minimum three (3) years’ experience with data interpretation, statistical analysis, reporting, claims, clinical and financial data, budgeting and forecasting, and trend analysis.

Advanced knowledge of Accounting and Finance principles to support regulatory state and federal reporting, operational planning, controls, budgets, and development of operational strategies, objectives, and goals.

Minimum three (3) years of experience using information technology, analytics, and data interrogation tools to extract, validate, analyze, and report data. Experience may include structured query language (SQL), Microsoft Excel, Microsoft Power BI, Python, R, Oracle, Microsoft Developer Studio, accounting applications, artificial intelligence (AI)-enabled productivity or analytics tools such as Microsoft Copilot, or other comparable reporting, automation, or data visualization tools.

HAP is a Michigan-based, nonprofit health plan that provides health coverage to individuals, companies and organizations. A subsidiary of Henry Ford Health System, we partner with doctors, employers and community groups to enhance the overall health and well-being of the lives we touch. With more than 1,100 dedicated and passionate employees, our goal is to make health care easy for our members.

Under the leadership of President and CEO Robert G. Riney, Henry Ford Health is a

$6 billion integrated health system comprised of six hospitals, a health plan, and 250+ sites

including medical centers, walk-in and urgent care clinics, pharmacy, eye care facilities and

other healthcare retail. Established in 1915 by auto industry pioneer Henry Ford, the health system

now has 32,000 employees and remains home to the 1,900-member Henry Ford Medical Group, one

of the nation’s oldest physician groups. An additional 2,200 physicians are also affiliated with the

health system through the Henry Ford Physician Network. Henry Ford is also one of the region’s

major academic medical centers, receiving between $90-$100 million in annual research funding and

remaining Michigan’s fourth largest NIH-funded institution. Also an active participant in medical

education and training, the health system has trained nearly 40% of physicians currently practicing

in the state and also provides education and training for other health professionals including nurses,

pharmacists, radiology and respiratory technicians. visitHenryFord.com .

Whether it's offering a new medical option, helping you make healthier lifestyle choices or

making the employee enrollment selection experience easier, it's all about choice. Henry

Ford Health System has a new approach for its employee benefits program - My Choice

Rewards. My Choice Rewards is a program as diverse as the people it serves. There are

dozens of options for all of our employees including compensation, benefits, work/life balance

and learning - options that enhance your career and add value to your personal life. As an

employee you are provided access to Retirement Programs, an Employee Assistance Program

(Henry Ford Enhanced), Tuition Reimbursement, Paid Time Off, Employee Health and Wellness

and access to day care services at Bright Horizons Midtown Detroit, and a whole host of other

benefits and services. Employee'sclassified as contingent status are not eligible for benefits

Equal Employment Opportunity / Afforative Action Employer Henry Ford Health System is

committed to the hiring, advancement and fair treatment of all individuals without regard to

race, color, creed, religion, age, sex, national origin, disability, veteran status, size, height,

weight, marital status, family status, gender identity, sexual orientation, and genetic information,

or any other protected status in accordance with applicable federal and state laws.

Create and manage profiles for future opportunities.