Skip to content

Pharmacy Systems Analyst

United StatesRemote3+ YOE
Summary

Design and refine pricing models in SQL and Looker, translate business requirements into technical specs for the Enterprise Data Warehouse, and provide Tier 3 analytics support. Requires 3-5 years in data analytics or pricing, advanced SQL, and BI tool experience.

About the role

Responsibilities

  • 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 the Enterprise Data Warehouse (EDW) in collaboration with 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.
  • 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.
  • 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.
  • Continuously analyze and evaluate existing reporting processes, identifying inefficiencies or gaps, and proactively deploying creative solutions.

Requirements

  • 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.
  • 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.
  • Attention to detail with pride in the accuracy of formulas and cleanliness of code.
  • Capable of facilitating deep technical discussions with Engineers while translating the "why" to non-technical stakeholders.

Benefits

  • 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).
  • Professional development and training opportunities.
Skills
SQLLookerLookMLTableauGitHubJiraData AnalyticsData WarehousingBusiness IntelligenceVersion Control