Lead Data Analyst (Part-Time)

Job Summary

This role will inform decision making and develop actionable insights to deliver optimal patient care and outcomes to support AbsoluteCare’s clinical, financial, and operational goals.  The Lead Data Analyst will work in close collaboration with Clinical, Pharmacy, and other enterprise stakeholders and executives to lead cross functional complex analytical projects and oversee detailed business requirements, design, report development, and analyses using health care utilization, operational, clinical, and financial data from various health care information sources to predict, measure and drive member and care model outcomes.

This role will manage analytical projects using clinical and operational data sourced from the Electronic Health Record (eClinicalWorks), pharmacy point of sale system, population health management systems, and health plan payer data to deliver end to end solutions that respond to critical business needs and enterprise strategy.  This role includes Level V.

Duties and 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.

Minimum Qualifications

• 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, 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 Microsoft Power BI, Power Query, or other Business Intelligence Tools.
• Advanced proficiency with Microsoft Excel, Power Query, Power BI, and SQL.
• Advanced proficiency with the Microsoft BI stack, including SSMS, SSRS, SSIS, and Power BI or other visualization tools strongly preferred.
• Advanced proficiency with Microsoft Excel required.
• Advanced proficiency with relational databases (SQL server), querying, data warehouses, and decision support tools required.
• Experience with R, Python, machine learning, and artificial intelligence libraries in building predictive analytics models preferred.
• Experience with managing projects building data models and analytical solutions using data to drive business outcomes and decisions required.
• Experience with 340b, Medicaid, and Medicare Part B/D pharmacy programs is a plus.
• Ability to work independently with limited direction and/or guidance.
• Capable of successfully balancing numerous and competing priorities.
• Excellent written and verbal communication skills with experience collaborating with executives strongly preferred.
• Highly organized with strong documentation skills.
• Passion for data and the act of transforming data to achieve results.

Working conditions

This job operates in a professional office environment and remotely from home office space.   This role routinely uses general office equipment.

Physical requirements

• Ability to communicate clearly and exchange accurate information constantly.
• Ability to remain stationary for long periods of time.
• Repetitious movements.
• Constantly operates computer, keyboard, copy and fax machine, phone, and other general office equipment.

• Ability to occasionally move objects up to 20 lbs.

Direct reports

None.