Amgen Business Intelligence Analyst Interview Questions
The questions to prepare for a Amgen Business Intelligence Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain practical SQL techniques to preserve data integrity when combining multiple data sources.
AmgenExplain how to profile, clean, and standardize missing or dirty data before analysis.
AmgenExplain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.
AmgenCompute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.
Use a FULL OUTER JOIN and CASE expression to identify matched and unmatched OneTrust QA test cases and executions.
Health Catalyst
Goodwill Industries Of Tulsa
OneTrustUse conditional aggregation on a single event table to find users who sent messages but never joined Discord voice channels.
DiscordTests communication, ownership, and stakeholder management when translating technical complexity into actionable business understanding.
AmgenTests prioritization under pressure, stakeholder management, and decision-making when multiple teams compete for limited analyst capacity.
AmgenAssesses conflict resolution, communication, and ownership when collaborating with a difficult teammate under delivery pressure.
AmgenTests influence without authority through data-driven persuasion, stakeholder management, and clear communication under resistance.
AmgenPick metrics for a new program by tying them to the goal, separating leading and lagging signals, and defining a clear KPI set.
AmgenSign up to see every question
Create a free account to unlock this list and practice real interview questions.