Pharmacy Data Analyst I, II, III - DOE

Cambia Health Solutions; Bend (OR); Remote; USD 56,000 - 78,000; Full time

Job summary

Join a leading health care company as a Pharmacy Data Analyst, where you'll leverage your data expertise to transform healthcare delivery. This role involves developing reporting solutions, conducting complex analyses, and supporting pharmacy management decisions. With opportunities for career growth and a commitment to person-focused care, you'll be at the forefront of healthcare evolution.

Benefits

Comprehensive health coverage

Retirement plans

Paid parental leave

Wellness programs

Flexible work arrangements

Qualifications

• 2 years’ experience for Analyst I, 5 years for Analyst II, 8 years for Analyst III.
• STARS and MES experience preferred for Analysts II and III.

Responsibilities

• Develop and maintain complex SQL reports and dashboards.
• Perform statistical analysis and data modeling for actionable insights.
• Mentor and support analysts in reporting methodologies.

Skills

SQL

Analytical Skills

Problem Solving

Communication

Education

Bachelor’s degree in business, health information administration, mathematics, statistics, computer science

Tools

Oracle

Microsoft Access

SQL Navigator

Excel

Job description

Pharmacy Data Analyst I, II, III Work from home within Oregon, Idaho, Utah

Build a career with purpose. Join our Cause to create a person-focused and economically sustainable health care system.

Who We Are Looking For:

Every day, Cambia’s dedicated team of Pharmacy Data Analysts live our mission to make health care easier and lives better. As a member of the Pharmacy Informatics team, you'll leverage your expertise to drive healthcare transformation through advanced analytics and data-driven solutions.

As a Pharmacy Data Analyst, you'll play a pivotal role in shaping strategic decisions by developing sophisticated reporting solutions and conducting complex analyses that directly impact our corporate initiatives. We're seeking a highly skilled technical professional with pharmacy data experience who excels at managing multifaceted projects and solving high-stakes challenges with significant financial implications. Your analytical prowess will support pharmacy management decisions and help develop innovative long-term solutions. This role offers an exciting opportunity to be at the forefront of healthcare evolution, where your expertise in data analytics will directly contribute to optimizing pharmacy services and advancing our mission of transforming healthcare delivery.

What You Bring to Cambia:

Qualifications:

Pharmacy Data Analyst I

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

Pharmacy Data Analyst II

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

Pharmacy Data Analyst III

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

Skills and Attributes:

Pharmacy Data Analyst I

• Demonstrates advanced SQL expertise and report-writing capabilities, with proficiency in Oracle suite, Microsoft Access, SQL Navigator, and advanced Excel functions (pivot tables, VBA, macros, vlookups).
• Strong analytical, critical thinking, and problem-solving skills, with the ability to perform complex analyses and develop innovative methodologies for new projects.
• Understanding of corporate data systems (claims, membership, pricing, provider) and healthcare fundamentals including medical terminology, diagnosis/procedure coding, and provider reimbursement methodologies.
• Business acumen in finance, accounting, statistics, risk management, and project management, supporting strategic and tactical planning through data applications.
• Effective communication skills, capable of interfacing with stakeholders and leading training and documentation initiatives.
• Ability to create and validate desk procedures, ensuring departmental accuracy and managing cross-functional training with minimal supervision.
• Knowledge of managed care principles, underwriting, and actuarial concepts to address complex business challenges.

Pharmacy Data Analyst II - In addition to Level I

• Advanced/complex SQL knowledge and report-writing skills. Recognized as department expert.
• Proficient with Oracle tools, Microsoft Access, SQL Navigator, VBA, and related data access tools.
• Highly advanced analytical and problem-solving skills.
• Excellent communication skills, with the ability to present to management.
• Proven ability to handle complex projects with significant financial impact independently.
• Understanding of relevant data systems including claims, membership, and provider data.

Pharmacy Data Analyst III - In addition to Level I and II

• Ability to work independently or with a team. Mentors or coaches others. May lead projects.

What You Will Do at Cambia:

Pharmacy Data Analyst I and II

• Develop and maintain complex SQL reports, dashboards, and implement validation procedures.
• Perform statistical analysis, data modeling, and trend analysis to provide actionable insights.
• Design and maintain reporting systems ensuring data integrity.
• Evaluate impacts of new products and systems on data infrastructure.
• Mentor and support analysts in reporting methodologies.
• Collaborate cross-functionally to ensure accurate data capture and interpretation.
• Make high-stakes decisions impacting the organization.

Pharmacy Data Analyst III

• Recognized as the technical expert on pharmacy data analytics issues.
• Mentor, coach, and potentially lead projects.

#LI-remote

Salary and Benefits:

The expected hiring salary range for Pharmacy Data Analyst I is $56,950 - $77,050/year, with a full range of $53,000 - $88,000/year. The bonus target is 5%.

The range for Pharmacy Data Analyst II is $75,650 - $102,350/year, with a full range of $71,000 - $116,000/year. Bonus target is 10%.

The range for Pharmacy Data Analyst III is $91,800 - $124,200/year, with a full range of the same amount. Bonus target is 15%.

About Cambia

We are a purpose-driven, innovative company committed to sustainable, person-focused health care. Our culture emphasizes trust, empathy, and community involvement.

Why Join Us?

• Work on transformative health care solutions.
• Earn competitive pay and benefits.
• Grow your career with a supportive company.
• Participate in outreach programs and employee resource groups.

Our benefits include comprehensive health coverage, retirement plans, paid parental leave, wellness programs, and more. We support flexible work arrangements, including remote work, with specific internet requirements.

We are an Equal Opportunity employer and committed to a drug- and tobacco-free workplace. For accommodations, contact [e-mail]. See our Privacy Policy for more information.