Data Career Podcast: Helping You Land a Data Analyst Job FAST

By Avery Smith - Data Career CoachBusiness Technology Education Courses Careers

Data Career Podcast: Helping You Land a Data Analyst Job FAST episodes

October 13 232: Why AI Hasn’t Replaced Data Analysts (According to an ex-Google Data Analyst)
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
Watched an ex-Google analyst break down why AI hasn’t replaced data analysts. I show you where I agree and where I don’t.
💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training
👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator
⌚ TIMESTAMPS
00:00 – AI didn’t kill the job
02:45 – Big Tech isn’t the real market
09:15 – The hype doesn’t match the data
16:45 – Where AI guessed wrong
19:03 – The analysts at risk
20:27 – What makes you irreplaceable
📺 Watch Sundas’ original video 👉 https://youtu.be/r4lEzAM3VOY
🎙️ Listen to Out of the Office with Sundas 👉 https://open.spotify.com/show/5yBNLUp8oRPDXoLTkvaBku
🤝 Connect with Sundas on LinkedIn 👉 https://www.linkedin.com/in/sundaskhalid/
🔗 CONNECT WITH AVERY
🎥 YouTube Channel
🤝 LinkedIn
📸 Instagram
🎵 TikTok
💻 Website
24 min
October 06 231: Complete Data Analyst Bootcamp: From Zero to Hired [Free Full Course]
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
Follow this free bootcamp to become a data analyst!
If you want extra help, consider The Accelerator: DataCareerJumpstart.com/daa
💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training
👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator
⌚ TIMESTAMPS
00:00 – Welcome to the Bootcamp
01:57 – How to Become a Data Analyst
25:51 – What Data Tools to Learn
34:15 – How to Get Paid To Learn
43:57 – Entry Level Data Jobs
54:33 – What Do Data Analysts Do?
1:05:09 – Data Analyst Salaries
1:24:36 – How to Get Every Data Tool
1:45:03 – Excel 101
2:24:45 – SQL 101
2:37:27 – SQL Project
2:43:48 – Data Storytelling
3:16:12 – Tableau 101
3:52:33 – Tableau Project
4:04:21 – Power BI Project
4:12:36 – Python 101
4:29:27 – Python Project
4:35:54 – R Project
4:41:54 – Current Job Market
4:52:09 – AI & The Future of Data
5:01:24 – Best Way to Find Jobs
5:09:57 – Update Your Resume
5:44:06 – Create a Portfolio
5:53:51 – How to Apply to Jobs
6:34:12 – Interview Practice
6:44:42 – How to Get Hired
6:57:27 – Next Steps
🔗 CONNECT WITH AVERY
🎥 YouTube Channel
🤝 LinkedIn
📸 Instagram
🎵 TikTok
💻 Website
6 hr 59 min
September 29 230: The Data-Driven Way to Make Decisions (Parenting, Health, Career): Emily Oster
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
Emily Oster is a Harvard trained economist who built a career on making decisions when the data is bad or missing. I asked her how she does it.
💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training
👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator
⌚ TIMESTAMPS
00:00 – Let the decision lead the data
04:03 – Instagram isn't evidence
08:39 – What to do when there's no data
10:57 – Your family is a small business
14:33 – Right decision vs right process
30:21 – The New York test score error
39:00 – Rapid fire myths
🔗 CONNECT WITH EMILY
📚 Expecting Better: https://a.co/d/00ExVFqN
📚 Cribsheet: https://a.co/d/09rGjGjs
📚 The Family Firm: https://a.co/d/08RaAOBh
📈 Emily's artifact: https://claude.ai/code/artifact/ecaef324-0efe-401a-9fca-d5d2816e88ee
📊 Education Substack: https://substack.com/@statetestscoreresults
🤝 LinkedIn: https://www.linkedin.com/in/emilyoster
📸 Instagram: https://www.instagram.com/profemilyoster/
🐦 X: https://x.com/ProfEmilyOster
💻 Website: https://parentdata.org/
🔗 CONNECT WITH AVERY
🎥 YouTube Channel
🤝 LinkedIn
📸 Instagram
🎵 TikTok
💻 Website
Mentioned in this episode:
October Cohort of The Accelerator Starts on October 12th
Land your first data job ASAP with The Accelerator. And for this cohort only, get a discount PLUS our premium job board software PLUS our live AI workshops on how to analyze data
Learn more here: https://datacareerjumpstart.com/daa
https://datacareerjumpstart.com/daa
Live "How to Become a Data Analyst" Webinar
Come learn the EXACT roadmap to landing your first data job: https://web.datacareerjumpstart.com/webinar
45 min
September 22 229: i asked gpt-6 astra how to become a data analyst (it was wrong)
🗺️ Want a FREE roadmap built for you, not by AI? 👉 https://dataanalystroadmap.com
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
I tested GPT-6 Astra on the one question I know best. It got the skills right and almost everything else wrong.
💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training
👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator
💼 Ready to get your projects off your computer? 👉 https://mydatafolio.com
⌚ TIMESTAMPS
00:00 – GPT-6 Astra is here
02:15 – Excel and SQL first
07:45 – Start networking early
10:54 – Learn by doing
14:03 – The worst advice in the plan
🔗 CONNECT WITH AVERY
🎥 YouTube Channel
🤝 LinkedIn
📸 Instagram
🎵 TikTok
💻 Website
Mentioned in this episode:
Live "How to Become a Data Analyst" Webinar
Come learn the EXACT roadmap to landing your first data job: https://web.datacareerjumpstart.com/webinar
October Cohort of The Accelerator Starts on October 12th
Land your first data job ASAP with The Accelerator. And for this cohort only, get a discount PLUS our premium job board software PLUS our live AI workshops on how to analyze data
Learn more here: https://datacareerjumpstart.com/daa
https://datacareerjumpstart.com/daa
22 min
September 15 228: AI Ruined The Job Search. Here’s How To Fix It.
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
Former LinkedIn exec explains why mass applying with AI is getting you nowhere. I asked him what works instead.
🧑‍💼 See 60+ recruiters who are hiring data analysts right now 👉 https://findadatajob.com/recruiters
💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training
👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator
⌚ TIMESTAMPS
00:00 – The AI arms race
04:33 – What are we solving for?
10:57 – Referrals were 10x in 2016
21:12 – Anyone can refer anyone
22:18 – Elevator pitch or questions?
36:36 – Is AI useless in the job search?
42:24 – Quality beats volume
🔗 CONNECT WITH JEREMY
🤝 LinkedIn: https://www.linkedin.com/in/schifeling/
📚 Check out Jeremy's books 👉 https://www.amazon.com/stores/author/B00AB7IEX2
🔗 CONNECT WITH AVERY
🎥 YouTube Channel
🤝 LinkedIn
📸 Instagram
🎵 TikTok
💻 Website
Mentioned in this episode:
October Cohort of The Accelerator Starts on October 12th
Land your first data job ASAP with The Accelerator. And for this cohort only, get a discount PLUS our premium job board software PLUS our live AI workshops on how to analyze data
Learn more here: https://datacareerjumpstart.com/daa
https://datacareerjumpstart.com/daa
Live "How to Become a Data Analyst" Webinar
Come learn the EXACT roadmap to landing your first data job: https://web.datacareerjumpstart.com/webinar
48 min
September 08 227: This Music Teacher Became a Data Analyst in 6 Weeks
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
Mason went from teaching middle school choir to a financial analyst job at Humana in 40 days. I asked him how.
💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training
👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator
⌚ TIMESTAMPS
00:00 – Choir teacher to Humana
09:03 – Teaching stopped working
12:33 – Go meet people
16:12 – Apply before you feel ready
20:06 – Fake it a little
24:30 – Get a referral
🔗 CONNECT WITH MASON
🤝 LinkedIn: https://www.linkedin.com/in/mason-rice-a98559330/
🎵 Follow his new choir, Voices of Kentuckiana 👉 https://www.instagram.com/voicesky/
🔗 CONNECT WITH AVERY
🎥 YouTube Channel
🤝 LinkedIn
📸 Instagram
🎵 TikTok
💻 Website
Mentioned in this episode:
October Cohort of The Accelerator Starts on October 12th
Land your first data job ASAP with The Accelerator. And for this cohort only, get a discount PLUS our premium job board software PLUS our live AI workshops on how to analyze data
Learn more here: https://datacareerjumpstart.com/daa
https://datacareerjumpstart.com/daa
Live "How to Become a Data Analyst" Webinar
Come learn the EXACT roadmap to landing your first data job: https://web.datacareerjumpstart.com/webinar
51 min
September 01 226: 10 Things I Wish I Knew When Starting as a Data Analyst
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
These are the 10 things I wish I knew when I was starting out in data analytics.
💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training
👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator
⌚ TIMESTAMPS
00:00 – The title trap
01:00 – Lowest hanging fruit
02:09 – Domain is your superpower
03:15 – Stakeholders come first
04:18 – Why SQL wins
05:27 – Build it before you need it
07:06 – Getting paid to learn
08:24 – Nobody analyzes alone
09:33 – The remote reality check
12:18 – Imposter syndrome is normal
🔗 CONNECT WITH AVERY
🎥 YouTube Channel
🤝 LinkedIn
📸 Instagram
🎵 TikTok
💻 Website
Mentioned in this episode:
Live "How to Become a Data Analyst" Webinar
Come learn the EXACT roadmap to landing your first data job: https://web.datacareerjumpstart.com/webinar
October Cohort of The Accelerator Starts on October 12th
Land your first data job ASAP with The Accelerator. And for this cohort only, get a discount PLUS our premium job board software PLUS our live AI workshops on how to analyze data
Learn more here: https://datacareerjumpstart.com/daa
https://datacareerjumpstart.com/daa
16 min
August 25 225: Why This Data Analyst Got 0 Interviews (According to a Recruiter)
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
Real recruiter spends 20 seconds on this resume and finds nothing worth keeping. I show you why.
📄 Grab my free resume template 👉 https://datacareerjumpstart.com/resume
💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training
👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator
📺 Original resume review by Headless Headhunter 👉 https://youtu.be/iLjHV8VPzK8
🎥 His Youtube Channel 👉 https://www.youtube.com/channel/UCPrukg_kzZHzVpvxc424S6A
⌚ TIMESTAMPS
00:00 – Eight months, zero interviews
08:45 – Make it scannable
09:45 – The formatting problem
12:09 – Your resume has two jobs
16:12 – How fast they give up
20:18 – Hiring managers aren't clueless
🔗 CONNECT WITH AVERY
🎥 YouTube Channel
🤝 LinkedIn
📸 Instagram
🎵 TikTok
💻 Website
Mentioned in this episode:
Live "How to Become a Data Analyst" Webinar
Come learn the EXACT roadmap to landing your first data job: https://web.datacareerjumpstart.com/webinar
October Cohort of The Accelerator Starts on October 12th
Land your first data job ASAP with The Accelerator. And for this cohort only, get a discount PLUS our premium job board software PLUS our live AI workshops on how to analyze data
Learn more here: https://datacareerjumpstart.com/daa
https://datacareerjumpstart.com/daa
28 min
August 18 224: This Recruiter Became a Data Analyst DESPITE No Experience
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
🎓 Want the FREE training Jorge watched before joining? 👉 https://datacareerjumpstart.com/training
Jorge was getting 12 rejections a day. I found out what he changed to turn it around.
💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training
👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator
⌚ TIMESTAMPS
00:00 – Call centers to AI team
05:36 – Why he quit the Google cert
12:39 – The internal pivot
15:45 – 12 rejections a day
20:51 – Applied for a different job
25:30 – Networking on LinkedIn
🔗 CONNECT WITH JORGE
🤝 LinkedIn: https://www.linkedin.com/in/jorge-lopezvelarde/
🔗 CONNECT WITH AVERY
🎥 YouTube Channel
🤝 LinkedIn
📸 Instagram
🎵 TikTok
💻 Website
Mentioned in this episode:
October Cohort of The Accelerator Starts on October 12th
Land your first data job ASAP with The Accelerator. And for this cohort only, get a discount PLUS our premium job board software PLUS our live AI workshops on how to analyze data
Learn more here: https://datacareerjumpstart.com/daa
https://datacareerjumpstart.com/daa
Live "How to Become a Data Analyst" Webinar
Come learn the EXACT roadmap to landing your first data job: https://web.datacareerjumpstart.com/webinar
36 min
August 11 223: The Data Analyst Role is Changing. Here’s My Advice To Beginners.
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
There's a lot of advice online on breaking into data. Here's what I'd tell a beginner.
💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter
🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training
👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa
👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator
⌚ TIMESTAMPS
00:00 – The Reddit post
01:09 – Companies interested in you
04:12 – Analysis is about money
07:00 – Bad tool advice
09:42 – My advice
🔗 CONNECT WITH AVERY
🎥 YouTube Channel
🤝 LinkedIn
📸 Instagram
🎵 TikTok
💻 Website
Mentioned in this episode:
October Cohort of The Accelerator Starts on October 12th
Land your first data job ASAP with The Accelerator. And for this cohort only, get a discount PLUS our premium job board software PLUS our live AI workshops on how to analyze data
Learn more here: https://datacareerjumpstart.com/daa
https://datacareerjumpstart.com/daa
Live "How to Become a Data Analyst" Webinar
Come learn the EXACT roadmap to landing your first data job: https://web.datacareerjumpstart.com/webinar
14 min