Pharmacy Data Analyst I, II, or III

Pharmacy Data Analyst I, II, or III

Hybrid role (3 days/week in office) at our Salt Lake City, Boise, Fargo, Portland, Vancouver, Renton, Medford, Burlington, Lewiston, Little Rock, and Springdale offices. Preference will be given to current employees and candidates who reside within a commutable distance from our Salt Lake City, Boise, Fargo, Lewiston, Little Rock, and Springdale offices, or who are willing to relocate.

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

What You Bring to Cambia:

Qualifications:

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

What You Will Do at Cambia:

Level I

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

Pay ranges vary based on the candidate's work location. The expected hiring range depends on skills, experience, education, and training; relevant licensure / certifications; and performance history.

Level I

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