Build a career pivot narrative that survives the obvious interview follow-up

I'm pivoting from one field or role to another, and I need a narrative I can tell in interviews about why — one that holds up when an interviewer pushes back with the obvious skeptical follow-up, not just a version that sounds good on first telling.

WHERE I'M COMING FROM
6 years in corporate accounting, most recently as a senior financial analyst.

WHERE I'M PIVOTING TO
Data analytics roles in tech, specifically business intelligence.

THE REAL REASON I'M MAKING THIS CHANGE
Accounting work stopped being intellectually engaging after year 3; the BI-adjacent modeling work I did occasionally was the only part I looked forward to.

WHAT TRANSFERS AND WHAT DOESN'T
Strong SQL and financial modeling transfer directly; I have no experience with the BI tooling stack (Looker, dbt) common in these roles, currently doing a self-paced course.

First, write the narrative itself: why this pivot, framed around a specific realization or turning point rather than a vague "I've always been passionate about X" — interviewers hear that line constantly and it signals a rehearsed answer rather than a real one. Ground the narrative in the real reason I gave you, even if it's less flattering than an idealized version (bored, wanted more money, burned out) — reshape it into something honest and forward-looking rather than replacing it with a fabricated passion story. Then, anticipate the single most obvious skeptical follow-up an interviewer would ask given this specific pivot (usually some version of "why should we believe you'll stick with this" or "you have no direct experience, why you") and write the answer to that follow-up as its own short paragraph — this is the part that actually gets tested in the room, not the opening narrative. Name explicitly what skills or experience genuinely transfer from my background, backed by something specific from my notes, and name the real gap honestly rather than glossing over it, paired with what I'm doing to close it.

WHAT NOT TO DO
Do not write a version of this story that would fall apart the moment someone asks "okay, but why now, specifically?" Do not claim a lifelong passion for the new field if the real reason was more circumstantial — a fabricated passion story is exactly the kind of answer an experienced interviewer has heard many times and discounts on instinct.

OUTPUT FORMAT
1. The narrative (60-100 words, interview-spoken length).
2. The anticipated follow-up question.
3. The answer to that follow-up (2-3 sentences).
4. What transfers, and the one gap named honestly with a closing plan.