Pharmacy Systems Analyst

SmithRx

Pricing Systems Analyst designing and refining pricing models for innovative pharmacy benefit management solutions. Collaborating with data teams to enhance client savings projections and ensure robust data pipelines.

Posted 6/10/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

SQLTableau

About the role

Key responsibilities & impact

Design, build, and refine complex pricing models in SQL and Looker to automate and enhance the accuracy of client savings projections
Translate business requirements from stakeholders into technical specifications for the development and validation of our Enterprise Data Warehouse (EDW) in collaboration with the Data Analytics and Engineering groups
Coordinate directly with Data and Engineering teams to ensure pricing logic is aligned with broader company data architecture and product roadmaps
Contribute to the evolution of the Pricing Analytics codebase, adhering to best practices for development, rigorous audit protocols, and code reviews to ensure 'client-ready' accuracy across all automated tools
Maintain a transparent project roadmap for pricing tool enhancements and create detailed technical documentation for all pipelines and internal logic
Provide 'Tier 3' technical support to the Submission Pod, stepping in for highly complex ad-hoc analyses or during peak volume periods to ensure queue stability
Execute deep-dive analyses and investigations into large datasets and provide clear insights on findings
Communicate clearly with internal stakeholders and external partners through email, Slack, phone, video call, and Jira
Develop a complete understanding of reporting needs and work cross-functionally to scope projects and develop self-service BI reporting and automation whenever relevant
Continuously analyze and evaluate existing reporting processes, identifying inefficiencies or gaps, and proactively deploying creative solutions to enhance operational effectiveness

Requirements

What you’ll need

3-5 years in a Data Analytics or Pricing focused role
Bachelor’s or Master’s degree in a quantitative field (Engineering, Data Analytics, Data Science, Computer Science, or equivalent)
Advanced proficiency in SQL (complex joins, CTEs, optimization) and experience with Looker (LookML), Tableau, or similar BI tools
Familiarity with GitHub/Version Control and project management tools (e.g., Jira) is highly preferred
PBM or Healthcare experience is a significant plus, specifically regarding pharmacy claims data
The ability to take a 'messy' business requirement from a Sales Lead and translate it into a clean, repeatable technical specification
Highly self-motivated, adaptable, and willing to work collaboratively in a fast-paced environment
You take pride in the accuracy of your formulas and the cleanliness of your code
Capable of facilitating deep technical discussions with Engineers while being able to translate the 'why' to non-technical stakeholders

Benefits

Comp & perks

Highly competitive wellness benefits including Medical, Pharmacy, Dental, Vision, and Life Insurance and AD&D Insurance
Flexible Spending Benefits
401(k) Retirement Savings Program
Short-term and long-term disability
Discretionary Paid Time Off
Paid Company Holidays
Wellness Benefits
Commuter Benefits
Paid Parental Leave benefits
Employee Assistance Program (EAP)
Well-stocked kitchen in office locations
Professional development and training opportunities

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 & Tools

SQLLookerLookMLTableaudata analysisdata validationdata modelingreporting automationtechnical documentationpricing models

Soft Skills

communicationcollaborationproblem-solvingadaptabilityself-motivationattention to detailproject managementstakeholder managementanalytical thinkingtechnical translation