Pharmacy Data Analyst I, II, III - DOE

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

Job summary

Join a leading healthcare company as a Pharmacy Data Analyst, where you'll leverage your data analytics expertise to drive healthcare transformation. This role involves developing reporting solutions, conducting complex analyses, and supporting pharmacy management decisions. With positions available across three levels, you'll have the opportunity to shape strategic decisions and contribute to optimizing pharmacy services. Enjoy competitive salaries, comprehensive benefits, and a flexible work environment.

Benefits

Health Coverage

Retirement Plans

Paid Time Off

Wellness Programs

Qualifications

• 2 years’ experience for Level I, 5 years for Level II, 8 years for Level III in data analysis.
• STARS and MES experience preferred for Levels II and III.

Responsibilities

• Develop and maintain complex SQL reports and dashboards.
• Perform advanced statistical analysis and data modeling.
• Collaborate cross-functionally to ensure accurate data capture.

Skills

SQL

Analytical Skills

Problem Solving

Communication

Education

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

Tools

Oracle suite

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 are living 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 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

• 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.
• Comprehensive understanding of corporate data systems (claims, membership, pricing, provider) and healthcare fundamentals including medical terminology, diagnosis/procedure coding, and provider reimbursement methodologies.
• Well-developed 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 cohesion and accuracy, while managing cross-functional training with minimal supervision.
• Knowledge of managed care principles, underwriting, and actuarial concepts, with the ability to identify and implement solutions to complex business challenges.

Pharmacy Data Analyst II - In addition to Level I

• Advanced/complex SQL knowledge and report-writing capabilities; recognized as department expert.
• Proficient with Oracle tools, Microsoft Access, SQL Navigator, SQL, VBA, ODBC, and report/form development.
• Highly advanced analytical and problem-solving skills.
• Excellent communication skills, with the ability to present to management levels effectively.
• Proven capacity to work independently on complex projects with significant financial or risk implications.
• Understanding of all relevant corporate data systems.

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 automate validation procedures.
• Perform advanced statistical analysis, data modeling, and trend analysis to deliver actionable insights.
• Design and maintain reporting systems, ensuring data integrity and reliability.
• Evaluate impacts of new products, systems, and processes on data infrastructure.
• Mentor and support business analysts in reporting methodologies.
• Collaborate cross-functionally to ensure accurate data capture and interpret datasets.
• Make high-stakes decisions with substantial financial impact and validate complex reports.

Pharmacy Data Analyst III

• Recognized as the technical expert on pharmacy data analytics issues.
• Mentor, coach, or lead projects involving Level I and II analysts.

#LI-remote

Salary and Benefits:

The 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 salary range for Level II is $75,650 - $102,350/year, with a full range of $71,000 - $116,000/year. The bonus target is 10%.

The salary range for Level III is $91,800 - $124,200/year, with a full range of $91,800 - $124,200/year. The bonus target is 15%.

About Cambia

We are a purpose-driven, award-winning organization committed to trust and innovation, with a rich 100+ year history. Our culture emphasizes compassion, empathy, and teamwork, focusing on sustainable, person-centered healthcare.

Why Join Us?

• Work with diverse teams on innovative health care solutions.
• Enjoy competitive salary, benefits, and opportunities for growth.
• Participate in community outreach and employee resource groups.
• Comprehensive benefits include health coverage, retirement plans, paid time off, wellness programs, and more.

We support flexible work arrangements, requiring reliable internet for remote work. We are an Equal Opportunity Employer and provide accommodations for applicants with disabilities. For more info, contact [e-mail] or review our Privacy Policy.