Lead Data Analyst

AbsoluteCARE Medical Center & Pharmacy; Baltimore (MD); Hybrid; USD 120,000 - 160,000; Full time

Job summary

AbsoluteCare Medical Center & Pharmacy in Baltimore seeks Lead Data Analyst to inform decision making and deliver insights across clinical, operational, and financial goals. You will collaborate with clinical, pharmacy, and executive stakeholders to lead complex analytical projects and translate requirements into dashboards and reports using EHR, pharmacy, and payer data.

The role focuses on end-to-end analytics, data modeling, and predictive analytics to improve member outcomes and care models.

Qualifications

• Bachelor’s degree in a related field or equivalent work experience.
• 7+ years in healthcare data analytics, with EHR and payer data experience preferred.
• Advanced proficiency with Power BI, Power Query, or other BI tools.
• Advanced proficiency with Excel, Power Query, Power BI, and SQL.
• Experience with SQL Server, data warehouses, and decision support tools.
• Experience with R, Python, ML/AI libraries for predictive analytics preferred.
• Experience managing data modeling projects to drive outcomes.
• Knowledge of 340b/Medicaid/Medicare Part B/D is a plus.
• Ability to work independently with multiple priorities.
• Excellent communication with executives preferred.
• Organized with strong documentation skills.
• Passion for turning data into results.

Responsibilities

• Deliver advanced analytics support for multiple teams using health data.
• Partner with leadership to define, document, and implement ad‑hoc reports.
• Design data solutions with metrics, actionability, clinicians, and patients in mind.
• Conduct data mining to identify trends and opportunities.
• Develop data models in R/Python to predict outcomes.
• Automate reporting with the Microsoft BI stack.
• Present analyses clearly to all levels of the organization.
• Conduct analyses using SQL, Excel, Power BI.
• Translate business processes into reporting requirements.
• Interpret clinical data for quality measures (HEDIS/NCQA).
• Relate disparate data to extract actionable insights.
• Support executive reporting needs and stakeholder requests.
• Troubleshoot reporting needs against data sets.
• Promote high-quality reporting and analytics; peer review.
• Oversee training and priorities of other data analysts.

Skills

Power BI

SQL

Excel

Data modeling

R / Python

Healthcare analytics

Project management

Executive communication

Education

Bachelor’s degree or equivalent

Tools

Power BI

Power Query

SSMS

SSRS

SSIS

SQL Server

eClinicalWorks

RX30

Python

R

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.

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.