About The Position
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.
Requirements
- 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.
- 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).
Nice To Haves
- Looker Certification is a major plus
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.
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
Number of Employees
1-10 employees
