BMPS Data Analyst — Health Data Insights & Dashboards

Allcare-Health; Grants Pass (OR); On-site; USD 76,960 - 83,200; Full time

Benefits offered by this job

Healthcare benefits

401k retirement

Wellness programs

Flexible schedule

Job summary

AllCare Health BMPS Data Analyst in Grants Pass, Oregon, focuses on designing and coordinating complex data analysis to support the Benefit Management & Pharmacy Services department. You will build dashboards, reports, and data visualizations to identify cost drivers and trends, and you will communicate findings to both technical and non-technical staff.

This role involves ETL, data modeling, and collaboration with IT Data Science for production Power BI dashboards, while handling healthcare

Qualifications

• Bachelor's degree in Health Informatics, Data Analytics, Computer Science, Information Systems, Public Health, Healthcare Administration, Statistics, Mathematics, or related field.
• Two to four years of healthcare data analysis, BI, reporting, analytics, or related field.
• Experience working with healthcare data including claims, medical, pharmacy, utilization or population health data.
• Experience developing reports, dashboards, and data visualizations to support decision-making.

Responsibilities

• Creates, monitors, maintains, coordinates, and submits required contract exhibit reporting to government entities.
• Works with CCD/CCDA/FHIR data structures for clinical data.
• ETL data from various sources.
• Develops SQL queries in SSMS and builds Power BI dashboards.
• Creates visualizations with Power BI, using DAX and Power Query.
• Analyzes data with healthcare code sets (CPT, HCPCS, ICD-10, HCC).
• Supports DSNP and other healthcare programs as needed.
• Runs regular reports to highlight utilization and cost data for leadership.

Skills

SQL/T-SQL

Power BI

Excel

Data analysis

SSMS

HIPAA knowledge

Education

Bachelor's degree in Health Informatics, Data Analytics, Computer Science, Information Systems, Public Health, Healthcare Administration, Statistics, Mathematics, or related field

Tools

SSMS

Microsoft Access

Crystal Reports

Cognos

Job description

AllCare Health BMPS Data Analyst in Grants Pass, Oregon, focuses on designing and coordinating complex data analysis to support the Benefit Management & Pharmacy Services department. You will build dashboards, reports, and data visualizations to identify cost drivers and trends, and you will communicate findings to both technical and non-technical staff.

This role involves ETL, data modeling, and collaboration with IT Data Science for production Power BI dashboards, while handling healthcare