We are a healthcare technology company that provides platforms and solutions to improve the management and access of cost-effective pharmacy benefits. Our technology helps enterprise and partnership clients simplify their businesses and helps consumers save on prescriptions.

As a leader in SaaS technology for healthcare, we offer innovative solutions with integrated intelligence on a single enterprise platform that connects the pharmacy ecosystem.  With our expertise and modern, modular platform, our partners use real-time data to transform their business performance and optimize their innovative models in the marketplace.

Position Summary

The Senior BI Engineer builds the trusted analytics that power decisions for both internal stakeholders and external PBM clients — owning the work end to end, from the governed metrics layer in the cloud data warehouse to the visualizations that bring those metrics to life.

This is a hands-on role with a balanced center of gravity: roughly half your time modeling data and defining metrics in the warehouse, and half building the dashboards and analytics experiences on top of them in our enterprise BI platform. The guiding principle is build once, consume everywhere — define a metric a single time, governed and version-controlled, then serve it consistently to every downstream consumer: BI tools, client-facing reporting, and AI systems.

You will also build the AI-native way: standing up your own development environment, working fluently with coding agents, and treating AI tooling as a core part of how analytics gets delivered. This role does not own raw-data ingestion or source pipelines — your work begins at the gold layer and extends through to the consumer.

Key Responsibilities

Metrics Layer & Gold-Layer Modeling (≈50%)

• Design, build, and maintain gold-layer data models and a governed metrics layer in Snowflake using dbt — clean, tested, documented, and version-controlled.
• Establish metric definitions as the single source of truth: calculated once, reused everywhere, with clear ownership and change management.
• Push transformation and calculation logic upstream into the warehouse so the consumption layer stays simple, consistent, and high-trust — eliminating per-dashboard logic and manual rework.
• Partner with data engineering on the boundary between raw/silver pipelines (theirs) and the gold/metrics layer (yours).
• Structure and document metrics so they meet the governance and consistency requirements of AI agents and autonomous analytical systems.

Visualization & BI Delivery (≈50%)

• Build and maintain dashboards, reports, and analytics experiences in our enterprise BI platform that sit on top of governed metrics rather than reinventing logic.
• Translate business questions into both the underlying metric and the visualization that communicates it.