Pharmacy Data Analyst I, II, or III

Cambia Health Solutions•Little Rock, AR

3d•$49,000 - $143,000•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 support pharmacy management decisions and corporate initiatives. The role uses pharmacy data analytics to inform strategic decisions, address challenges with significant financial implications, and help optimize pharmacy services and healthcare delivery. The analyst works independently and collaboratively in a fast-paced environment, with responsibilities and qualifications varying by level. This is a hybrid role, with three days per week in the office, at Cambia offices in Salt Lake City, Boise, Fargo, Portland, Vancouver, Renton, Medford, Burlington, Lewiston, Little Rock, and Springdale. Preference is given to current employees and candidates who live within commuting distance of specified offices or are willing to relocate. Compensation varies by level and location, with salary ranges and bonus targets specified in the posting.

Requirements

Bachelor's degree in business, health information administration, mathematics, statistics, computer science, or a related field, or an equivalent combination of education and experience.
Relevant experience in data analysis or supporting relational database development, maintenance, or utilization in healthcare or business systems: 2 years for Level I, 5 years for Level II, or 8 years for Level III.
Advanced SQL and report-writing skills; proficiency with Oracle tools, SQL, and Snowflake.
Proficiency in Microsoft Word and Excel, including pivot tables, VLOOKUP/XLOOKUP, macros, and VBA.
Advanced analytical and problem-solving skills and the ability to work independently and implement solutions.
Business acumen in areas such as finance, accounting, statistics, risk management, and 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 when working with internal and external customers.
Strong understanding of claims, membership, pricing, and provider data systems.
For Level II, advanced or complex SQL and report-writing capabilities, expertise with data-access tools including Oracle tools, SQL Navigator, SQL, VBA, ODBC, report and form development, import specifications, and case selects; advanced word-processing and spreadsheet skills; ability to present to all levels of management; and a record of independently handling complex projects with significant financial impact or corporate risk.
For Level III, the Level I and II requirements, plus the ability to work independently or with a team and mentor or coach others; may lead Analyst I or II projects.

Nice To Haves

STARS and MES experience are strongly preferred for Levels II and III.
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 work and that of other team members for accuracy.
Analyze data and prepare reports on healthcare services, utilization, costs, trends, enrollment, incentives, and revenue by provider, member, network, group, product, and line of business.
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, gathering reporting requirements directly from users.
Evaluate the effect of new products, systems, and work processes on data and reporting systems, and coordinate 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 interpreting data, using data tools, and preparing queries and reports.
Make sound decisions on issues with significant corporate risk impact, raise 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 their assembly.
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 and potentially mentor or coach others and lead Analyst I or II projects.

Benefits

Competitive salary and bonus opportunities; bonus targets are 6% for Level I, 10% for Level II, and 15% for Level III.
Medical, dental, and vision coverage for employees and eligible family members, including mental health benefits.
Annual employer contribution to a health savings account.
Paid time off that varies by role and tenure, plus 10 company-paid holidays.
401(k) retirement plan with a company match and potential discretionary contribution based on company performance.
Up to 12 weeks of paid parental time off, subject to eligibility requirements.
Wellness programs that reward participation.
Employee Assistance Fund.
Commute and parking benefits.
Work-from-home options for most roles, subject to internet connection requirements.
Employee resource groups and opportunities to participate in Cambia-supported community outreach programs.