Job Title: Business Intelligence Developer

Reports to: Manager, BI

Location: Irvine, CA

FLSA Status: Exempt

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.

Job Summary: We're looking for a BI Developer to join our BI & Analytics team and transform complex data into clear, reliable, and actionable insights. In this role, you'll build and maintain client-facing dashboards and internal reporting solutions, partnering closely with data engineering teams upstream and business stakeholders downstream. This is a hands-on opportunity for someone who is comfortable working within a modern BI stack and excited to take end-to-end ownership of the reporting layer—from requirements gathering and dashboard development to delivery and ongoing optimization.

Responsibilities

• Design, build, and maintain interactive dashboards and reports that are accurate, performant, and easy for non-technical stakeholders to use.
• Write and optimize SQL to shape source data into clean, well-modeled datasets for reporting.
• Translate business questions and metric definitions into dashboard logic, and document that logic clearly for stakeholders.
• Partner with the data engineering team on data models, schema changes, and data-quality issues, flagging discrepancies at the source rather than patching around them.
• Establish and follow consistent design standards: naming conventions, color and layout systems, reusable components, and export/print-ready formats.
• QC your own work and validate outputs against source-of-truth logic before release.

Skills & Qualifications

• Minimum of 1–3 years of experience building dashboards and reports in a BI tool (e.g., Sigma, Tableau, Power BI, Looker, or similar).
• At least 2 years of working SQL experience - comfortable writing basic queries (SELECT, filtering, simple joins, and aggregations). Advanced SQL is a plus, not a requirement.
• A solid grasp of data modeling fundamentals and how source structure affects reporting accuracy.
• Clear communication skills - you can explain technical logic in plain language and document your work so others can maintain it.
• An eye for design and usability: layout, consistency, and readability matter to you.
• Attention to detail and a QC mindset; you validate before you ship.

Nice‑to‑Have Qualifications

• Experience with Sigma Computing.
• Familiarity with a cloud data warehouse (Snowflake, BigQuery, Redshift, or similar).
• Experience with client-facing reporting and requirements like row-level security or data suppression.
• Comfort with documentation tools (e.g., Confluence) and ticketing/workflow tools (e.g., Jira).

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Mathematics, or a related field preferred, or an equivalent combination of education, training, and professional experience.

What we offer:

• Free gym membership
• Modern office
• Annual merit-based salary increases
• 401(k) with annual company match
• Medical - RIS Rx covers 100% of the employee’s base HMO medical plan
• Voluntary Dental, Vision & Life Insurance
• Flexible Savings Account (FSA)
• Paid Holidays
• Time off that grows with you:
• 3 weeks PTO 0-2 years
• 4 weeks PTO after 3+ years
• 5 weeks PTO after 5+ years
• Recognition programs that celebrate impact and results
• Mentorship and coaching opportunities
• Clear growth paths and career development support
• Fully stocked snack kitchen
• Company-paid lunches