Business Intelligence Developer

Job Title: Business Intelligence DeveloperReports to: Manager, BILocation: Irvine, CAFLSA Status: ExemptAbout 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 membershipModern officeAnnual merit-based salary increases401(k) with annual company matchMedical - RIS Rx covers 100% of the employee’s base HMO medical planVoluntary Dental, Vision & Life InsuranceFlexible Savings Account (FSA)Paid HolidaysTime off that grows with you:3 weeks PTO 0-2 years4 weeks PTO after 3+ years5 weeks PTO after 5+ yearsRecognition programs that celebrate impact and resultsMentorship and coaching opportunitiesClear growth paths and career development supportFully stocked snack kitchenCompany-paid lunches