Pharmacy Data Analyst I, II, or III

Cambia Health Solutions•Boise, ID

2d•Hybrid

About The Position

Cambia is hiring a Pharmacy Data Analyst at Level I, II, or III to develop reporting solutions and conduct complex analyses that inform strategic decisions and pharmacy management. The role supports corporate initiatives, helps optimize pharmacy services, and contributes to long-term solutions for healthcare delivery. Analysts work on multifaceted projects and challenges with significant financial implications, both independently and collaboratively. The role is hybrid, with three days per week in the office, at offices in Salt Lake City, Boise, Fargo, Portland, Vancouver, Renton, Medford, Burlington, Lewiston, Little Rock, and Springdale. Preference will be given to current employees and candidates within commuting distance of certain listed offices or willing to relocate. Pay depends on location, skills, experience, education, training, relevant licenses or certifications, and performance history. The position has different qualification, responsibility, salary, and bonus levels. Cambia describes its culture as purpose-driven, supportive, and focused on sustainable, person-focused healthcare. The company offers work-from-home options for most roles, subject to wired internet requirements, and requires new hires to use a personal mobile device for multifactor authentication. A background check is required.

Requirements

For Level I: Bachelor's degree in business, health information administration, mathematics, statistics, computer science, or a related field, and two years of 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.
For Level II: Bachelor's degree in business, health information administration, mathematics, statistics, computer science, or a related field, and five years of 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.
For Level III: Bachelor's degree in business, health information administration, mathematics, statistics, computer science, or a related field, and eight years of 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.
Level I: Advanced SQL and report-writing skills, including proficiency in Oracle tools, SQL, and Snowflake.
Level I: Proficiency in Microsoft Word and Excel, including pivot tables, VLOOKUP/XLOOKUP, macros, and VBA.
Level I: Advanced analytical and problem-solving skills, with the ability to work independently and implement solutions.
Level I: Strong business acumen in finance, accounting, statistics, risk management, and project management.
Level I: Ability to apply data creatively to support planning and develop methodologies for new projects.
Level I: Ability to create desk procedures and lead interdepartmental training.
Level I: Strong verbal and written communication skills with internal and external customers.
Level I: Strong understanding of claims, membership, pricing, and provider data systems.
Level II: All Level I requirements, plus advanced or complex SQL and report-writing capabilities; serves as a department expert.
Level II: Proficiency with data-access tools, including the Oracle suite, SQL Navigator, SQL, VBA, ODBC, report development, form development, import specifications, and case selects.
Level II: Advanced skills in word processing and spreadsheet programs, and highly advanced analytical and problem-solving skills.
Level II: Excellent oral and written communication skills and the ability to present effectively to all levels of management.
Level II: Proven ability to work independently on complex projects with large financial impact or risk to the corporation.
Level II: Proficient understanding of relevant corporate data systems, including claims, membership, pricing, and provider data systems.
Level III: All Level I and II requirements, plus the ability to work well independently or with a team and mentor or coach others; may lead or direct Analyst I or II on projects.

Nice To Haves

Level II and III: STARS and MES experience strongly preferred.
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.

Responsibilities

Create complex reports and modify underlying SQL; validate own work and that of team members for accuracy.
Analyze healthcare services, utilization, costs, trends, enrollment, incentives, and revenue by provider, member, network, group, product, and line of business; prepare reports on findings.
Perform statistical analysis and data modeling in response to user requests, and communicate results and recommendations verbally and in writing.
Maintain existing and develop new information reporting systems; gather reporting requirements directly from internal and external users.
Evaluate how new products, systems, and work processes affect 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.
Make sound decisions on issues with significant corporate risk impact, raise issues and concerns to management, and contribute to meeting departmental deadlines.
At Level II, create enterprise universes, automate enterprise-published reports and dashboards, identify reporting needs, and assemble or direct the assembly of reporting.
At Level II, validate complex reporting produced within and outside the department, provide final sign-off, and define and implement procedures, processes, and tools to automate validation.
At Level III, serve as a technical expert on pharmacy data analytics issues and mentor or coach others; may lead or direct Analyst I or II on projects.

Benefits

Competitive salary and bonus opportunities.
Market-leading 401(k) with significant company match and a potential discretionary contribution based on company performance; no vesting period.
Medical, dental, and vision coverage for employees and eligible family members, including mental health benefits.
Annual employer contribution to a health savings account.
Generous paid time off varying by role and tenure, plus 10 company-paid holidays.
Up to 12 weeks of paid parental time off, subject to eligibility requirements.
Wellness programs with participation rewards.
Employee Assistance Fund.
Commute and parking benefits.
Work-from-home options for most roles, subject to internet requirements.
Employee resource groups and opportunities to participate in company-supported community outreach programs.
Career growth and development at a company committed to employee success.