Just finished the loop and got an offer, so I can share details while they're fresh.
Five rounds total for a Senior Business Analyst role on the claims analytics team: Recruiter screen, 30 min. Fairly standard. They asked about my gap directly and I just explained it plainly. No weirdness. HireVue, 4 questions, recorded. One SQL question (write it out on paper basically), two behavioral, one case-adjacent scenario about conflicting stakeholder priorities. Technical panel with two data analysts. 45 min. Real SQL questions in a shared doc. Window functions came up. They asked me to explain my approach out loud, less about the answer being perfect, more about how I reasoned. Behavioral panel, three interviewers back to back. Classic STAR. Questions around: a time I had to influence without authority, handling a project that went sideways, customer-first decision making. They really mean the customer focus stuff. Insurance is their whole thing. Director-level conversation. More of a culture chat honestly. Asked about career trajectory, why insurance.
What surprised me: they're pretty structured about the competency framework. Every interviewer is covering a specific competency, which meant less redundancy than I expected but also less room to freewheel. Prepare your STAR stories to map to specific traits, don't just tell generic "I did a hard thing" stories.
Timeline from recruiter reach-out to offer was 6.5 weeks. Felt long but it moved steadily.