Pharmacy Data Analyst I, II, III

Cambia Health Solutions

. Develop sophisticated reporting solutions and conduct complex pharmacy data analyses .

Posted 10/23/2026full-timeUnited StatesJuniorMid-Level💰 $49,000 - $143,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in pharmacy data analysis, advanced SQL, and reporting solutions, with strong analytical and problem-solving skills. Capable of mentoring and training others while maintaining data integrity and developing reporting systems based on user requirements.

Highest-signal resume keywords

Advanced SQL SkillsPharmacy Data AnalysisOracle Tools ProficiencyStatistical AnalysisMentoring and Training

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData ModelingStatistical AnalysisReport WritingData ValidationData AnalysisData InterpretationComplex Project ManagementFinancial AcumenProblem-Solving

Soft Skills

Strong Communication SkillsBusiness AcumenInterdepartmental CollaborationTraining AbilityAttention to Detail

Tools & Technologies

Oracle SuiteSnowflakeMS ExcelMS WordVBASQL NavigatorODBCAI ToolsSTARSMES

Industry Keywords

Pharmacy DataHealth Information AdministrationClaims DataMembership DataProvider Data SystemsRisk ManagementProject ManagementHealthcare ServicesUtilization AnalysisCost Trends

Tech Stack

Tools & technologies

OracleSQLVBA

About the role

Key responsibilities & impact

Develop sophisticated reporting solutions and conduct complex pharmacy data analyses
Create complex reports and modify underlying SQL; validate own and team members' work
Analyze health care services, utilization, costs, trends, enrollment, incentives, and revenue across providers, members, networks, groups, products, and lines of business
Perform statistical analysis and data modeling; communicate results and recommendations
Maintain existing and develop new information reporting systems based on user requirements
Evaluate impacts of new products, systems, and processes on data and reporting systems
Collaborate with transaction-system departments to maintain data integrity and reliability
Develop and execute balancing and data-validation routines for data warehouse updates
Assist and train business analysts on data interpretation, data tools, queries, and report preparation
Raise issues and concerns involving corporate risk and help meet departmental deadlines
Level II: create enterprise universes, automate published reports and dashboards, assemble or direct reporting, validate complex reports, and implement automated validation processes
Level III: serve as technical expert on pharmacy data analytics and mentor or lead Analysts I and II on projects

Requirements

What you’ll need

Pharmacy Data Analyst I: Bachelor's degree in business, health information administration, mathematics, statistics, computer science or related field and 2 years' relevant work experience, or equivalent combination of education and experience
Pharmacy Data Analyst II: Bachelor's degree in a listed or related field and 5 years' relevant work experience, or equivalent combination of education and experience
Pharmacy Data Analyst III: Bachelor's degree in a listed or related field and 8 years' relevant work experience, or equivalent combination of education and experience
Advanced SQL and report-writing skills
Proficiency with 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
Strong business acumen in finance, accounting, statistics, risk management, and project management
Ability to create desk procedures and lead interdepartmental training
Strong verbal and written communication skills
Understanding of claims, membership, pricing, and provider data systems
Level II: advanced/complex SQL; Oracle suite, SQL Navigator, VBA, ODBC, report, form, import specification, and case select tools; ability to present to management; complex-project experience with substantial financial impact or corporate risk
Level III: ability to mentor/coach others and potentially lead Analyst I or II projects
STARS and MES experience strongly preferred for Levels II and III
Experience with AI tools highly desired
Background check required
Personal mobile device required for MFA
Wired internet connection required for work-from-home options, with minimum 5 Mb upload and 10 Mb download speeds

Benefits

Comp & perks

Competitive salary
Bonus opportunities: 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
Generous paid time off
10 company-paid holidays
Market-leading 401(k) with company match
Potential discretionary retirement contribution based on company performance, with no vesting period
Up to 12 weeks of paid parental time off after 12 months of continuous service
Award-winning wellness programs that reward participation
Employee Assistance Fund
Commute and parking benefits
Work-from-home options for most roles
Employee resource groups
Cambia-supported community outreach programs