Lead Data Analyst

AbsoluteCare is seeking a Lead Data Analyst to develop actionable insights that support patient care and the organization’s clinical, financial, and operational goals. The role leads cross-functional analytical projects, builds reports and predictive models from healthcare data, and oversees the work and development of other data analysts.

Responsibilities:

• Responsible for delivering advanced analytical support and solutions for one or more business teams – such as Business Development, Integrated Clinical Team, Pharmacy, Finance, and Quality and Risk Adjustment – using clinical and operational care model data from EHR (eClinicalWorks), pharmacy point of sale system (RX30), population health management systems, medical and pharmacy claims provided by health plan payers, and other internal and third-party data streams, as necessary
• Work in partnership with business teams and leadership to define, create, document, and implement ad-hoc reports/analytics that support the AbsoluteCare clinical care model and strategy
• Ability to design complex data solutions with key performance metrics, actionability, clinicians, and patients in mind; utilize data to not only identify potential impact, but also test and monitor performance of clinical metrics and outcomes
• Conduct extensive data mining and analyses to identify trends, opportunities, and best practices
• Design, and develop data models with R, Python, or other tools to predict member outcomes and identify opportunities for improvement of clinical outcomes
• Develop automation of manual reporting processes and develop novel reporting solutions using the Microsoft BI stack and other reporting tools
• Communicate analyses, results, and reports in a simple and clear fashion to all levels and functional areas of the organization
• Conduct analyses using tools such as SQL, Excel, Power BI
• Organize, clarify, and translate business processes into reporting requirements from a diverse set of end users (e.g., executives, clinicians)
• Interpret medical data fields to understand the population’s compliance with standard quality measures (e.g., HEDIS, NCQA)
• Relate disparate data sets to extract actionable insights
• Support business needs through the development of ad-hoc and standardized reports as requested by the executive leadership team, as well as internal and external customers
• Troubleshoot and align the reporting needs of end users to available data sets
• Promote a culture of high-quality reporting and analytics by acting as a peer reviewer for team members
• Oversee training, mentoring, workload, and priorities of other data analysts

Requirements:

• Bachelor's degree in business, information technology, computer science/data science/data analytics, statistics, mathematics, actuarial science, health science, or related field or equivalent work experience required
• 7+ years of health care health care data analysis, and reporting experience required
• Advanced proficiency with Microsoft Power BI, Power Query, or other Business Intelligence Tools
• Advanced proficiency with Microsoft Excel, Power Query, Power BI, and SQL
• Advanced proficiency with Microsoft Excel required
• Advanced proficiency with relational databases (SQL server), querying, data warehouses, and decision support tools required
• Experience with managing projects building data models and analytical solutions using data to drive business outcomes and decisions required
• Ability to work independently with limited direction and/or guidance
• Capable of successfully balancing numerous and competing priorities
• Highly organized with strong documentation skills
• Passion for data and the act of transforming data to achieve results
• Clinical background with EHR experience (eClinicalWorks), Pharmacy point of sale systems, and/or population health management systems and/or health plan payer/experience strongly preferred
• Health plan experience with Managed Medicaid and Medicare Advantage plans a plus
• Advanced proficiency with the Microsoft BI stack, including SSMS, SSRS, SSIS, and Power BI or other visualization tools strongly preferred
• Experience with R, Python, machine learning, and artificial intelligence libraries in building predictive analytics models preferred
• Experience with 340b, Medicaid, and Medicare Part B/D pharmacy programs is a plus
• Excellent written and verbal communication skills with experience collaborating with executives strongly preferred