Financial Analyst – Indianapolis Health

OverviewMilliman's Indianapolis Health practice is seeking a Financial Analyst to support our consulting work with Medicaid state agencies. As a Financial Analyst, you will have an opportunity to work with a multi-disciplinary team to analyze cost/expense reporting for healthcare and human service entities, including state Medicaid agencies, managed care organizations, healthcare providers, and child welfare organizations. Analysis will involve comparing utilization, service expense, revenue, and administrative expenses across types of services, lines of business, and rate cohorts. This role will focus on cost reporting and rate setting projects; however, duties include supporting projects with a wide range of quantitative and qualitative analysis, including program research and design. Successful financial analysts will be able to understand and glean insight from the financial data that will help Medicaid state agencies in managing their programs efficiently and making informed policy and program decisions. They should also be able to communicate insights in a clear and professional manner. This role is part of a dynamic client delivery team and offers mentorship from experienced colleagues.ResponsibilitiesIn this role, you will:Collect, review, and provide feedback on cost and other financial reports submitted by third-party entities serving health and human service agenciesEvaluate cost and other financial reports for compliance with provided instructions and applicable regulatory guidancePerform reconciliation of cost reports relative to a general ledger, encounter data, and/or audited financial statementsRecognize and identify reporting errors and develop proposed solutionsCommunicate results to internal stakeholders, verbally and written, within all levels of our organizationPerform ad-hoc reconciliations and work on special projects, as requiredWork both independently and collaboratively on projectsEnsure quality assurance and peer review are completed on all client deliverablesQualificationsFoundational knowledge of accounting/financial statements and managerial/cost accounting for healthcare entitiesUnderstanding of insurance concepts such as reserving and premium rate settingUnderstanding of health economics concepts such as medical loss ratio, underwriting margin, cost and utilization metricsExperience with Microsoft Excel or other similar software in performing quantitative analysisBasic coding ability in one or more languages (e.g., SAS, R, SQL) with the desire to learn othersStrong written and oral communication skillsAbility to utilize critical thinking, exhibit problem solving capabilities, and demonstrate learning agilityOrganizational and time management skills, ability to prioritize and perform effectively in a fast-paced, deadline-driven environmentBasic knowledge of Gen AI tools, how to utilize AI to enhance productivity, and potential ethical considerations or concernsRequiredBachelor's degree in accounting, finance, business management, or a related field of studyAdvanced proficiency in Visual Basic for Applications (VBA) with a demonstrated ability to write, debug, and optimize complex macros and automation scripts, particularly within Microsoft ExcelPreferred1 to 3 years of full-time professional work or Internship experience in financial analytics, cost reporting, or relatedMaster’s degree in accounting, finance, business management, or a related quantitative fieldExperience working within a health-related company, and/or consulting firm environment(s)Individual(s) must be legally authorized to work in the United States without the need for immigration support or sponsorship from Milliman now or in the future.The TeamThe Indianapolis Health Practice is strategically structured to serve state Medicaid agencies and other health and human services agencies. The Financial Reporting team works in close collaboration with professionals from our core state Medicaid teams to best serve each of our state clients’ unique needs. As a new addition to our team, you will work in a matrix environment learning from seasoned consultants on a variety of data analysis projects. Our dynamic team of consultants, accounting professionals, software engineers, and analysts provide our clients with regulatory and contractual financial reporting support and insightLocationThe person hired for this role will work in a dynamic, hybrid environment, with 2 to 3 days per week of on-site work required in our Indianapolis office on a weekly basis.CompensationThe overall salary range for this role is $65,200 - $126,200. A combination of factors will be considered, including, but not limited to, education, relevant work experience, qualifications, skills, certifications, etc. In addition, we offer a performance-based bonus-plan, profit sharing, and generous benefits.$65,200 - $104,200 if overall experience is less than 2 years; and$78,800 - $126,200 for experience greater than 2 years.BenefitsWe offer a comprehensive benefits package designed to support employees’ health, financial security, and well-being. Benefits include:Medical, Dental and Vision - Coverage for employees, dependents, and domestic partnersEmployee Assistance Program (EAP) - Confidential support for personal and work-related challenges401(k) Plan - Includes a company matching program and profit-sharing contributionsDiscretionary Bonus Program – Recognizing employee contributionsFlexible Spending Accounts (FSA) - Pre-tax savings for dependent care, transportation, and eligible medical expensesPaid Time Off (PTO) – Begins accruing on the first day of work. Full-time employees accrue 15 days per year, and employees working less than full-time accrue PTO on a prorated basis.Holidays - A minimum of 10 observed holidays per yearFamily Building Benefits including Adoption and fertility assistancePaid Parental Leave - Up to 12 weeks of paid leave for employees who meet eligibility criteriaLife Insurance & AD&D - 100% of premiums covered by MillimanShort-Term and Long-Term Disability – Fully paid by MillimanWho We AreIndependent for over 75 years, Milliman delivers market-leading services and solutions to clients worldwide. Today, we are helping companies take on some of the world’s most critical and complex issues, including retirement funding and healthcare financing, risk management and regulatory compliance, data analytics and business transformation.Milliman invests in skills training and career development, and gives all employees access to a variety of learning and mentoring opportunities. Our growing number of Milliman Employee Resource Groups (ERG’s) are employee-led communities that influence policy decisions, develop future leaders, and amplify the voices of their constituents. We encourage our employees to give back to their varied professions, including leadership in professional organizations. Please visit our web site https://www.milliman.com/en/social-impact to learn more about Milliman’s commitments to our people, diversity and inclusion, social impact and sustainability.Through a team of professionals ranging from actuaries to clinicians, technology specialists to plan administrators, we offer unparalleled expertise in employee benefits, investment consulting, healthcare, life insurance and financial services, and property and casualty insurance.Equal OpportunityAll qualified applicants will receive consideration for employment, without regard to race, color, religion, sex, sexual orientation, national origin, disability, or status as a protected veteran.