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
5+ years in a Data Analytics or Pricing focused role with a Bachelor’s degree; or 3+ years with a Master’s degree.
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.
Tech Stack
SQL
Tableau
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)
Well-stocked kitchen in office locations
Professional development and training opportunities