Pharmacy Systems Analyst

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, construct, and enhance intricate pricing models using SQL and Looker to automate and improve the precision of client savings forecasts.

• Convert business needs from stakeholders into technical specifications for the development and validation of our Enterprise Data Warehouse (EDW) in partnership with the Data Analytics and Engineering teams.

• Collaborate directly with Data and Engineering teams to ensure pricing logic aligns with the overall company data architecture and product roadmaps.

• Contribute to the ongoing development of the Pricing Analytics codebase, following best practices for development, stringent audit protocols, and code reviews to guarantee 'client-ready' accuracy across all automated tools.

• Maintain a clear project roadmap for enhancements to pricing tools and produce comprehensive technical documentation for all pipelines and internal logic.

• Provide 'Tier 3' technical support to the Submission Pod, addressing highly complex ad-hoc analyses or assisting during peak volume periods to maintain queue stability.

• Conduct in-depth analyses and investigations into extensive datasets and deliver clear insights based on findings.

• Communicate effectively with internal stakeholders and external partners via email, Slack, phone, video calls, and Jira.

• Develop a thorough understanding of reporting requirements and work cross-functionally to scope projects and create self-service BI reporting and automation when applicable.

• Continuously assess and evaluate existing reporting processes, identifying inefficiencies or gaps, and proactively implement innovative solutions to boost operational efficiency.

⛳️ Requirements

• 3-5 years of experience in a Data Analytics or Pricing-focused role.

• Bachelor’s or Master’s degree in a quantitative discipline (Engineering, Data Analytics, Data Science, Computer Science, or equivalent).

• Advanced skills in SQL (including 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 strongly preferred.

• Experience in PBM or Healthcare, particularly related to pharmacy claims data, is a significant advantage.

• Ability to transform a 'messy' business requirement from a Sales Lead into a clear, repeatable technical specification.

• Highly self-motivated, adaptable, and eager to work collaboratively in a fast-paced environment.

• You take pride in the precision of your formulas and the organization of your code.

• Capable of facilitating in-depth technical discussions with Engineers while effectively communicating the 'why' to non-technical stakeholders.

🏝️ Benefits

• Highly competitive wellness benefits including Medical, Pharmacy, Dental, Vision, and Life Insurance along with AD&D Insurance.

• Flexible Spending Benefits.

• 401(k) Retirement Savings Program.

• Short-term and long-term disability coverage.

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

• Opportunities for professional development and training.