Healthcare Data Analyst, Medicaid - Indianapolis Health

OverviewMilliman's Indianapolis Health Practice is seeking a highly skilled and detail-oriented Healthcare Data Analyst, Medicaid to join our Data Engineering, Architecture, and Science (I.D.E.A.S.) team. The role will be responsible for analyzing and interpreting Medicaid data to support decision-making processes, improve healthcare outcomes, and ensure compliance with regulatory requirements. The ideal candidate will have a strong background in data analysis, healthcare systems, and a keen understanding of Medicaid policies and procedures. This role involves close collaboration with Milliman business teams to deliver data artifacts on a monthly, weekly, and ad-hoc basis. Proficiency in SQL, Databricks, Python, Azure, and AWS are essential; Experience with SAS, R, and RShiny are a plus.ResponsibilitiesAs part of the I.D.E.A.S. team at Milliman, this role will analyze and interpret Medicaid data to support decision-making processes, improve healthcare outcomes, ensure compliance with regulatory requirements, and streamline claims management data processing. Below are enhanced and specific responsibilities aligned with the team's needs:Data Collection and Management:Collect, clean, and manage large datasets from various sources including electronic health records (EHR), claims data, and other healthcare databasesEnsure data integrity, accuracy, and completenessClaims Management Data Processing:Analyze claims data to identify trends, patterns, and anomalies in Medicaid claimsDevelop and implement processes for claims data validation and reconciliationCollaborate with claims management teams to streamline data processing workflows and ensure timely and accurate claims adjudicationData Analysis and Modeling:Conduct complex data analysis to identify trends, patterns, and insights related to Medicaid services and utilizationDevelop and implement analytical models using SQL, Databricks, and PythonUtilize Azure and AWS for data storage, processing, and analysisReporting and Visualization:Create comprehensive reports, dashboards, and visualizations to communicate findings to stakeholdersUse tools such as Tableau, Power BI, and RShiny to develop interactive visualizationsPresent data insights and recommendations to healthcare providers, administrators, and policymakersCompliance and Quality Assurance:Ensure compliance with federal and state Medicaid regulations and reporting requirementsConduct quality assurance checks to ensure data accuracy and reliabilityCollaboration and Support:Work closely with Milliman business teams, including IT, clinical staff, and management, to support data-driven decision-makingProvide training and support to staff on data-related tools and processesContinuous Improvement:Identify opportunities for process improvements and implement best practices in data analysis and managementStay updated with the latest trends and advancements in healthcare data analytics and Medicaid policiesDeliverables:Deliver data artifacts post-analysis on a monthly, weekly, and ad-hoc basis to Milliman business teamsEnsure timely and accurate delivery of data insights and recommendationsQualificationsExcellent analytical and problem-solving skillsStrong attention to detail and accuracyAbility to interpret complex data and present findings in a clear and concise mannerStrong communication and interpersonal skillsAbility to work independently as well as part of a teamAbility to support data analysis projects, develop reports and dashboards, and assist in data cleaning and preparationKnowledge of healthcare data standards and privacy regulations (e.g., HIPAA)Required:Bachelor's degree in Data Science, Statistics, Public Health, Health Informatics, or a related fieldMinimum of 5 years of experience in data analysis, preferably in a healthcare or Medicaid environmentStrong understanding of Medicaid policies, procedures, and regulationsFirst-hand experience with SQL, Databricks, and PythonProficiency in 1 or more cloud platforms, such as, Azure and AWSPreferred:Master's degree in Data Science, Statistics, Public Health, Health Informatics, or a related fieldExperience with one or more: SAS, R, and RShinyThe TeamAs a member of the Indy Data Engineering, Architecture, and Science (I.D.E.A.S.) team, you will provide analytical support services to our key state clients and their dedicated core teams, under the mentorship of senior data consultants. Our data team works cross-functionally with professionals from a variety of disciplines and backgrounds including: actuarial, policy, finance, pharmacy, data management and more. Our practice has been strategically structured to best serve state Medicaid and other health and human service agency clients. The Indianapolis Health practice has 215+ full-time employees, from various academic and professional backgrounds, working together with the common goal of best serving our clients' needs. We offer challenging projects, expert colleagues, a collaborative environment, and diverse client projects for all employees to work, learn, and grow with our practice.LocationThe 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.Benefits At Milliman, we focus on creating an environment that recognizes - and meets - the personal and professional needs of the individual and their family. We offer competitive benefits which include the following based on plan eligibility:Medical, dental and vision coverage for employees and their dependents, including domestic partnersA 401(k) plan with matching program, and profit sharing contributionEmployee Assistance Program (EAP)A discretionary bonus programPaid Time Off (PTO) starts accruing on the first day of work and can be used for any reason; full-time employees will accrue 15 days of PTO per year, and employees working less than a full-time schedule will accrue PTO at a prorated amount based on hours workedFamily building benefits, including adoption and fertility assistance and paid parental leave up to 12 weeks for employees who have worked for Milliman for at least 12 months and have worked at least 1,250 hours in the preceding 12-month periodA minimum of 8 paid holidaysMilliman covers 100% of the premiums for life insurance, AD&D, and both short-term and long-term disability coverageFlexible spending accounts allow employees to set aside pre-tax dollars to pay for dependent care, transportation, and applicable medical needsWho We AreIndependent for 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 Opportunity All qualified applicants will receive consideration for employment, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.#LI-KM1#LI-HYBRIDEqual Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThe contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)