HEALTHCARE DATA ANALYST, MEDICAID - INDIANAPOLIS HEALTH

Company: Milliman
Location: Indianapolis
Posted on: November 10, 2024

Job Description:

Description Overview Milliman'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. Responsibilities As 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 databases
• Ensure data integrity, accuracy, and completeness
  
• Claims Management Data Processing:
  • Analyze claims data to identify trends, patterns, and anomalies in Medicaid claims
  • Develop and implement processes for claims data validation and reconciliation
  • Collaborate with claims management teams to streamline data processing workflows and ensure timely and accurate claims adjudication
    
  • Data Analysis and Modeling:
    • Conduct complex data analysis to identify trends, patterns, and insights related to Medicaid services and utilization
    • Develop and implement analytical models using SQL, Databricks, and Python
    • Utilize Azure and AWS for data storage, processing, and analysis
      
    • Reporting and Visualization:
      • Create comprehensive reports, dashboards, and visualizations to communicate findings to stakeholders
      • Use tools such as Tableau, Power BI, and RShiny to develop interactive visualizations
      • Present data insights and recommendations to healthcare providers, administrators, and policymakers
        
      • Compliance and Quality Assurance:
        • Ensure compliance with federal and state Medicaid regulations and reporting requirements
        • Conduct quality assurance checks to ensure data accuracy and reliability
          
        • Collaboration and Support:
          • Work closely with Milliman business teams, including IT, clinical staff, and management, to support data-driven decision-making
          • Provide training and support to staff on data-related tools and processes
            
          • Continuous Improvement:
            • Identify opportunities for process improvements and implement best practices in data analysis and management
            • Stay updated with the latest trends and advancements in healthcare data analytics and Medicaid policies
              
            • Deliverables:
              • Deliver data artifacts post-analysis on a monthly, weekly, and ad-hoc basis to Milliman business teams
              • Ensure timely and accurate delivery of data insights and recommendations
                
                
                Qualifications
                • Excellent analytical and problem-solving skills
                • Strong attention to detail and accuracy
                • Ability to interpret complex data and present findings in a clear and concise manner
                • Strong communication and interpersonal skills
                • Ability to work independently as well as part of a team
                • Ability to support data analysis projects, develop reports and dashboards, and assist in data cleaning and preparation
                • Knowledge 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 field
                  • Minimum of 5 years of experience in data analysis, preferably in a healthcare or Medicaid environment
                  • Strong understanding of Medicaid policies, procedures, and regulations
                  • First-hand experience with SQL, Databricks, and Python
                  • Proficiency in 1 or more cloud platforms, such as, Azure and AWS
                    Preferred:
                    • Master's degree in Data Science, Statistics, Public Health, Health Informatics, or a related field
                    • Experience with one or more: SAS, R, and RShiny
                      The Team As 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. Location The 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 partners
                      • A 401(k) plan with matching program, and profit sharing contribution
                      • Employee Assistance Program (EAP)
                      • A discretionary bonus program
                      • Paid 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 worked
                      • Family 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 period
                      • A minimum of 8 paid holidays
                      • Milliman covers 100% of the premiums for life insurance, AD&D, and both short-term and long-term disability coverage
                      • Flexible spending accounts allow employees to set aside pre-tax dollars to pay for dependent care, transportation, and applicable medical needs
                        Who We Are Independent 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-HYBRID Qualifications
                        Education Masters (preferred)
                        Bachelors (required)
                        
                        Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
                        
                        The 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)

Keywords: Milliman, Indianapolis , HEALTHCARE DATA ANALYST, MEDICAID - INDIANAPOLIS HEALTH, Accounting, Auditing , Indianapolis, Indiana