Lead Data Analyst

Absolutecare; United States; Hybrid; USD 120,000 - 180,000; Full time

Job summary

This role requires strong SQL, Power BI, Python or R, and Excel skills, along with the ability to communicate findings clearly to executives. Hybrid work options and contributing to HIPAA-compliant reporting are expected.

Qualifications

• Bachelor’s degree in a related field or equivalent work experience.
• 7+ years of health care data analysis, reporting experience.
• Advanced proficiency with Power BI and Excel.
• Proficiency with SQL and relational databases (SQL Server).
• Experience with R, Python, ML/AI libraries for predictive analytics is a plus.
• Experience managing data-modeling projects and analytics initiatives.

Responsibilities

• Deliver advanced analytical support for multiple business teams using EHR, pharmacy POS, population health, and payer data.
• Define and implement ad-hoc reports/analytics aligning with clinical care model strategy.
• Design data solutions with KPIs, ensuring actionability for clinicians and leaders.
• Conduct extensive data mining to identify trends and opportunities.
• Develop models to predict member outcomes and improve care metrics.
• Automate reporting and develop end-to-end solutions using MS BI stack.

Skills

SQL

Power BI

Python

R

Excel

Data modeling

Machine learning

Education

Bachelor's degree in health informatics, data science, computer science, statistics

Tools

eClinicalWorks

RX30

SSMS/SSRS/SSIS

Job description

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.

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. This role requires a dedicated, quiet workspace with the ability to adhere to HIPAA and other privacy policies. A reliable and high-speed Wi‑Fi connection or home internet is required to perform the essential functions of this role.

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.