Pharmacy Data Analyst – Hybrid, Impactful Analytics

Cambia Health Solutions; Little Rock (AR); Hybrid; USD 65,000 - 107,000; Full time

Benefits offered by this job

Health insurance

401(k) match

Paid time off

Parental leave

Wellness programs

Job summary

Cambia Health Solutions is seeking a Pharmacy Data Analyst to develop reporting solutions and perform complex analyses impacting corporate initiatives. The role emphasizes pharmacy data expertise, SQL, Oracle tools, and data-driven decision support across multiple levels and locations.

This hybrid role offers work across offices including Little Rock, with preference for local candidates or those willing to relocate. Strong communication and stakeholder management are essential.

Qualifications

• Bachelor's degree in business, health information administration, mathematics, statistics, computer science or related field and 2 years' relevant work experience in data analysis or supporting relational database development, maintenance or utilization in healthcare systems or business systems or equivalent combination of education and experience.
• Bachelor's degree in business, health information administration, mathematics, statistics, computer science or related field and 5 years' relevant work experience in data analysis or supporting relational database development, maintenance or utilization in healthcare systems or business systems or equivalent combination of education and experience. STARS and MES experience strongly preferred.
• Bachelor's degree in business, health information administration, mathematics, statistics, computer science or related field and 8 years’ relevant work experience in data analysis or supporting relational database development, maintenance or utilization in healthcare systems or business systems or equivalent combination of education and experience. STARS and MES experience strongly preferred.

Responsibilities

• Create complex reports and modify underlying SQL; thoroughly validate own work and that of other team members, and be relied on for accuracy with complex reporting
• Analyze data and prepare reports on health care services, utilization, costs, trends, enrollment, incentives, and revenue by provider, member, network, group, product, and line of business
• Perform statistical analysis and data modeling per user requests, and communicate results and recommendations verbally and in writing
• Maintain existing and develop new information reporting systems to meet the needs of internal and external users, gathering reporting requirements directly from information users
• Evaluate the impact of new products, systems, and work processes on data and reporting systems, and work with transaction system departments to maintain data integrity and reliability
• Develop and execute balancing and data validation routines to ensure data warehouse updates are complete, accurate, and reliable
• Assist and train business analysts in other departments on data interpretation, appropriate use of data tools, and query and report preparation to improve reporting consistency across the plan and Regence
• Make sound decisions on issues with significant corporate risk impact, proactively raise issues and concerns to management, and contribute as needed to meet departmental deadlines
• All level I requirements, plus: Creates enterprise universes. Automation of enterprise published reports (dashboards). Identifies needed reporting and assembles or directs the assembly.
• Validates complex reporting produced within and outside the department. Responsible for proving final sign-off.
• Defines and implements procedures/processes/tools to automate validation.
• Trusted ability to make decisions with large financial impact and/or risk to the corporation.

Skills

SQL & reporting

Oracle tools

Snowflake

MS Word

MS Excel

VBA

Analytical thinking

Business acumen

Data interpretation

Desk procedures

Interdepartmental training

Communication skills

Claims data

Membership data

Pricing data

Provider data

AI tools

Presentation skills

Education

Bachelor's degree

Health information

Statistics

Computer science

Healthcare data

Tools

SQL Navigator

ODBC

Report development

Form development

Job description

Cambia Health Solutions is seeking a Pharmacy Data Analyst to develop reporting solutions and perform complex analyses impacting corporate initiatives. The role emphasizes pharmacy data expertise, SQL, Oracle tools, and data-driven decision support across multiple levels and locations.

This hybrid role offers work across offices including Little Rock, with preference for local candidates or those willing to relocate. Strong communication and stakeholder management are essential.