Senior BI Developer

RxSense LLC; United States; Remote; USD 145,000 - 165,000; Full time

Job summary

RxSense LLC, a healthcare technology leader, seeks a Senior BI Engineer to own the analytics stack from the governed metrics layer in Snowflake to enterprise BI dashboards. Role balances data modeling and metrics governance with dashboards, plus AI-enabled development workflows.

You will implement metric definitions once, serve them across BI tools, client reporting, and AI systems, while ensuring data quality and governance across the platform.

Qualifications

• 5+ years of hands-on BI experience with data models, metrics, and dashboards.
• Strong data analytics grounding: data modeling, metric definition, analytics questions behind dashboards.
• Experience with Snowflake and cloud data warehouses.
• Breadth across BI tools (ThoughtSpot, Sigma, Tableau, Power BI, Qlik Sense).
• Strong SQL and AI-enabled analytics tooling experience.

Responsibilities

• Design, build, and maintain gold-layer data models and a governed metrics layer in Snowflake using dbt.
• Establish metric definitions as the single source of truth with clear ownership and change management.
• Push transformation logic into the warehouse to keep consumption layers simple and high-trust.
• Collaborate with data engineering on raw/silver vs gold/metrics boundaries.
• Structure and document metrics for AI agents and autonomous analytics systems.
• Build and maintain dashboards and analytics in enterprise BI platform on governed metrics.
• Translate business questions into metrics and visuals.
• Optimize dashboards/queries for high-volume data and performance.
• Recommend BI design patterns across tooling for better practice.
• Build with coding agents and AI-assisted tooling in development environments.

Skills

SQL proficiency

Data modeling

Metrics definitions

BI dashboards

AI workflow fluency

Tools

Snowflake

dbt

ThoughtSpot

Sigma

Tableau

Power BI

Qlik Sense

Job description

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.
• Optimize dashboards and queries for high‑volume data, proactively resolving performance bottlenecks before they reach users.
• Apply breadth across BI tooling and design patterns to recommend the right approach and distinguish good practice from bad.

AI‑Native Development

• Build with coding agents and AI‑assisted tooling as a primary part of the workflow — accelerating model development, dashboard creation, documentation, and testing.
• Independently set up and manage development environments, repositories, and the tooling needed to work effectively with agentic systems.
• Help establish team practices and standards for building analytics in the AI era.

Quality, Governance & Tooling Judgment

• Champion data quality, consistency, and trust across all delivered analytics, ensuring numbers hold up under scrutiny.
• Contribute to platform and architecture decisions; identify opportunities for automation, templating, and process improvement.

Qualifications

Required

• 5+ years of hands‑on experience building business intelligence solutions — data models, metrics, dashboards, and reporting — in a data‑driven organization.
• Strong grounding in data analytics as a domain: data modeling, metric definition, and the analytical questions behind the dashboards.
• Proven experience building data models and transformations in a cloud data warehouse (Snowflake) with
• Demonstrated breadth across BI tools (e.g., ThoughtSpot, Sigma, Tableau, Power BI, Qlik Sense), with the judgment to evaluate trade‑offs and recognize quality design.
• Strong SQL proficiency.
• Fluency working in the AI era: building with coding agents, setting up development environments, and using AI tooling as a core productivity multiplier.
• Strong communication skills and the ability to translate business needs into technical deliverables.

Preferred

• Experience in pharmacy benefits management, healthcare technology, or a related regulated industry.
• Experience building a governed semantic/metrics layer or moving transformation logic out of the BI layer and into the data warehouse.
• Familiarity with version control, CI/CD, and software‑engineering practices applied to analytics.
• Experience building demo environments or client‑facing reporting.

Salary Range: $145,000 - 165,000

RxSense believes that a diverse workforce is a more talented and productive workforce. As such, we are an Equal Opportunity and Assertive Action employer. Our recruitment process is free from discriminatory hiring practices and all qualified applicants are considered for employment without regard to race, color, religion, sex, gender, sexual orientation, gender identity, ancestry, age, or national origin. Neither will qualified applicants be discriminated against on the basis of disability or protected veteran status. We believe in the strength of the collaboration, creativity and sense of community a diverse workforce brings.