Pharmacy Data Analyst I, II, III - DOE

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

Job summary

Cambia Health Solutions is seeking a Pharmacy Data Analyst to leverage data analytics for healthcare transformation. This role involves developing reporting solutions and conducting complex analyses to support pharmacy management decisions. Candidates should possess strong SQL skills and relevant experience in healthcare data analysis.

Benefits

Medical, dental and vision coverage

Annual employer contribution to a health savings account

Generous paid time off

Market-leading retirement plan

Up to 12 weeks of paid parental time off

Qualifications

• 2-8 years relevant work experience in data analysis or database development.
• Advanced SQL expertise and report-writing capabilities.

Responsibilities

• Develops and maintains complex SQL-based reports and dashboards.
• Performs advanced statistical analysis and data modeling.

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

Join to apply for the Pharmacy Data Analyst I, II, III - DOE role at Cambia Health Solutions

Get AI-powered advice on this job and more exclusive features.

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 be instrumental in supporting pharmacy management decisions and developing 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.

Qualifications

What You Bring to Cambia:

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 systems or business systems or 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 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

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 systems or business systems or 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).
• Possesses strong analytical, critical thinking and problem-solving skills, with ability to independently perform complex analyses and develop innovative methodologies for new projects.
• Exhibits comprehensive understanding of corporate data systems (claims, membership, pricing, provider) and healthcare fundamentals including medical terminology, diagnosis/procedure coding, and provider reimbursement methodologies.
• Demonstrates well-developed business acumen in finance, accounting, statistics, risk management, and project management, with ability to support strategic and tactical planning through creative data applications.
• Excels in written and oral communication, effectively interfacing with internal/external stakeholders while leading interdepartmental training and documentation initiatives.
• Creates and validates desk procedures, ensuring departmental cohesiveness and accuracy while managing cross-functional training activities with minimal supervision.
• Applies managed care principles, underwriting knowledge, and actuarial concepts while identifying and implementing solutions to complex business challenges.

Pharmacy Data Analyst II - In addition to level I

• Must have advanced/complex SQL knowledge and report-writing capabilities. Seen as department expert.
• Proficient using data access tools, specifically Oracle suite of tools, Microsoft Access, SQL Navigator, SQL, VBA, ODBC, report development, form development, imports specs and case selects, etc.
• Advanced skills with word processing (MS Word) and spreadsheet (MS Excel) programs.
• Highly advanced analytical and problem-solving skills.
• Excellent oral and written communication skills. Ability to effectively present to all levels of management.
• Proven ability to work independently with complex projects with large financial impact and/or risk to the corporation.
• Proficient understanding of all relevant corporate data systems including claims, membership, pricing and provider data systems.

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

• Ability to work well independently or with a team. Mentors/coaches others. May direct or lead Analyst I or II on projects.

What You Will Do At Cambia

Pharmacy Data Analyst I and II

• Develops and maintains complex SQL-based reports, BOE universes, and enterprise dashboards while implementing automated validation procedures and providing final sign-off on departmental reporting.
• Performs advanced statistical analysis, data modeling, and trend analysis across healthcare services, utilization, costs, enrollment, and revenue metrics, delivering actionable insights for all business lines.
• Designs and maintains robust information reporting systems, including data validation routines and balancing protocols, ensuring data warehouse integrity and reliability for both internal and external stakeholders.
• Evaluates and analyzes impacts of new products, systems, and work processes on data infrastructure, while proactively identifying and addressing potential issues with significant corporate risk implications.
• Serves as a technical mentor, providing training and support to business analysts in query development and reporting methodologies, promoting consistency across the organization.
• Collaborates cross-functionally to ensure accurate data capture, interpret complex datasets, and determine reporting requirements while communicating findings through verbal and written channels.
• Makes high-stakes decisions with substantial financial impact, contributes to departmental deadlines, and maintains responsibility for final validation of complex reporting across the organization.

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

• Seen as the technical expert on pharmacy data analytics issues.
• May mentor/coach others. May direct or lead Analyst I or II on projects.

Compensation and Benefits

The expected hiring salary range for a Pharmacy Data Analyst I is $56,950 - $77,050 a year depending on skills, experience, education, and training; relevant licensure / certifications; and performance history.

The bonus target for this position is 5%. The current full salary range for this role is $53,000 - $88,000 a year.

The expected hiring salary range for a Pharmacy Data Analyst II is $75,650 - $102,350 a year depending on skills, experience, education, and training; relevant licensure / certifications; and performance history.

The bonus target for this position is 10%. The current full salary range for this role is $71,000 - $116,000 a year.

The expected hiring salary range for a Pharmacy Data Analyst III is $91,800 - $124,200 a year depending on skills, experience, education, and training; relevant licensure / certifications; and performance history.

The bonus target for this position is 15%. The current full salary range for this role is $91,800 - $124,200 a year.

About Cambia

Working at Cambia means being part of a purpose-driven, award-winning culture built on trust and innovation anchored in our 100+ year history. Our caring and supportive colleagues are some of the best and brightest in the industry, innovating together toward sustainable, person-focused health care. Whether we're helping members, lending a hand to a colleague or volunteering in our communities, our compassion, empathy and team spirit always shine through.

Why Join the Cambia Team?

At Cambia, You Can

• Work alongside diverse teams building cutting-edge solutions to transform health care.
• Earn a competitive salary and enjoy generous benefits while doing work that changes lives.
• Grow your career with a company committed to helping you succeed.
• Give back to your community by participating in Cambia-supported outreach programs.
• Connect with colleagues who share similar interests and backgrounds through our employee resource groups.

We believe a career at Cambia is more than just a paycheck – and your compensation should be too. Our compensation package includes competitive base pay as well as a market-leading 401(k) with a significant company match, bonus opportunities and more.

Benefits

In exchange for helping members live healthy lives, we offer benefits that empower you to do the same. Just a few highlights include:

• Medical, dental and vision coverage for employees and their eligible family members, including mental health benefits.
• Annual employer contribution to a health savings account.
• Generous paid time off varying by role and tenure in addition to 10 company-paid holidays.
• Market-leading retirement plan including a company match on employee 401(k) contributions, with a potential discretionary contribution based on company performance (no vesting period).
• Up to 12 weeks of paid parental time off (eligibility requires 12 months of continuous service with Cambia immediately preceding leave).
• Award-winning wellness programs that reward you for participation.
• Employee Assistance Fund for those in need.
• Commute and parking benefits.

Learn More About Our Benefits

We are happy to offer work from home options for most of our roles. To take advantage of this flexible option, we require employees to have a wired internet connection that is not satellite or cellular and internet service with a minimum upload speed of 5Mb and a minimum download speed of 10 Mb.

We are an Equal Opportunity employer dedicated to a drug and tobacco-free workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, age, sex, sexual orientation, gender identity, disability, protected veteran status or any other status protected by law. A background check is required.

If you need accommodation for any part of the application process because of a medical condition or disability, please email [e-mail]. Information about how Cambia Health Solutions collects, uses, and discloses information is available in our Privacy Policy.

Additional Details

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology
• Industries: Hospitals and Health Care