What carries over
| What you did as a marketing analyst | Where it shows up now |
|---|---|
| Fixed broken UTM data | Write tests that catch it |
| Joined ad and CRM data | Build staging and mart models |
| Argued over numbers | Define one tested metric |
| Wrote SQL queries | Turn them into models |
What is new
- dbt and version control.
- Data modelling.
- Writing tests.
Try it: Test the Model
A quick exercise using your own experience.
Test the Model
Your first proof in 30 days
Build a small dbt project on public data with three tested models. Share it on GitHub.
Your 30/60/90 quests
XP: learning 20 · proof 60 · outreach 40. Ranks: Wayfinder → Builder → Pathmaker. Progress stays in your browser only.
Worries, answered
Is this too technical for me? It is SQL plus discipline, and you already write SQL to answer marketing questions.
I have never used Git. Git basics take a weekend to learn, and free guides cover everything you need.
Pay, honestly
We haven't verified pay data for this move. Analytics engineering pay depends on the company's data stack and team size. Compare live listings for your city and ask whether the role owns dbt models or only reports.
Your realistic 90 days
You worked as a marketing analyst. This plan moves you toward analytics engineer in 90 days, using what you already do.
Assumes 2–3 hours a day alongside job applications, a laptop and a phone, and free plans only. Every step has a smaller version and a way to pause. Use them. It runs in three blocks of 30 days, each ending with a signal that you're on track. A signal is not a promise of a job or income.
Other worries
Age, a career gap, no degree, English, family pressure and savings are covered on the route page and the role page.
Your first 7 days
| Day | Task | Done when |
|---|---|---|
| 1 | Read the dbt introduction | Notes |
| 2 | Load a public dataset into BigQuery | Loaded |
| 3 | Write one staging model | Model |
| 4 | Add a unique test | Test |
| 5 | Build one mart model | Mart |
| 6 | Push to GitHub | Repo |
| 7 | Save 10 postings | 10 links |
Days 1–30: Tested dbt project
| Step | Time | Done when | Smaller version | If you need to pause |
|---|---|---|---|---|
| Publish a dbt project with three tested models | about 8 hours over 3 weeks | repo | One model. | Stop at the end of the step you're on and write two lines about where you stopped. Pick it up from those notes later. |
| Show it to 5 people who hire for this | about 1 hour | 5 messages | Show it to 2 people who hire for this. | Optional. If reaching out feels like too much this week, skip it and put the time into your proof. |
Signal by day 30: An engineer asks about your tests.
Days 31–60: Applications
| Step | Time | Done when | Smaller version | If you need to pause |
|---|---|---|---|---|
| Turn your proof into a one-page case and CV line | about 8 hours | case + CV | CV line only. | Put it on hold until your current interviews are done, then come back to it. |
| Apply to 10 analytics engineer roles | about 5 hours | 10 logged | Apply to 5 roles. | Stop sending for now. Keep a list of who you've contacted so you can follow up later without doubling up. |
Signal by day 60: A screening call.
Days 61–90: Interviews for analytics engineer roles
| Step | Time | Done when | Smaller version | If you need to pause |
|---|---|---|---|---|
| Practise a 2-minute story of why you are moving | about 2 hours | 2 practice runs | 1 run. | Optional. Skip it if the week is full; nothing later depends on it. |
| Ask 3 people for referrals into analytics engineer teams | about 2 hours | 3 asks | Just one instead of 3. | Stop sending for now. Keep a list of who you've contacted so you can follow up later without doubling up. |
Signal by day 90: A second round or a paid trial.
One search that fits your background
The full set of search strings for this move is on the route page. They work on LinkedIn, Naukri and foundit; Instahyre and Cutshort are worth a weekly look too. Add your old job title to any of them with AND, so recruiters who want both skills find you first.
Job-hunt moves that matter for this route
- Show a public dbt repo with tests.
- Explain one data bug you caught.
- Target data teams at SaaS and D2C firms.
Fake-job traps
Watch for 'marketing internships' that charge a registration or certificate fee, 'work from home' review or like-and-earn tasks, and anyone asking for an OTP, UPI PIN or a deposit before you start. Real employers never charge you to hire you. Use official domains only. Report in India at cybercrime.gov.in or call 1930; in the US, ReportFraud.ftc.gov.
Back to Marketing Analyst · About the Analytics Engineer route · Marketing hub
Quick quiz: does this path fit?
Answer each, then press Check. Every answer explains itself.
Make your Path Card
A shareable reminder of where you're heading. The day count starts the first time you open this page; quest XP comes from your log above.
Scam check before you apply anywhere
- Real job and gig platforms are free to join. Never pay a "joining" or "training" fee.
- Never share an OTP or UPI PIN — no genuine employer needs them.
- Use official domains only; type the address yourself.
- India: report at cybercrime.gov.in or call 1930.
- US: report at ReportFraud.ftc.gov.
Small steps, every day.
Each quest has a smaller version for hard weeks, and a pause button. Nothing is lost.
Keep exploring
Sources
Checked 26 Oct 2026. We opened every link below ourselves. Search volumes on this site come from OpenSEO keyword research (Oct 2026).
The other facts here are shared with the route page, where each is listed in full with its link.
| What we checked | Where |
|---|---|
| dbt documentation | docs.getdbt.com |