Data Analyst Resume Tips

let's be honest writing a resume is the worst and writing a perfect resume is one of the hardest parts of a job search you sit there crafting on a sheet of paper all your skills and qualifications and click submit only to never hear back and wondering what went wrong was it the one page was it the header you don't know and yet you submit five resumes a day and never get any results today I'll be talking about how to write the perfect resume for an entry-level data analyst with no prior data experience and to do that I'll be going over three key points and throughout this video I'll be sharing common data analyst resume mistakes the first is format for a data analyst with no prior data work the resume should really be one page you can increase the margins decrease the font but you really want to get all your work listed on one document because a recruiter spends about 6 seconds looking at your resume that means you want to be very strategic about how you're listing your information and what information to include this is my first resume when I was working at a consulting company now imagine you're a recruiter going through hundreds of resumes and you only look at this resume for 6 seconds what do you see you start at the top you see my name my contact information education and then what you just move on to the next one because you didn't see anything that was relevant immediately now here's a second resume and you start with contact information and then skills okay you see SQL so then you keep reading because it has the skills that you're looking for so the lesson here is that you want to be strategic about the order of information that you're listing and also you want to keep the format really Simple and Clean to read for an experienced Tire you would want to see the work experience listed immediately after the contact information but for an entry level data analyst or someone trying to transition into the role you want to highlight the data analytic skills first and then move on to the work experience now with that in mind this is the order that your resume should follow the first is your contact information this includes your location email your LinkedIn profile and a data portfolio link now for the data portfolio for an experienced hire I would say it's not as important because you have the work experience on hand but for someone transitioning into a data analyst role the data portfolio link will be really helpful there to showcase your data analysis skills under the skills you want to highlight your data analyst skills and this really depends on what type of job role that you're applying for most likely they are going to require Excel SQL and a BI visualization tool such as Tableau or Power BI and then you'll see Python listed depending on the job role that you are applying for now Project work and then work experience if you don't have data related experience the project work is going to take up the bulk of your resume you want to make sure that that is really where you're showing that you have the data analysis skills and you want to include them in chronological order and I'll include more details of what we want to include in here in points 2 and 3 the next is education and this is where you'll want to include any certificates as well as any degrees you have and then lastly we have interest now the interest section is debatable if you are an experienced hire you don't really need an interest section but for someone who doesn't have as much data experience or is transitioning into the role this is a great opportunity to make yourself stand out now you don't want to include all your interest here you want to pick and choose the ones that are more relevant to the role that you're applying for and also showcases your skills so for example the interest of learning a new language is a great one because it shows that you like learning and you like critical thinking now there are three common mistakes you'll see in resumes the first is grammatical errors typos misspellings and according to cultivated culture 60% of resumes have some sort of grammatical error and this may be really small but when I was looking at my older resume I could see at the bottom that I was spelling Google AdWords with a lowercase w when really it's uppercase and it's not a huge red flag but any small thing that the recruiter can point out to and notices is a reason for them to reject your resume so you really want to make sure you get your resume checked by three different peers whether it's the software that you're using like Microsoft Word that does spelling checks whether it's a friend someone professional definitely have your resume looked over because it is common for it to have errors the second mistake is having an unprofessional email address motley fool says that 35% of resumes use unprofessional email addresses and they even point to [email protected] which I thought was really funny but it's clearly unprofessional and portrays an image that you don't want on a resume so steer on the safe side and just use your first and last name at gmail.com or whatever email you use and keep it very professional now the third mistake is using a photo on the resume and this one is debatable because depending on the industry you're in a photo is actually very acceptable but for the traditional data analyst role I personally would not use a photo because I feel that that space could be used more effectively you want to make sure you're including your qualifications or your skill sets and highlight those things rather than an image so my take is to not include a photo now if you want a copy of this data analyst resume that I am reviewing in this video you're welcome to it I am providing a free copy in the description below I will note that this is specific to a data analyst with no prior data experience if you were a little more experienced I'd probably go with a different format but we can go over that in another video but for now please use the link below to download the second is keywords hiring managers use a system called ATS applicant tracking system and what it does is it filters the hundreds of resumes they receive and filter filters them based on certain keywords as well as ranking them and organizes the applicants for the hiring manager to view what does this mean for you the ATS system filters candidates based off of keywords so you want to make sure that you have the keywords from the job description in your resume so that you pass the ATS system as well as being ranked higher now how do you do this well here's a tip so what you want to use is a free word cloud generator and I'll include a description in the below and walk you through an example here's a job listing I found and what you'll want to do is copy the qualifications responsibilities job description and paste it into the free word cloud generator this will then populate the most relevant keywords you'll want to add to your resume such as data critical thinking best practice and good communication now take these keywords and use them on your resume one of the best ways you can ensure that you pass the ATS system is by using these keywords in your resume and I know it sounds like a lot of work to do this for each job that you're applying for but if you want to stand out in the hundreds of resumes this is a great way to do it the next is impact when looking at hundreds of resumes and they all say analyze sales data in SQL they all start to look the same and none of them stand out but when you get a candidate quantifying their impact with analyzed a thousand rows of sales data in SQL leading to an increased processing time of 10% this stands out because the interviewer can measure the success of the candidate and it's not necessarily the number of rows the candidate analyzed or how big of an impact he made it's the fact that he's able to quantify it that makes the difference to the recruiter and you may be thinking now as a data analyst with no data work experience how am I going to quantify the impact of my work well this is where chatGPT comes in handy here are two use cases that I found the first is if you're trying to think of ideas how you can write bullet points for your resume coming from a different industry you can use a prompt can you write effective resume bullet points for a cleaning assistant applying for a data analyst job quantifying impact and then chatGPT will give you a list of examples of how you can quantify your work and obviously it doesn't know what the impact of your work truly was but it does give you ideas of different ways you can try measuring and quantifying the impact on your resume now for projects you may be thinking how do I quantify impact there's another prompt you can use with chatGPT which is can you give me an example of how I can quantify impact for data analyst personal projects without a user for data analyst jobs and it will list the different types of ways you can quantify your impact for example include processing time improvements such as percentages or reduced errors there are several ideas here that you can use for your projects the impact is really where you're going to stand out in your resume and you want to make sure that you're quantifying it rather than simply stating it writing a resume is not easy but when used correctly it will get you a data analyst job my recommendation is if you're struggling to find content to put into your resume don't worry so much about writing it but really building your resume you want to make sure you go and have enough projects maybe volunteer and see if you can actually have a user use it to quantify your impacts and build a resume that will actually get you the data analyst role now if you enjoyed this video please like and subscribe and I'd love to hear in the comments which of these resume tips were helpful for you thanks and I will see you on the next video

