Senior Analyst, BI Architecture (Operations)

About Our Organization: RIS Rx (pronounced "RISE Rx") is on a mission to make every dollar allocated for affordability count, delivering true impact for the patients and pharma manufacturers we serve. We’ve built the industry’s first real-time, pharmacist-led GTN Revenue Performance platform, restoring trust, visibility, and integrity to patient affordability.

What sets us apart? Our team combines deep pharmacy roots with cutting-edge technology, tackling patient access barriers in smarter, more human ways. Our people-first culture means you’ll find career growth, great benefits, and a supportive environment waiting for you, because we believe when people thrive, everyone wins.

Join us and help shape a better, brighter future for patient access.

Senior Analyst, BI Architecture (Operations) Location: Irvine, California Team: Business Intelligence / Analytics (supporting Internal Operations)

What makes this role unique:

• Directly enable the operations teams who keep patient access programs running for critical medications
• Own the governed Sigma layer (data models, metrics, and calculations) that ops relies on every day
• Build self-service so ops can answer their own questions instead of waiting in a report queue
• Develop specialized expertise in healthcare market access and gross-to-net (we’ll teach you the domain!)
• Real influence on BI standards, with autonomy to identify problems and design the solutions
• Clear growth path with comprehensive development support

Ideal for someone who:

• Gets energized by building data models that make everyone else’s analysis faster and more trustworthy
• Cares about the definitions and logic behind the numbers, and about getting one version of the truth
• Enjoys turning messy operational questions into clean, reusable metrics
• Likes teaching and enabling others, not just building things for them
• Thrives when given ownership and trusted to figure things out
• Wants meaningful work that makes a real difference

What You’ll Do Build and Own Sigma Data Models

• Design, build, and maintain Sigma data models that serve as the certified source of truth for operations reporting
• Translate ops requirements into scalable model structures, resolving issues like join fan-out, grain mismatches, and reversal handling
• Review and refactor existing models to reduce duplication, improve performance, and eliminate conflicting logic
• Partner with data engineering by documenting and specifying the upstream data needs that models depend on

Define Metrics and Calculations

• Define, document, and govern the metrics and calculated fields used by operations (the formulas are the source of truth, not the prose)
• Build reusable metric libraries so ops teams calculate KPIs consistently across every report
• Validate calculations against source systems and partner with stakeholders to resolve discrepancies
• Manage change control so metric updates are tested, documented, and communicated

Enable Ops Self-Service

• Curate certified, well-labeled datasets with clear naming, descriptions, and organization so ops can find and trust them
• Partner with ops leads to understand how they work and what questions they need to answer
• Train and coach ops users on building their own workbooks, dashboards, and reports
• Run office hours, create how-to guides, and maintain a library of templates and examples
• Build or support dashboards only where a shared, standardized view is needed

Drive Governance and Standards

• Establish BI architecture standards: naming conventions, model layering, folder and permission structure, and documentation
• Manage access, permissions, and data security in Sigma so users see what they should
• Maintain data dictionaries, model documentation, and SOPs
• Identify and implement improvements that reduce manual reporting and one-off requests

Must-Have Qualifications

Technical Foundation:

• 5+ years of hands-on experience with BI tools (Sigma, Power BI, Tableau, Looker, Qlik, or similar), in-house or in a consulting environment
• Proven experience building governed data models, metrics, and calculated fields in a BI platform, owning them from design through production
• Experience with data governance, row-level security, or semantic layer design in a BI environment
• Experience defining operational KPIs for ops, finance, or customer support teams
• Strong SQL: you write and troubleshoot complex queries independently (CTEs, window functions, joins across multiple grains) to build and validate models
• Strong data modeling fundamentals: fact and dimension design, grain definition, star schemas, normalization vs. denormalization
• Experience enabling self-service analytics for non-technical business users
• Working familiarity with a cloud data warehouse (Snowflake, BigQuery, Redshift, or similar)

Professional Capabilities:

• Excellent communication skills: you explain modeling decisions and metric logic to non-technical audiences, verbally and in writing
• Comfortable teaching, coaching, and supporting business users at varying skill levels
• Self-starter mentality: you identify problems, take initiative, and move work forward with limited direction
• Detail-oriented with a quality focus: accuracy matters when ops decisions depend on your models
• Comfort with ambiguity: you work effectively with incomplete requirements and figure out next steps
• Strong documentation habits so others can maintain and build on your work
• Bachelor’s degree in Business, Economics, Finance, Data Analytics, Information Systems, Computer Science, or a related field

Nice-to-Have (We’ll Teach You These)

• Sigma experience specifically (if your BI background is in another tool, we’ll get you up to speed)
• Healthcare industry knowledge (market access, specialty pharmacy, payer dynamics, gross-to-net)
• BI consulting experience working with multiple stakeholders or clients
• Experience mentoring junior analysts