Pharmacy Data Analyst I, II, III - DOE

Cambia Health Solutions; Lewiston (ID); Remote; USD 53,000 - 88,000; Full time

Job summary

Join a leading healthcare organization as a Pharmacy Data Analyst, where you'll leverage your analytical skills to drive healthcare transformation. This role involves developing reporting solutions and conducting analyses that impact strategic decisions. With opportunities for growth and a supportive environment, you will play a key role in optimizing pharmacy services and contributing to healthcare delivery improvements.

Benefits

401(k) match

Bonuses

Health coverage

Paid time off

Wellness programs

Qualifications

• 2-8 years of relevant work experience in data analysis or healthcare systems.
• STARS and MES experience preferred.

Responsibilities

• Develop and maintain complex SQL reports and dashboards.
• Perform advanced statistical analysis and data modeling.
• Collaborate cross-functionally to interpret data and communicate findings.

Skills

SQL

Analytical Skills

Problem Solving

Communication

Education

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

Tools

Oracle

Microsoft Access

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 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 develop innovative long-term solutions. This role offers an exciting opportunity to be at the forefront of healthcare evolution, where your data analytics expertise will 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

• Advanced SQL expertise and report-writing capabilities, 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 independently perform complex analyses and develop innovative methodologies.
• 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 creative data applications.
• Effective written and oral 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.
• Knowledge of managed care principles, underwriting, and actuarial concepts to solve complex business challenges.

Pharmacy Data Analyst II - In addition to Level I

• Advanced/complex SQL knowledge and report-writing, recognized as department expert.
• Proficient with Oracle tools, Microsoft Access, SQL Navigator, SQL, VBA, ODBC, report and form development, import specifications, etc.
• Advanced skills in MS Word and Excel.
• Highly advanced analytical and problem-solving skills.
• Excellent communication skills, able to present effectively to management.
• Proven ability to handle complex projects with significant financial impact independently.
• Comprehensive understanding of corporate data systems.

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

• Ability to work independently or as part of a team, mentoring or leading others on projects.

What You Will Do at Cambia:

Pharmacy Data Analyst I and II

• Develop and maintain complex SQL reports, dashboards, and automate validation procedures.
• Perform advanced statistical analysis, data modeling, and trend analysis to deliver insights across healthcare metrics.
• Design and ensure the integrity of reporting systems and data validation routines.
• Evaluate impacts of new products and processes on data infrastructure, addressing potential risks.
• Mentor and support business analysts in reporting methodologies.
• Collaborate cross-functionally to interpret data and communicate findings.
• Make high-stakes decisions with financial impact, ensuring report accuracy.

Pharmacy Data Analyst III

• Recognized as the technical expert in pharmacy data analytics.
• Lead or mentor others on projects.

#LI-remote

Compensation and Benefits:

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

The salary range for Analyst II is $75,650 - $102,350, with a bonus target of 10%. The full range is $71,000 - $116,000 annually.

For Analyst III, the range is $91,800 - $124,200, with a bonus target of 15%. The full range is $91,800 - $124,200 annually.

About Cambia

We are a purpose-driven, award-winning organization committed to trust and innovation, with a rich history of over 100 years. Our culture is built on compassion, empathy, and teamwork, dedicated to sustainable, person-focused healthcare.

Why Join Us?

• Work with diverse teams on innovative health solutions.
• Enjoy competitive pay and benefits that make a difference.
• Grow your career with a supportive company.
• Participate in community outreach programs.
• Connect through employee resource groups.

Our compensation includes competitive pay, a 401(k) match, bonuses, and comprehensive benefits such as health coverage, paid time off, wellness programs, and more.

We support flexible work arrangements, requiring a wired internet connection with minimum speeds of 5Mb upload and 10Mb download.

We are an Equal Opportunity employer, committed to a drug and tobacco-free workplace. Background checks are required. For accommodations, contact [e-mail]. More information is in our Privacy Policy.