Pharmacy Systems Analyst

Posted Yesterday
Be an Early Applicant
Hiring Remotely in USA
Remote
90K-106K Annually
Mid level
Pharmaceutical
The Role
Build, refine, and maintain pricing models and bid data pipelines using SQL and Looker/Tableau. Translate stakeholder requirements into technical specs, collaborate with Data and Engineering, maintain documentation and roadmap, provide Tier-3 support for complex submissions, perform deep-dive analyses, and develop self-service BI reporting and automation.
Summary Generated by Built In

Who We Are:

SmithRx is a rapidly growing, venture-backed Health-Tech company.  Our mission is to disrupt the expensive and inefficient Pharmacy Benefit Management (PBM) sector by building a next-generation drug acquisition platform driven by cutting edge technology, innovative cost saving tools, and best-in-class customer service.  With hundreds of thousands of members onboarded since 2016, SmithRx has a solution that is resonating with clients all across the country.

We pride ourselves for our mission-driven and collaborative culture that inspires our employees to do their best work. We believe that the U.S healthcare system is in need of transformation, and we come to work each day dedicated to making that change a reality. At our core, we are guided by our company values:

  • Integrity: Our purpose guides our actions and gives us confidence in the path ahead. With unwavering honesty and dependability, we embrace the pressure of challenging the old and exemplify ethical leadership to create the new.
  • Courage: We face continuous challenges with grit and resilience. We embrace the discomfort of the unknown by balancing autonomy with empathy, and ownership with vulnerability. We boldly challenge the status quo to keep moving forward—always.
  • Together: The success of SmithRx reflects the strength of our partnerships and the commitment of our team. Our shared values bind us together and make us one. When one falls, we all fall; when one rises, we all rise.

Job Summary:

The Pricing Systems Analyst will be the architect and the builder behind SmithRx’s pricing models and bid data infrastructure. This role focuses on the back-end development, refinement, and enhancement of our proprietary pricing tools using SQL, Tableau, and Looker. You will act as the bridge between the Proposals teams and our Data, Engineering, and Operational departments, ensuring our data pipelines are robust, our models are accurate, and our pricing pathways are cutting-edge.

While focused on development, this role remains a critical subject matter expert, providing ad-hoc support and direct contribution on high-complexity submissions when the pipeline requires support or deep technical intervention.

What you will do:

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

What you will bring to SmithRx:

  • Experience: 3-5 years in a Data Analytics or Pricing focused role
  • Education: 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.
  • Industry Knowledge: PBM or Healthcare experience is a significant plus, specifically regarding pharmacy claims data.
  • Communication: The ability to take a "messy" business requirement from a Sales Lead and translate it into a clean, repeatable technical specification.
  • Soft Skills: Highly self-motivated, adaptable, and willing to work collaboratively in a fast-paced environment.
  • Attention to Detail: You take pride in the accuracy of your formulas and the cleanliness of your code.
  • Leadership: Capable of facilitating deep technical discussions with Engineers while being able to translate the "why" to non-technical stakeholders.

What SmithRx Offers You: 

  • 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

Zone A includes the following locations:

  • San Francisco Bay Area - California
  • Metro New York City - Connecticut, New Jersey, New York and Pennsylvania
Zone A
$89,800$105,600 USD

Zone B includes the following locations:

  • California - outside of San Francisco Bay Area
  • Metro Denver / Boulder - Colorado
  • Metro District of Columbia - District of Columbia, Maryland, Virginia and West Virginia
  • Metro Boston / Cambridge - Massachusetts and New Hampshire
  • Metro Austin - Texas
  • Metro Seattle - Washington
Zone B
$82,300$96,800 USD

Zone C includes all other locations not listed above, including:

  • Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Mexico, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Rhode Island, South Carolina, South Dakota, Tennessee, Utah, Vermont, Wisconsin, Wyoming
  • Non metro Colorado, Connecticut, Maryland, Massachusetts, New Hampshire, New Jersey, New York, Pennsylvania, Texas, Virginia, Washington, and West Virginia
Zone C
$74,800$88,000 USD

Compensation & Benefits

  • Base Salary: The range listed above reflects our standard pay scale and actual pay will vary based on work location, job level, job-related knowledge, skills, and experience.
  • Total Rewards: In addition to base pay, this role may be eligible for bonuses, commissions, or equity. SmithRx offers a variety of benefits to help you live well, including: time off programs, medical, dental, vision, mental health support, paid parental leave, life and disability insurance and 401(k).

Individual offers are tailored to your geography, experience, skills, and education. Your recruiter can share more specific details during the hiring process. In the meantime, feel free to explore our comprehensive benefits here.

Skills Required

  • 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)
  • Experience with Looker (LookML), Tableau, or similar BI tools
  • Familiarity with GitHub/version control and project management tools (e.g., Jira)
  • PBM or healthcare experience, specifically with pharmacy claims data
  • Strong communication skills to translate business requirements into technical specifications
  • Attention to detail and clean, accurate code and formulas
  • Ability to lead technical discussions and collaborate with engineers and non-technical stakeholders
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: San Francisco, CA
46 Employees
Year Founded: 2016

What We Do

SmithRx is committed to providing a straightforward approach to reducing drug costs and improving health outcomes. We understand that reducing pharmacy costs is top of mind for us all. We utilize cloud technologies to deliver the most streamlined and cost-effective PBM solution: one that is modularized and can be tailored to meet individual needs. Our compelling value proposition can be summarized simply as follows: - 100% Pass-through Pricing & Lowest Total Costs - The Most Advanced Cloud PBM - Best Health Outcomes

Similar Jobs

Remote or Hybrid
United States
180 Employees
33K-105K Annually

CrowdStrike Logo CrowdStrike

Information Systems Security Officer (Remote)

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
125K-180K Annually

Scratch Financial Logo Scratch Financial

Technical Support

Fintech • Financial Services
Remote
United States
125 Employees
110K-120K Annually

Celonis Logo Celonis

Client Director - Cardinal Health

Big Data • Information Technology • Productivity • Software • Analytics • Business Intelligence • Consulting
Remote or Hybrid
Ohio, USA
3000 Employees

Similar Companies Hiring

Formation Bio Thumbnail
Artificial Intelligence • Big Data • Healthtech • Biotech • Pharmaceutical
New York, NY
150 Employees
Pfizer Thumbnail
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
New York, NY
121990 Employees
Cencora Thumbnail
Healthtech • Logistics • Pharmaceutical
Conshohocken, PA
51000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account