Senior Business Intelligence Developer

Overview: The Senior BI Developer will be the lead architect for our Looker and BigQuery analytics ecosystem. Reporting to the Manager of Analytics, you will be responsible for transforming raw healthcare data (Claims, EHR, Quality Measures) into high-performance LookML models and intuitive, actionable dashboards. This isn't just a "report builder" role. We need a developer who understands the nuances of healthcare data—such as patient attribution, PMPM calculations, and risk adjustment—and can translate those complexities into a scalable, self-service BI environment. Responsibilities: Looker & LookML Architecture Design & Develop: Build and maintain robust, scalable LookML models (Views, Explores, and Models) that serve as the "single source of truth" for the organization. Optimization: Refine LookML code for performance, ensuring dashboards load quickly and BigQuery costs are managed effectively. Governance: Implement version control (Git) and peer-review processes for LookML to ensure data integrity and consistency across all clinical and financial reporting. BigQuery & Data Engineering Collaboration SQL Mastery: Write complex, optimized SQL queries to build persistent derived tables (PDTs) and aggregate tables within BigQuery. Data Modeling: Partner with Data Engineering to influence the design of our data warehouse schema, ensuring it is optimized for downstream BI consumption. Performance Tuning: Monitor and optimize BigQuery query performance through partitioning, clustering, and efficient join logic. Healthcare Analytics & Dashboarding Product Delivery: Design and deploy sophisticated dashboards that track key performance indicators (KPIs) for Value-Based Care, such as MSSP performance, utilization rates, and gaps in care. Metric Standardization: Work with the Manager of Analytics to codify complex healthcare definitions into the BI layer, ensuring a "Member" or "Admission" is defined identically across every report. UI/UX Design: Create intuitive data visualizations that allow non-technical clinical and operations leaders to find insights without training. Qualifications: 8+ years of experience in Business Intelligence or Data Analytics, specifically within the Healthcare industry (Payor, Provider, or Health Tech). Expert-level Looker experience: Deep proficiency in LookML, including experience with Liquid, PDTs, and Looker API. (Looker Certification is a major plus). BigQuery Expertise: Advanced SQL skills and a deep understanding of BigQuery-specific features (e.g., nested and repeated fields, slots, and partition management). Healthcare Domain Knowledge: Proven experience working with medical/pharmacy claims, clinical EHR data, and value-based care metrics (e.g., HEDIS, RAF scores). Benefits: *Variable compensation plans *Tuition, Travel, and Wireless Service Discounts *Employee Assistance Program to support mental health *Employee Foundation to financially assist through unforeseen hardships *Health, Dental, Vision, Company-paid life insurance, 401K, Paid Time Off We also offer several voluntary insurances such as: *Pet Insurance *Term and Whole Life Insurance *Short-term Disability *Hospital Indemnity *Personal Accident *Critical Illness *Cancer Coverage Restrictions apply based on collective bargaining agreements, applicable state law and factors such as pay classification, job grade, location, and length of service. Posted Salary Range: USD $120,000.00 - USD $120,000.00 /Yr.