How she doubled her salary in a year as a data analyst, SQL in the real world, is job hopping bad? - Jess Ramos - The Data Scientist Show #076
Jan 5, 2024
auto_awesome
Jess Ramos, Senior Data Analyst at Crunchbase, discusses topics such as job hopping, SQL in the real world, data analyst vs data scientist, salary negotiation, and the future of data analytics. She shares her experience with job hopping, her day-to-day work as a data analyst, and how to talk data to stakeholders. Jess also discusses the importance of salary negotiation and the impact of LinkedIn on her career. The podcast concludes with a discussion about the future of data analytics and the speaker's online presence and courses.
Leaving a job for lack of growth opportunities, outdated technology, and cultural mismatch is a valid decision.
Being labeled as a job hopper shouldn't deter one from making the best decision for personal and company growth.
Crafting a compelling story for job interviews involves seeking feedback, highlighting adaptability, and explaining weaknesses effectively.
Deep dives
Transitioning from a job with limited career growth
Jess Ramos explains why she decided to leave her previous job as a senior risk analyst at Freddie Mac after just four months. She cites several reasons, including a lack of career growth opportunities, outdated technology, and a corporate culture that didn't align with her preferences for a more startup-like environment.
Overcoming the fear of being labeled a job hopper
Jess Ramos shares her experience of leaving a job after a short time and addresses the fear of being labeled as a job hopper. She highlights that it's important to make the best decision for oneself and the company, and a good recruiter and hiring manager will understand and appreciate when a candidate is not in a good fit.
Crafting an effective story for interviews
Jess Ramos offers advice on crafting a compelling story for job interviews. She suggests running the story by mentors or friends to receive feedback, and emphasizes the importance of explaining weaknesses or previous job changes in a way that highlights flexibility and adaptability.
The day-to-day work of a data analyst
Jess Ramos discusses her day-to-day tasks as a data analyst, including working with SQL, creating views, analyzing data, and collaborating with stakeholders. She also highlights the importance of understanding the business context and aligning metrics and data to business goals.
Challenges in writing complex SQL queries in the real world
Jess Ramos explains that writing SQL queries in the real world involves considerations such as optimization, understanding the data model, and relating the data to the business context. She highlights the importance of optimizing queries for efficient execution and understanding the relationships between tables in the data model.
Jess Ramos is a Senior Data Analyst at Crunchbase, a LinkedIn Learning Instructor, and a content creator in the data space. She has a bachelor's degree in Math, Spanish, and Business from Berry University and a master's in Business Analytics from University of Georgia. Today we’ll talk about SQL in the real world, data analyst vs data scientist, is job hopping bad, how she negotiated her salary. Subscribe to Daliana's newsletter on www.dalianaliu.com for more on data science and career.
Jess’ Linkedin: https://www.linkedin.com/in/jessramosmsba/
Preparing to Get a Job in Data Analytics: shorturl.at/sCNPT
Solve Real-World Data Problems with SQL: https://bit.ly/3Zq6wnd
Big Data Energy Newsletter: https://bit.ly/46x4rIR
Daliana's Twitter: https://twitter.com/DalianaLiu
Daliana’s LinkedIn: https://www.linkedin.com/in/dalianaliu/
(00:00:00) Introduction
(00:01:24) Why Jess left her job at Freddie Mac
(00:03:25) Is job hopping bad
(00:04:42) How to explain short job stints when interviewing
(00:06:49) Jess's day-to-day work and tech stack
(00:09:15) SQL in the real world
(00:12:10) How to talk data to stakeholders
(00:18:33) How Jess prepares for SQL interviews
(00:28:11) Data analysts vs data scientists
(00:32:11) Choosing a career path
(00:47:19) How to ask recruiter questions
(00:50:15) Jess's LinkedIn content creation journey
(00:59:03) The future of Jess's career
(01:03:42) Jess's favorite books
Get the Snipd podcast app
Unlock the knowledge in podcasts with the podcast player of the future.
AI-powered podcast player
Listen to all your favourite podcasts with AI-powered features
Discover highlights
Listen to the best highlights from the podcasts you love and dive into the full episode
Save any moment
Hear something you like? Tap your headphones to save it with AI-generated key takeaways
Share & Export
Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more
AI-powered podcast player
Listen to all your favourite podcasts with AI-powered features
Discover highlights
Listen to the best highlights from the podcasts you love and dive into the full episode