let's be honest writing a resume is the worst and writing a perfect resume is one of the hardest parts of a job search you sit there crafting on a sheet of paper all your skills and qualifications and click submit only to never hear back and wondering what went wrong was it the one page was it the header you don't know and yet you submit five resumes a day and never get any results today I'll be talking about how to write the perfect resume for an entry-level data analyst with no prior data experience and to do that I'll be going over three key points and throughout this video I'll be sharing common data analyst resume mistakes the first is format for a data analyst with no prior data work the resume should really be one page you can increase the margins decrease the font but you really want to get all your work listed on one document because a recruiter spends about 6 seconds looking at your resume that means you want to be very strategic about how you're listing your information and what information to include this is my first resume when I was working at a consulting company now imagine you're a recruiter going through hundreds of resumes and you only look at this resume for 6 seconds what do you see you start at the top you see my name my contact information education and then what you just move on to the next one because you didn't see anything that was relevant immediately now here's a second resume and you start with contact information and then skills okay you see SQL so then you keep reading because it has the skills that you're looking for so the lesson here is that you want to be strategic about the order of information that you're listing and also you want to keep the format really Simple and Clean to read for an experienced Tire you would want to see the work experience listed immediately after the contact information but for an entry level data analyst or someone trying to transition into the role you want to highlight the data analytic skills first and then move on to the work experience now with that in mind this is the order that your resume should follow the first is your contact information this includes your location email your LinkedIn profile and a data portfolio link now for the data portfolio for an experienced hire I would say it's not as important because you have the work experience on hand but for someone transitioning into a data analyst role the data portfolio link will be really helpful there to showcase your data analysis skills under the skills you want to highlight your data analyst skills and this really depends on what type of job role that you're applying for most likely they are going to require Excel SQL and a BI visualization tool such as Tableau or Power BI and then you'll see Python listed depending on the job role that you are applying for now Project work and then work experience if you don't have data related experience the project work is going to take up the bulk of your resume you want to make sure that that is really where you're showing that you have the data analysis skills and you want to include them in chronological order and I'll include more details of what we want to include in here in points 2 and 3 the next is education and this is where you'll want to include any certificates as well as any degrees you have and then lastly we have interest now the interest section is debatable if you are an experienced hire you don't really need an interest section but for someone who doesn't have as much data experience or is transitioning into the role this is a great opportunity to make yourself stand out now you don't want to include all your interest here you want to pick and choose the ones that are more relevant to the role that you're applying for and also showcases your skills so for example the interest of learning a new language is a great one because it shows that you like learning and you like critical thinking now there are three common mistakes you'll see in resumes the first is grammatical errors typos misspellings and according to cultivated culture 60% of resumes have some sort of grammatical error and this may be really small but when I was looking at my older resume I could see at the bottom that I was spelling Google AdWords with a lowercase w when really it's uppercase and it's not a huge red flag but any small thing that the recruiter can point out to and notices is a reason for them to reject your resume so you really want to make sure you get your resume checked by three different peers whether it's the software that you're using like Microsoft Word that does spelling checks whether it's a friend someone professional definitely have your resume looked over because it is common for it to have errors the second mistake is having an unprofessional email address motley fool says that 35% of resumes use unprofessional email addresses and they even point to beerpongmaster@gmail.com which I thought was really funny but it's clearly unprofessional and portrays an image that you don't want on a resume so steer on the safe side and just use your first and last name at gmail.com or whatever email you use and keep it very professional now the third mistake is using a photo on the resume and this one is debatable because depending on the industry you're in a photo is actually very acceptable but for the traditional data analyst role I personally would not use a photo because I feel that that space could be used more effectively you want to make sure you're including your qualifications or your skill sets and highlight those things rather than an image so my take is to not include a photo now if you want a copy of this data analyst resume that I am reviewing in this video you're welcome to it I am providing a free copy in the description below I will note that this is specific to a data analyst with no prior data experience if you were a little more experienced I'd probably go with a different format but we can go over that in another video but for now please use the link below to download the second is keywords hiring managers use a system called ATS applicant tracking system and what it does is it filters the hundreds of resumes they receive and filter filters them based on certain keywords as well as ranking them and organizes the applicants for the hiring manager to view what does this mean for you the ATS system filters candidates based off of keywords so you want to make sure that you have the keywords from the job description in your resume so that you pass the ATS system as well as being ranked higher now how do you do this well here's a tip so what you want to use is a free word cloud generator and I'll include a description in the below and walk you through an example here's a job listing I found and what you'll want to do is copy the qualifications responsibilities job description and paste it into the free word cloud generator this will then populate the most relevant keywords you'll want to add to your resume such as data critical thinking best practice and good communication now take these keywords and use them on your resume one of the best ways you can ensure that you pass the ATS system is by using these keywords in your resume and I know it sounds like a lot of work to do this for each job that you're applying for but if you want to stand out in the hundreds of resumes this is a great way to do it the next is impact when looking at hundreds of resumes and they all say analyze sales data in SQL they all start to look the same and none of them stand out but when you get a candidate quantifying their impact with analyzed a thousand rows of sales data in SQL leading to an increased processing time of 10% this stands out because the interviewer can measure the success of the candidate and it's not necessarily the number of rows the candidate analyzed or how big of an impact he made it's the fact that he's able to quantify it that makes the difference to the recruiter and you may be thinking now as a data analyst with no data work experience how am I going to quantify the impact of my work well this is where chatGPT comes in handy here are two use cases that I found the first is if you're trying to think of ideas how you can write bullet points for your resume coming from a different industry you can use a prompt can you write effective resume bullet points for a cleaning assistant applying for a data analyst job quantifying impact and then chatGPT will give you a list of examples of how you can quantify your work and obviously it doesn't know what the impact of your work truly was but it does give you ideas of different ways you can try measuring and quantifying the impact on your resume now for projects you may be thinking how do I quantify impact there's another prompt you can use with chatGPT which is can you give me an example of how I can quantify impact for data analyst personal projects without a user for data analyst jobs and it will list the different types of ways you can quantify your impact for example include processing time improvements such as percentages or reduced errors there are several ideas here that you can use for your projects the impact is really where you're going to stand out in your resume and you want to make sure that you're quantifying it rather than simply stating it writing a resume is not easy but when used correctly it will get you a data analyst job my recommendation is if you're struggling to find content to put into your resume don't worry so much about writing it but really building your resume you want to make sure you go and have enough projects maybe volunteer and see if you can actually have a user use it to quantify your impacts and build a resume that will actually get you the data analyst role now if you enjoyed this video please like and subscribe and I'd love to hear in the comments which of these resume tips were helpful for you thanks and I will see you on the next video

Transcript for:Data Analyst Resume Tips

Transcript for:
Data Analyst Resume Tips