Senior Analyst, Business Analytics

Role Summary

The Senior Analyst, Business Analytics will create systems and pipelines to collect and transform data into reliable and accessible datasets. This position will also develop data models for analysis, produce data analytic solutions, and automate reports that will support ImmunityBio’s Commercial operations in strategic and tactical decision making. Location: on-site or remote depending on geographic location.

Responsibilities

• Design, build, and maintain pipelines that integrate medical & pharmacy claims, specialty pharmacy dispenses, patient services/HUB enrollment (BV/PA/appeals/copay), 3PL/distributor shipments, and indirect sales/chargebacks into conformed, analytics-ready models. Apply rigorous data quality, deduplication, and crosswalk logic (e.g., J-code to NDC, buy-and-bill vs pharmacy) and reconcile SP to claims to /867 flows to produce accurate patient-funnel, access, and revenue insights.
• Partner with the IT team and apply strong knowledge of modern warehouses (Snowflake/Databricks) and data modeling design/enhance scalable environments, build analytics-ready layers, and contribute to ETL/ELT.
• Collaborate with IT to design/enhance dashboards (Tableau/Power BI/Qlik Sense)
• Develop advanced Excel solutions (modeling, pivots, Power Query, VBA/macros) to reduce manual effort via SQL + Excel (Power Query/VBA) where appropriate.
• Automate and produce daily sales reporting, support IC calculations, and deliver medical claims and call-activity reporting.
• Create, edit and adhere to Standard Operating Procedures (SOPs).
• Performs ad-hoc and cross-functional duties and/or projects as assigned to support business needs and provide developmental opportunities.

Qualifications

• Required: Bachelor’s degree in Data Analytics, Computer Science, Information Systems or relevant field with 7+ years of relevant work experience is required
• Required: Experience with commercial data is required
• Required: Experience and proficiency with SQL is required.
• Preferred: Experience with Python is preferred
• Preferred: Experience with HTML/CSS is preferred
• Preferred: Previous experience in the pharmaceutical industry is preferred

Skills

• Advanced SQL knowledge to build and optimize complex queries at scale, with rigorous data quality checks and reproducible, auditable outputs
• BI expertise (Tableau/Power BI/Qlik) and advanced Excel skills (modeling, pivots, Power Query; VBA/macro)
• Knowledge and understanding of Life-sciences claims
• Working knowledge of modern warehouses (Snowflake/Databricks) and dimensional/normalized modeling
• ELT (Extract, Load and Transform) familiarity
• Effective cross functional communication and collaboration between internal and external stakeholders

Education

• Bachelor’s degree in Data Analytics, Computer Science, Information Systems or relevant field

Additional Requirements

• This position works on site or remote depending on the candidate’s geographic location.
• Lift and carry materials weighing up to 20 pounds.
• Must possess mobility to work in a standard office setting and to use standard office equipment, including a computer.