Novartis Data Analyst Interview Questions
The questions to prepare for a Novartis Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how you used PostgreSQL SQL queries and aggregations to extract analysis-ready data from a single dataset.
NovartisTests data preparation skills and ability to ensure analysis quality and reliability.
NovartisTests practical day-to-day analytics skills using Excel for data exploration and reporting.
NovartisCalculate a 7-day rolling average of Adobe Acrobat document exports using a window function.
Adobe
AbbottOOura RingCompute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIUse joins and LAG to isolate departments driving a large month-over-month spending variance.
State of California
University of Chicago
The Church of Jesus Christ of Latter-day SaintsTests your ability to design and analyze treatment comparisons using appropriate statistical approaches.
NovartisTests your statistical toolkit and ability to select appropriate methods for analysis.
NovartisTests your statistical reasoning for treatment evaluation and ability to handle real-world clinical data.
NovartisSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your ability to identify relevant data sources and define an analytics scope for operations.
NovartisTests your ability to translate operational goals into measurable KPIs and analytics plans.
Novartis