Lucie, 30: "Data Analyst for 4 years, Analytics Engineer in 8 months — without starting over"
Lucie Miller, 30. Four years as a Data Analyst in retail, pivot to Analytics Engineer in September 2025. Now at Atos. The story of a career change that didn't erase the past — it translated it.
At a glance
| Metric | Before pivot | After pivot |
|---|---|---|
| Role | Data Analyst (retail) | Analytics Engineer (services) |
| Total experience | 4 years | 4 years (translated) |
| Salary | €42k | €49.5k (+18%) |
| Pivot duration | — | 8 months (learning + search) |
| Applications sent | — | 45 targeted |
| Interviews | — | 6 |
| Readiness score before / after | — | 58 → 84 |
| Skills acquired | — | dbt, Snowflake, Airflow, Looker |
The starting point: stagnating in a role the market is reshaping
Four years in the same retail group, as a Data Analyst. Lucie masters SQL, Excel, Power BI, ships dashboards used by 80 people — but watches her data engineer colleagues take on more structural projects, better-paid, more durable in front of AI.
She wants to pivot to Analytics Engineer — the person who models the clean data layer (dbt), industrializes pipelines, becomes the bridge between analysts and infra. Except she has no reference on modern stacks (dbt, Snowflake, Airflow) and every job ad asks for 2-3 years of XP on those exact tools.
"I was stuck in the classic career-changer syndrome: senior overall, junior on the new role. I felt my 4 years of experience were worth something, but I couldn't sell them on Analytics Engineer ads."
Three unanswered questions
- Which skills exactly to fill? dbt, Snowflake, Airflow… but at what level? Which ones first?
- Which skills transfer? SQL, modeling, business sense — how to sell them without sounding "junior"?
- How long before being credible? Three months of Udemy? Six months of side-project? No visibility.
The shift: a structured plan instead of learning blind
Lucie switched to Traject mid-December 2024. The entry diagnostic sets the baseline: readiness score 58/100 for Analytics Engineer, 4 critical gaps identified (dbt, Snowflake, Airflow, Kimball/Inmon modeling methods).
But more importantly: the mapping surfaces 12 transferable skills she wasn't leveraging — complex SQL modeling, stakeholder management experience, production-grade dashboards, retail business sense. These 12 points become the backbone of her new narrative.
"The first thing Traject gave me wasn't a course. It was an honest read of what I already knew how to do. Before that, I felt I had to relearn everything. In reality, I already had 60% of the job."
What concretely changed
1. Learning plan focused on the real gap
Four skills, not thirty. dbt + Snowflake + Airflow + Kimball. For each: a 6-12h estimated path, recommended resources (dbt Fundamentals, Snowflake training, guided side-project), a validation test. Readiness score updated in real time.
Over 4 months, Lucie moved from 58 to 84/100. She built a side-project (dbt modeling on an open-source retail dataset) she could showcase in interviews.
2. Positioning and CV rewritten for the new role
No more "Data Analyst who'd like to do Analytics Engineering". The new CV showcases: 4 years of production SQL modeling, personal dbt project, projected evolution toward modern stacks. The target role's identity is already present on the CV.
3. Interview prep adapted to the pivot
The Traject question bank includes career-changer-specific questions: "Why this pivot now?" "How do you compensate for the lack of production dbt experience?" Lucie prepped STAR answers that turn the career change into an asset, not a handicap.
4. Targeted pipeline: 45 applications, not 300
Instead of sending her CV everywhere, Lucie targeted 45 companies where the data stack is modern AND the Analytics Engineer role is open to hybrid profiles (some analyst, some engineering). Response rate: 24%, vs 5-7% she saw in mass sending.
Results at 8 months (learning + search)
- 1 signed offer: Analytics Engineer at Atos (€49.5k), +18% vs her former Data Analyst salary.
- Readiness score 84/100 on the target role (vs 58 at the start).
- 4 new skills added to the profile: dbt, Snowflake, Airflow, Kimball.
- Visible side-project that became the headline topic of technical interviews.
- No "starting over": the 4 years of experience are recognized, just better narrated.
What Lucie tells career changers
"A successful career change isn't erasing everything to start fresh as junior. It's translating what you've already done into the vocabulary of the new role. For that, you need two things: a learning plan that doesn't scatter, and a narrative that values the bridge between before and after. Traject surfaced both in a week."
Lucie has been at Atos for 6 months. She keeps using Traject to track Analytics Engineer market evolutions and prepare a step up to Lead Analytics Engineer within 2 years.