BMPS Data Analyst at AllCare Health with the Benefit Management & Pharmacy Services department in Grants Pass, Oregon
We Are Seeking Qualified Candidates to Join Our Team!
AllCare Health offers competitive wages, an excellent benefits package including affordable healthcare, 401k retirement, wellness programs, and flexible schedule options.
Summary of the Position
This position is responsible for supporting multiple teams including Benefit Management & Pharmacy Services, Oral Health, Social Determinants of Health, and the medical Directors in the design, development, implementation, and coordination of complex data compilation and analysis that promotes and supports the AllCare BMPS department activities by performing the following duties:
Essential Duties
- Creates and maintains detailed listings, reporting, and data visualizations to identify cost drivers and negative trends within medical, oral health, and/or pharmacy data.
- Articulates understandable explanations of complex clinical data or trends to all staff through verbal, written, and graphical presentations.
- Designs localized utilization, case, and disease management dashboards, models, and reports to support departmental staff.
- Regularly interfaces the IT Data Science team as a product owner submitting AzureDevOps Work Items (PBI’s) for the development of production Data Science PowerBI Service Dashboards.
Job Duties
- Creates, monitors, maintains, coordinates, and submits regulatorily and contractually required contract exhibit reporting to various government entities (e.g. Exhibit I, HRSN, TOC).
- Understanding, using, and incorporating clinical data derived from CCD, CCDA, and FHIR architectures.
- Extract, Transform, and Load (ETL) data from various sources.
- Creating and using queries written with SQL/T-SQL DQL (Select) Commands in SSMS.
- Work in PowerBI Desktop using PowerBI Data Marts, Symantec Models, DAX, and Power Query to create strong data visualizations.
- Use, understand, and categorize data on various healthcare code sets such as CTP, HCPCS, ICD-9/10, and HCC.
- Support the data requirements of various MA Programs.
- Create and analyze utilization across various standardized Service Categories such as indicated by the Oregon Health Grouper (OHG) for financial and other analysis.
- Integrates data from multiple reports to evaluate AllCare member service utilization stratifying, prioritizing, and triaging high risk members for disease management and case coordination.&nb