Pharmacy Data Analyst I, II, or III

• 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

Level II

• All level I requirements, including:

• 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.

Level III

• All level I and II requirements, including:

• Seen as the technical expert on pharmacy data analytics issues.

• May Mentor/coach others. May direct or lead Analyst I or II on projects.

• Pharmacy Data Analyst I would have a 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.

• Pharmacy Data Analyst II would have a 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 would have a 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.

Skills and Attributes:

Level I

• Advanced SQL and report-writing skills, with proficiency in Oracle tools, SQL, and SNOWFLAKE.

• Proficiency in MS Word and Excel, including pivot tables, VLOOKUPs/XLOOKUPs, macros, and VBA.

• Advanced analytical and problem-solving skills, with the ability to work independently and implement solutions.

• Strong business acumen (finance, accounting, statistics, risk management, project management).

• Ability to apply data creatively to support planning and develop methodologies for new projects.

• Ability to create desk procedures and lead interdepartmental training.

• Strong verbal and written communication skills with internal and external customers.

• Strong understanding of claims, membership, pricing, and provider data systems.

• Knowledge of provider reimbursement, managed care, underwriting, actuarial principles, medical terminology, and coding is helpful.

• Experience with AI tools to enhance productivity and decision-making is highly desired.

Level II

• All level I requirements, plus:

• Must have advanced/complex SQL knowledge and report-writing capabilities. Seen as department expert.

• Proficient using data access tools, specifically Oracle suite of tools, 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.

Level III

• All level I and II requirements, plus:

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

• National pay structure - applies to the Boise, Portland, Salem, Seattle/Renton/Tacoma, Burlington, Vancouver, Lewiston, Minneapolis, St. Paul, and Salt Lake City metro areas: The full salary range is $55,000 - $90,000, and the bonus target is 6%.

• Regional pay structure - applies to Arkansas, North Dakota, Minnesota, Idaho, Oregon, Washington, and Utah locations outside the metro areas listed above: The full salary range is $49,000 - $81,000, and the bonus target is 6%.

Level II

• National pay structure - applies to the Boise, Portland, Salem, Seattle/Renton/Tacoma, Burlington, Vancouver, Lewiston, Minneapolis, St. Paul, and Salt Lake City metro areas: The full salary range is $72,000 - $119,000, and the bonus target is 10%.

• Regional pay structure - applies to Arkansas, North Dakota, Minnesota, Idaho, Oregon, Washington, and Utah locations outside the metro areas listed above: The full salary range is $65,000 - $107,000, and the bonus target is 10%.

Level III

• National pay structure - applies to the Boise, Portland, Salem, Seattle/Renton/Tacoma, Burlington, Vancouver, Lewiston, Minneapolis, St. Paul, and Salt Lake City metro areas: The full salary range is $88,000 - $143,000, and the bonus target is 15%.

• Regional pay structure - applies to Arkansas, North Dakota, Minnesota, Idaho, Oregon, Washington, and Utah locations outside the metro areas listed above: The full salary range is $79,000 - $129,000, and the bonus target is 15%.

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.

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.

As part of our security requirements, new hires will need access to a personal mobile device to set up Multi-Factor Authentication (MFA) upon joining the company. MFA is an important layer of protection for accessing Cambia systems and is required for all employees.

Every day, Cambia’s dedicated team of Pharmacy Data Analysts is living our mission to make health care easier and lives better. 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.

Do you thrive when problem-solving or performing analysis in a fast-paced environment? Are you able to work both independently and together as team? Then this role may be the perfect fit.