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

Avery Smith - Data Career Coach
  • 4.9 (155)
  • CAREERS
  • UPDATED BIWEEKLY
Data Career Podcast: Helping You Land a Data Analyst Job FAST

The Data Career Podcast: helping you break into data analytics, build your data career, and develop a personal brand

  1. 164: I built an entire data pipeline in 30 minutes using only AI (no code required)

    2D AGO

    164: I built an entire data pipeline in 30 minutes using only AI (no code required)

    Try Keboola 👉 https://www.keboola.com/mcp?utm_campaign=FY25_Q2_RoW_Marketing_Events_Webinar_Keboola_MCP_Server_Launch_June&utm_source=Youtube&utm_medium=Avery Today, we'll create an entire data pipeline from scratch without writing a single line of code! Using Keboola MCP server and ClaudeAI, we’ll extract data from my FindADataJob.com RSS feed, transform it, load it into Google BigQuery, and visualize it with Streamlit. This is the future of data engineering! Keboola MCP Integration: https://mcp.connection.us-east4.gcp.keboola.com/sse I Analyzed Data Analyst Jobs to Find Out What Skills You ACTUALLY Need https://www.youtube.com/watch?v=lo3VU1srV1E&t=212s 💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter 🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training 👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa 👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator ⌚ TIMESTAMPS 00:00 - Introduction 00:54 - Definition of Basic Data Engineering Terms 02:26 - Keboola MCP and Its Capabilities 07:48 - Extracting Data from RSS Feed 12:43 - Transforming and Cleaning the Data 19:19 - Aggregating and Analyzing Data 23:19 - Scheduling and Automating the Pipeline 25:04 - Visualizing Data with Streamlit 🔗 CONNECT WITH AVERY 🎥 YouTube Channel: https://www.youtube.com/@averysmith 🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/ 📸 Instagram: https://instagram.com/datacareerjumpstart 🎵 TikTok: https://www.tiktok.com/@verydata 💻 Website: https://www.datacareerjumpstart.com/ Mentioned in this episode: 🌞 Summer Cohort of DAA Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class! https://www.datacareerjumpstart.com/daa 💙 Thank you for subscribing & leaving a review Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

    33 min
  2. 163: How to Analyze Data in the New Era of AI

    JUN 3

    163: How to Analyze Data in the New Era of AI

    Try Julius.ai 👉 https://bit.ly/4jn4cFF Coupon code: AVERY25 AI is transforming how we work, how we make decisions, and how we understand the world through data. In this episode, I explore how Julius AI can simplify your data tasks, automate repetitive work, and offer valuable insights in MINUTES. Dive into the future of data analysis and get ready to 10x your productivity! Get my weekly newsletters (free): https://www.datacareerjumpstart.com/newsletter Learn more about my CRM Course Creator 360: https://coursecreatorpro.com/registeremailaffiliate?am_id=avery8756 How This Delivery Driver Became a FAANG Data Analyst (Jen Hawkins) https://youtu.be/f-BWp_IJZ-I?si=2_tKqHEng_EYNRCB 💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter 🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training 👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa 👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator ⌚ TIMESTAMPS 00:00 - Introduction 01:55 - My CRM Data Analysis 02:23 Exploring and Cleaning Data with Julius AI 06:15 Email Analysis and Insights 13:39 Sales Cycle Length Analysis 15:27 The Power of AI in Data Analysis 🔗 CONNECT WITH MY TOP NEWSLETTER ENGAGERS! Isaac Oresanya: https://www.linkedin.com/in/isaac-oresanya/ Jen Hawkins: https://www.linkedin.com/in/jeandriska/ David Mills: https://www.linkedin.com/in/david-mills/ Mukta Pandey: https://www.linkedin.com/in/mukta-pandey-30a89b243/ 🔗 CONNECT WITH AVERY 🎥 YouTube Channel: https://www.youtube.com/@averysmith 🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/ 📸 Instagram: https://instagram.com/datacareerjumpstart 🎵 TikTok: https://www.tiktok.com/@verydata 💻 Website: https://www.datacareerjumpstart.com/ Mentioned in this episode: 🌞 Summer Cohort of DAA Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class! https://www.datacareerjumpstart.com/daa 📰 Join 18k Other Analysts in My Newsletter Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe 💌 Subscribe To My Newsletter

    19 min
  3. 162: This Loan Officer Became a Data Analyst WITHOUT a Degree (Ryan Ponder)

    MAY 27

    162: This Loan Officer Became a Data Analyst WITHOUT a Degree (Ryan Ponder)

    Break into data analytics EVEN without a degree, just like our guest for today's episode! He's Ryan Ponder, a Data Analytics Accelerator program student who transitioned from Loan Officer to Data Analyst within his company-- without a degree. He shares how he leveraged internal opportunities and attained his new role. Tune in and learn actionable steps for making an internal pivot and overcoming career challenges! 💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter 🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training 👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa 👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator ⌚ TIMESTAMPS 00:00 - Introduction 05:49 - The Internal Pivot: A Unique Pathway to Data Analytics 09:57 - Networking and Overcoming Challenges 15:47 - Imposter Syndrome 23:02 - Final Thoughts and Advice 🔗 CONNECT WITH RYAN 🤝 LinkedIn: https://www.linkedin.com/in/rtponder/ 🔗 CONNECT WITH AVERY 🎥 YouTube Channel: https://www.youtube.com/@averysmith 🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/ 📸 Instagram: https://instagram.com/datacareerjumpstart 🎵 TikTok: https://www.tiktok.com/@verydata 💻 Website: https://www.datacareerjumpstart.com/ Mentioned in this episode: 🌞 Summer Cohort of DAA Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class! https://www.datacareerjumpstart.com/daa 💙 Thank you for subscribing & leaving a review Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

    26 min
  4. 161: Entry Level Data Jobs That Are ACTUALLY Entry Level

    MAY 20

    161: Entry Level Data Jobs That Are ACTUALLY Entry Level

    Struggling to break into data analyst roles because you have no experience? In this episode, I reveal 6 overlooked, easier-to-land entry-level data jobs that can kickstart your data career. I also provide 7 reasons why these roles are worth considering! 💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter 🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training 👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa 👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator ⌚ TIMESTAMPS 00:00 - Introduction 01:43 - Six overlooked data jobs 02:09 - Reason 1: Domain-focused 03:18 - Reason 2: Easier to qualify for 04:26 - Reason 3: Less competition 05:34 - Reason 4: Still provide real data experience 06:42 - Reason 5: Often remote or hybrid 07:49 - Reason 6: Internal pivot 09:03 - Reason 7: Decent pay 🔗 CONNECT WITH AVERY 🎥 YouTube Channel: https://www.youtube.com/@averysmith 🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/ 📸 Instagram: https://instagram.com/datacareerjumpstart 🎵 TikTok: https://www.tiktok.com/@verydata 💻 Website: https://www.datacareerjumpstart.com/ Mentioned in this episode: 💙 Thank you for subscribing & leaving a review Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support. 🌞 Summer Cohort of DAA Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class! https://www.datacareerjumpstart.com/daa

    13 min
  5. 160: She Became a Data Analyst AFTER a 20-Year Career in Physical Therapy (Melody Santos)

    MAY 13

    160: She Became a Data Analyst AFTER a 20-Year Career in Physical Therapy (Melody Santos)

    Melody Santos has successfully transitioned from a physical therapist to a revenue analyst in a few months! In this episode, she shares three main steps that expedited her journey, her struggles with imposter syndrome, and offers valuable advice for anyone looking to pivot into a data career. 💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter 🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training 👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa 👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator ⌚ TIMESTAMPS 00:00 - Introduction 04:16 - Melody's Google Data Analytics Certificate Experience 06:41 - Job Application Challenges 15:43 - Landing the Charge Integrity Analyst Job 23:16 - Advice for Career Changers 🔗 CONNECT WITH MELODY 🤝 LinkedIn: https://www.linkedin.com/in/melodyusantos/ 🔗 CONNECT WITH AVERY 🎥 YouTube Channel: https://www.youtube.com/@averysmith 🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/ 📸 Instagram: https://instagram.com/datacareerjumpstart 🎵 TikTok: https://www.tiktok.com/@verydata 💻 Website: https://www.datacareerjumpstart.com/ Mentioned in this episode: 🌞 Summer Cohort of DAA Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class! https://www.datacareerjumpstart.com/daa 💙 Thank you for subscribing & leaving a review Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

    27 min
  6. 159: Is The Google Data Analytics Certificate ACTUALLY Worth It? (FULL REVIEW)

    MAY 6

    159: Is The Google Data Analytics Certificate ACTUALLY Worth It? (FULL REVIEW)

    If you're thinking about doing the Google Data Analytics Certificate, you need to hear this: DON'T. In this episode, I list five reasons why it is a waste of time. The ONLY Framework to Become a Data Analyst in 2025 (SPN Method): https://youtu.be/XUxWQgh3soo?si=v3SQV3zJ4h0jH1uQ 💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter 🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training 👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa 👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator ⌚ TIMESTAMPS 00:00 - Introduction 00:11 - Reason 1: Certificates Don't Matter in the Data Industry 02:45 - Reason 2: The Course Teaches the Wrong Skills 06:32 - Reason 3: The Course is Slow and Theoretical 09:21 - Reason 4: Lack of Projects and Portfolios 14:15 - Reason 5: No Career or Networking Support 🔗 CONNECT WITH AVERY 🎥 YouTube Channel: https://www.youtube.com/@averysmith 🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/ 📸 Instagram: https://instagram.com/datacareerjumpstart 🎵 TikTok: https://www.tiktok.com/@verydata 💻 Website: https://www.datacareerjumpstart.com/ Mentioned in this episode: 💙 Thank you for subscribing & leaving a review Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support. 🌞 Summer Cohort of DAA Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class! https://www.datacareerjumpstart.com/daa

    21 min
  7. 158: I Analyzed 2,893 Data Analyst Job Postings to Find Out What Skills You ACTUALLY Need to Get Hired

    APR 29

    158: I Analyzed 2,893 Data Analyst Job Postings to Find Out What Skills You ACTUALLY Need to Get Hired

    🎯 I analyzed 2,893 data analyst job postings so you don’t have to, and here’s what I found: **You might be wasting your time learning the wrong skills.** Find out how to pivot your career the data-driven way and stay ahead of the game. 💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter 🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training 👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa 👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator ⌚ TIMESTAMPS 02:28 - FindADataJob.com. 04:04 - Most In-demand skills in 2025. 06:22 - Live Data at DataAnalystSkills.com 🔗 CONNECT WITH AVERY 🎥 YouTube Channel: https://www.youtube.com/@averysmith 🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/ 📸 Instagram: https://instagram.com/datacareerjumpstart 🎵 TikTok: https://www.tiktok.com/@verydata 💻 Website: https://www.datacareerjumpstart.com/ Mentioned in this episode: 💙 Thank you for subscribing & leaving a review Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support. 🌞 Summer Cohort of DAA Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class! https://www.datacareerjumpstart.com/daa

    10 min
  8. 157: How She Became a Data Analyst Through Blogging (Megan Bowers)

    APR 22

    157: How She Became a Data Analyst Through Blogging (Megan Bowers)

    Megan Bowers took an unconventional path to break into the data world. Starting from a self-guided Data Science Bootcamp, she shared her journey through blogging and gained millions of views, and then BOOM! Job offers and monetization opportunities flooded. This is her story. 📌 Interested in blogging for my publication? Get on this interest list: https://tally.so/r/3l4xQW 💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter 🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training 👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa 👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com/interviewsimulator ⌚ TIMESTAMPS 00:00 - Introduction 03:28 - Gaining traction and recognition through blogging. 07:08 - Career Growth and transition to Alteryx. 14:18 -  Leveraging and advertising your domain expertise. 19:25 - What is a Data Journalist? 22:21 - Writing content. 24:29 - What is Alteryx? 🔗 CONNECT WITH MEGAN 🎥 YouTube Podcast Channel: https://www.youtube.com/playlist?list=PLfSLx4WE4q501UZjL3Hx-DiS4zyeePEN2 🤝 LinkedIn: https://www.linkedin.com/in/megandibble1/ 📸 Instagram: https://www.instagram.com/alteryx/ 💻 Alteryx Website: https://www.alteryx.com/ 🔗 CONNECT WITH AVERY 🎥 YouTube Channel: https://www.youtube.com/@averysmith 🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/ 📸 Instagram: https://instagram.com/datacareerjumpstart 🎵 TikTok: https://www.tiktok.com/@verydata 💻 Website: https://www.datacareerjumpstart.com/ Mentioned in this episode: 🌞 Summer Cohort of DAA Join the Summer Cohort of DAA and become an analyst by the end of summer! Be sure to check out our current deal to save BIG! See you in class! https://www.datacareerjumpstart.com/daa 💙 Thank you for subscribing & leaving a review Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

    31 min
See All (164)

4.9
out of 5
155 Ratings

About

The Data Career Podcast: helping you break into data analytics, build your data career, and develop a personal brand

Information

You Might Also Like

To listen to explicit episodes, sign in.

Stay up to date with this show

Sign in or sign up to follow shows, save episodes, and get the latest updates.
Select a country or region

Africa, Middle East, and India

Asia Pacific

Europe

Latin America and the Caribbean

The United States and Canada