Opening for Data Analyst IV Medical Economics - Remote
We have an opening for Data Analyst IV Medical EconomicsLocation - RemoteFull time permanent positionJob DescriptionResponsible for analytic data needs of the business unit. Handle complex data projects and acts as a lead for other Data Analysts. Provide advanced analytical support for business operations in all or some of the following areas: claims, provider data, member data, clinical data, HEDIS, pharmacy, external reportingExtract, load, model, and reconcile large amounts of data across multiple system platforms and sourcesReview data to determine operational impacts and needed actions; elevate issues, trends, areas for improvement and opportunities to managementDevelop reports and deliverables and make recommendations to managementModel data using MS Excel, Access, SQL, and/or other data ware house analytical toolsAssist management in driving business decisions based on dataEnsure compliance with federal and state deliverable reporting requirements by performing data quality audits and analysisAssist with training and mentoring other Data AnalystsAssist with determining work load and related activities for other Data AnalystsPerforms other duties as assignedComplies with all policies and standardsMust-havesBachelor s degree in business, economics, statistics, mathematics, actuarial science, public health, health informatics, healthcare administration, finance or related field or equivalent experience.Master's degree preferred. 5+ years of experience working with large databases, data verification, and data managementRequired SkillsExperience with Medicare, Medicaid and Marketplace analytics Strong SQL skills, including the ability to write and understand complex queries, SELECT statements, and multiple types of JOINs. Advanced Excel skills, including: Pivot Tables Power Query VLOOKUP / XLOOKUP Averages, aggregations, formatting Creating and nesting formulas to build metrics and perform financial modeling Power BI experience, with familiarity in DAX and Power Pivot.Experience with financial analytics tools and basic financial modeling/sizing Strong understanding of payment methodologies, including DRG pricing, APC, and EAPG payment methodologiesPreferred or Nice-to-have SkillsPython and R Collaborate with cross-functional teams to evaluate QAI (Quality and Affordability Initiatives), MLR (Medical Loss Ratio) targets, and related key performance indicators (KPIs)Years ofExperience: 5+ years of experienceIndustryExperience: Managed Care Analytics - payment methodologies - Medical Economics (Healthcare) Apply tot his job