Skip to content
SmithRxSmithRxUnited States

Pharmacy Systems Analyst

Design, build, and maintain complex pricing models and BI tools in SQL and Looker for pharmacy client savings projections. Translate business needs into technical specs, support data warehouse development, perform deep-dive analyses, and provide Tier 3 technical support. Requires 3-5 years data analytics experience, advanced SQL, and BI tool proficiency.

75k – 106k
Remote3+ YOEData Analytics

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

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

Nice-to-Haves

  • Familiarity with GitHub/Version Control and project management tools (e.g., Jira).
  • PBM or Healthcare experience, specifically regarding pharmacy claims data.

Skills

SQLLookerLookmlTableauGitHubJiraData AnalyticsPricing AnalyticsEdwBI Tools

Similar roles

Data Analytics jobs
SmithRx

PBM Client Delivery Analyst

SmithRxUnited States

The PBM Client Delivery Analyst independently queries large datasets, performs ad hoc and deep-dive analyses on historical claims data, generates insights for risk management and client transitions, and delivers high-quality reporting and presentations to stakeholders. Requires 3-5 years experience, strong analytical and project management skills, and proficiency in SQL, Excel, Looker, and Tableau.

75k – 106k
Remote3+ YOEData Analytics
Zus Health

Interoperability Operations Analyst

Zus HealthBoston, MA

Build metrics, dashboards, and tooling to track clinical data coverage across the Zus network. Investigate gaps, partner with support and product teams, and automate workflows using SQL and Python.

80k – 130k
HybridData Analytics
Lyft

Data Analyst, Operations Planning

LyftNew York, NY

Data Analyst on the Urban Solutions team analyzing micromobility operations to improve bike and scooter share performance across US markets. Partners with Product, Engineering, Operations and Finance to forecast needs, diagnose issues, and drive data-informed decisions.

83k – 104k
Hybrid3+ YOEData Analytics
Anaconda

Business Intelligence Analyst

AnacondaUnited States

Builds and maintains dashboards and reports using SQL, dbt, and tools like OMNI/Snowflake to deliver insights from CRM, product, and financial data to GTM, finance, and customer success teams. Requires 3+ years in BI/analytics, proficiency in SQL/dbt, and cloud data warehouses.

85k – 125k
Remote3+ YOEData Analytics
Machinify

DMG Data Mining Analyst II

MachinifyUnited States

Data Mining Analyst responsible for extracting insights from large healthcare datasets using SQL and data mining techniques. Lead small projects, create reports, and train new analysts while collaborating across departments.

90k – 140k
Remote5+ YOEData Analytics