Senior Analyst, Business Analytics

📋 Description

• • Architect and own end-to-end data pipelines that ingest, cleanse, and harmonize high-volume commercial data sets—medical & pharmacy claims, specialty-pharmacy dispenses, HUB enrollment, 3PL shipments, chargebacks—into Snowflake and Databricks, ensuring single-source-of-truth analytics layers that power daily revenue, access, and patient-funnel reporting for ImmunityBio’s launch brands.
• • Apply rigorous data-quality, deduplication, and cross-reference logic (J-code ↔ NDC, buy-and-bill vs. pharmacy, 867 EDI reconciliation) to deliver trusted, audit-ready data that feeds executive dashboards, field sales, market-access, and patient-services teams.
• • Partner with IT and Commercial stakeholders to design scalable star-schema and data-vault models, implement ELT best practices, and optimize query performance so that 500 M+ rows can be refreshed nightly with <2-hour SLA and 99.9 % accuracy.
• • Build and maintain self-service Tableau / Power BI / Qlik Sense dashboards that surface KPIs such as TRx share, patient persistency, pull-through by payor, copay-card redemption, and IC attainment—reducing ad-hoc request backlog by 40 % within first 6 months.
• • Automate Excel-based financial and sales reporting using Power Query, advanced pivots, and VBA macros; eliminate manual copy-paste steps, cutting month-end close cycle from 5 days to 1.
• • Deliver daily sales flash, weekly medical-claims surveillance, and monthly call-activity heat-maps that enable field leadership to course-correct in real time and maximize launch uptake.
• • Support incentive-compensation calculations with traceable, SOX-compliant data sets; partner with Finance to model quota attainment scenarios and perform post-cycle true-ups.
• • Create and maintain SOPs, data dictionaries, and lineage documentation that satisfy both internal QA and external audit requirements; mentor junior analysts on coding standards and Git-based version control.
• • Drive ad-hoc strategic analyses—forecast vs. actual variance, patient drop-off cohorts, payor formulary win/loss, geographic whitespace—that directly influence pricing, field deployment, and patient-services strategy.
• • Stay current with cloud data-stack innovations (dbt, Airflow, Delta Lake, serverless BI) and proactively recommend upgrades that reduce cost per query or improve refresh latency.
• • Champion a culture of data governance, privacy (HIPAA/PHI), and ethical AI; ensure all data products comply with 21 CFR Part 11 and company QMS.
• • Present findings to VP-level audiences, translating complex SQL logic into clear, actionable narratives that accelerate evidence-based decision making across Commercial, Medical Affairs, and Executive Leadership.