Fox Point Recruitment LLC
Data Analyst III Medical Economics
Fox Point Recruitment LLC, Des Moines, Iowa, United States
This position will support mostly CST/EST stakeholders - if this candidate is PST, they will be expected to work 6-3p PST (8-5 CST or 9-6 EST) REMOTE USA (please no HI or AK at this time due to time zone)
Additional variable compensation 8% targeted bonus Please note that the MAX comp will be $95k
Position Purpose Analyze integrated and extensive datasets to extract value, which directly impacts and influences business decisions. Work collaboratively with key business stakeholders to identify areas of value, develop solutions, and deliver insights to reduce overall cost of care for members and improve their clinical outcomes.
Interpret and analyze data from multiple sources including claims, provider, member, and encounters data. Identify and assess the business impact of trends
Develop, maintain, and troubleshoot complex scripts and reports developed using SQL, Microsoft Excel, or other analytics tools
Contribute to the planning and execution of large-scale projects with limited direction from leadership
Assist in the design, testing, and implementation of process enhancements and identify opportunities for automation
Identify and perform root-cause analysis of data irregularities and present findings and proposed solutions to leadership and/or customers
Manage multiple, variable tasks and data review processes with limited supervision within targeted timelines and thrive in a demanding, quickly changing environment
Demonstrate a sense of ownership over projects and ask probing questions to understand the business value of tasks
Apply expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand how customers interact with analytic products
Partner cross-functionally at all levels of the organization and effectively, both verbally and visually, communicate findings and insights to non-technical business partners
Independently engage with customers and business partners to gather requirements and validate results
Communicate and present data-driven insights and recommendations to both internal and external stakeholders, soliciting and incorporating feedback when required
Provide technical guidance to junior analysts
Must-haves
Bachelors degree in business, economics, statistics, mathematics, actuarial science, public health, health informatics, healthcare administration, finance or related field or equivalent experience OR Master's degree.
4+ years of experience working with large databases, data verification, and data management or 2+ years of IT experience.
Required Skills
Experience 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 methodologies
Preferred or Nice-to-have Skills
Python 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 of Experience 4+ years
Industry Experience Managed Care Analytics - payment methodologies - Medical Economics (Healthcare)
#J-18808-Ljbffr
Additional variable compensation 8% targeted bonus Please note that the MAX comp will be $95k
Position Purpose Analyze integrated and extensive datasets to extract value, which directly impacts and influences business decisions. Work collaboratively with key business stakeholders to identify areas of value, develop solutions, and deliver insights to reduce overall cost of care for members and improve their clinical outcomes.
Interpret and analyze data from multiple sources including claims, provider, member, and encounters data. Identify and assess the business impact of trends
Develop, maintain, and troubleshoot complex scripts and reports developed using SQL, Microsoft Excel, or other analytics tools
Contribute to the planning and execution of large-scale projects with limited direction from leadership
Assist in the design, testing, and implementation of process enhancements and identify opportunities for automation
Identify and perform root-cause analysis of data irregularities and present findings and proposed solutions to leadership and/or customers
Manage multiple, variable tasks and data review processes with limited supervision within targeted timelines and thrive in a demanding, quickly changing environment
Demonstrate a sense of ownership over projects and ask probing questions to understand the business value of tasks
Apply expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand how customers interact with analytic products
Partner cross-functionally at all levels of the organization and effectively, both verbally and visually, communicate findings and insights to non-technical business partners
Independently engage with customers and business partners to gather requirements and validate results
Communicate and present data-driven insights and recommendations to both internal and external stakeholders, soliciting and incorporating feedback when required
Provide technical guidance to junior analysts
Must-haves
Bachelors degree in business, economics, statistics, mathematics, actuarial science, public health, health informatics, healthcare administration, finance or related field or equivalent experience OR Master's degree.
4+ years of experience working with large databases, data verification, and data management or 2+ years of IT experience.
Required Skills
Experience 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 methodologies
Preferred or Nice-to-have Skills
Python 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 of Experience 4+ years
Industry Experience Managed Care Analytics - payment methodologies - Medical Economics (Healthcare)
#J-18808-Ljbffr