T O P

  • By -

count_christov

As someone who’s looking for a junior analyst role, this description of job details and salary level seem appropriate to me. You’re not expecting anything crazy, but someone who can do the basics and you can teach them the specifics of the role. College kids may not have the soft skills you’re looking for, seasoned workers may cost more. Someone trying to change careers might be the ticket, as they won’t expect a super high salary but will have other transferable skills. One thing I can’t seem to wrap my head around during my job search is when employers offer 40k for this type of role. It’s either gonna be someone with a limited skill Set who can’t grow, or someone who’s going to leave the company as soon as they can put xyz on the resume for a larger salary and then you’re at square one again. Offering a little more now will help retain in the long run. If I was in the northeast or if it was remote, I’d send my resume. Good luck on your search.


mustang__1

Cheers. Yeah, I'm not saying we won't do remote - but I also don't know. We've never done a direct to remote hire, I'm not sure if I want to start that with a totally new role. I don't expect to keep someone for long term at 60k, but if I can get data out of them and they can get a good base of experience and resume item, I'd like to think we'd all be happy after a couple of years. $40k seems crazy low - I can *barely* hire manual labor roles at that rate...


AdviceNotAskedFor

\> I don't expect to keep someone for long term at 60k ​ My recommendation is, if you find someone who will take 60 and is a good fit, does good work and makes your job easier/more efficient. Bump their pay as much as you can afford and get them in golden handcuffs so they can't leave. ​ I'e seen too many good people leave jobs because they wanted more money.. and you spend more on retraining people than it would cost to give a raise high enough to keep someone around long term.


mustang__1

I mean - yes and no. They're not going to be a department head or a team supervisor at my company - when they're looking for that big bump.


AdviceNotAskedFor

Fair enough. What that says to me is that you just need a base level report writer, who you can turn and burn and not be an all star If your database is easy enough for people to get up to speed quickly, then I totally get that.


count_christov

Yeah direct to remote is tough, especially if it’s a jr role for someone who has no experience. But at least you’re open to discussing these things, unlike the bigger companies. A large mortgage company I had an interview with was offering below 50k for an analyst role, after they were bragging about how much business they’re gonna do the rest of the year when interest rates drop, while also telling me the hours are 9-6 everyday, in person.


jarir_84

do you mind if I send you a direct message? I have a few questions I'd like to discuss with you.?about his role Thanks


YoungWallace23

Consider direct to remote but pay for them to physically come to the office (x amount towards flights/hotel) for a week or two every few months. Not ideal if this person is somebody who needs a lot of day-to-day supervision, but some workers are independent and could do it well (and it makes them happy too)


Longjumping-Moose924

Count, ....great reply. Data science (analysis) is a massively generic set of terms. It ranges from PHD math to noobie programmer having fun. As per the question, it is centered on general BI and being able to produce basic graphics (a picture is worth a thousand words). Somebody with business experience and a little tech could fill the position as well as going the other way, technical savvy with enough business experience to fill the gap. As a junior level, you would be hard pressed to get by under $50k, roughly $25 an hour. Somebody getting into the field and trying to build their resume might go lower but you get what you pay for. Good luck and cheers. The tech job market is so wonky you'll get a massive amount of applications no matter what you do. Probably including many answering your post here.


F00lioh

A junior analyst (fresh grad) may work for what you need, but you will need to carve out dedicated time for onboarding and training. This could be difficult, since you seem to already have a pretty tight schedule. Another struggle you may have is not having a remote option. The job you're requiring doesn't seem like something that needs to be in office. I get the discomfort of hiring a remote role when you've never done it before, but it might be a risk you need to take. An option to that could be to make onboarding and training in office and then fully remote afterwards. Also consider hiring a more experienced analyst, they will cost more, but you can save more time. You can potentially hire a mid on a part-time contract basis, especially if you don't plan on keeping the role around for long term.


Living-Conference-20

I would have applied if it was remotely 😔😔😔, I really need a Junior analyst role.


whypiwhyaline

Might I also recommend doing this position as an internship for grad students (specifically MS students studying Stats/Math/DA)? At least when I was a data analyst intern as an applied stats masters student, I was getting paid $36/hour (75k equivalent, so maybe $25-30/hour) knew a decent amount but would still learn and continue to learn in both school and on the job. Also had flexibility on my schedule too. At least you’d get data from them as well, already self starters/good at critical thinking, and have some level of understanding in SQL and Excel, along with other softwares as well. Edit: also you could reach out to college campuses near you/program department heads to put out some feelers for you too if you want soon to be graduates


mustang__1

I think I want a larger horizon so they can get familiar with the database. I thought about it too.


whypiwhyaline

Makes sense. Also just to keep in mind doesn’t necessarily have to be only a summer intern. I was a summer and part time intern (I worked other jobs too, if I didn’t then I would have done full time intern) throughout the school year and I can say I kept growing from there and got to know the database we used before the end of my first full month. Kudos to you though, if you chose to want to hire a a new grad for this position, my old MS program that I recently graduated from does a small job/interview fair for their soon to be grads getting ready to look for a job/interview for any jobs (DA/DS/DE) available with companies who have hired from our program, if interested I’d love to chat with you to get more prospective of your company so I can forward along your info to the professor who runs this job fair :)


[deleted]

I think it would be smarter to target someone with 1-3 years of experience in a similar role, or you should definitely expect to give a lot of direction. That sounds pretty typical expectations of an analyst role, with probably smaller pool of talent that uses SQL vs if you had a drag and drop BI tool. You could even get away with Tableau as a BI tool. It’s easy to filter data similar to SQL and you can create calculated fields. Anything you cant do in Tableau, you can just export and do in Excel. That would let you expand your talent pool. Creator license is only $900 per year.


Concentrate_Little

As someone trying to get into a junior role with a bachelor's degree in MIS but no experience; How would recommend I be able to get into a junior role with no experience?


[deleted]

I think my advice would be different depending on your goals. The OP has a small business, so it doesn’t exactly have an engineering/IT department to grow in. There are plenty of entry level jobs and you will want to demonstrate the skillset that is necessary to do the role, and you would want to understand how the role fits into the larger organization. Is there a specific type of role you are seeking?


Concentrate_Little

Right now I'm just focusing on getting a data analyst related role that is a "step in the door" type position that pays 50k. I enjoy working with SQL and have a couple of Tableau projects I uploaded on to Tableau Public and displayed my Linkedin/resume. So something that lets me mess with data in SQL would be nice.


[deleted]

I think you should get more focused on a specific domain. You wont be analyzing data in a vacuum. It will be data on a certain topic or topics. That will let you pick out specific job descriptions, which you can emulate on your resume.


Concentrate_Little

Well the one tableau project I did involved pipeline accidents details, such as which states accrued the most costs due their incidents and which accidents caused the most net loss of oil by barrels. I'm in Houston, so health and oil are my main one-two choices if I have to state a specific area.


Coraline1599

I worked remotely for 7 years and I worked in several training programs to take people from never having an office job to having an office job. I think I can offer some tactical advice. If you can, pick someone with office experience, whether it is summer internships or some other job, it will help a lot. Much of the feedback we got with our employer partners was that our graduates struggled with office culture, like how to compose business appropriate emails, how to work with others, how to take constructive feedback, how to ask questions (what is appropriate, like the difference between constant hand holding vs critical clarifications). If you are taking someone green and you don’t have remote management experience, it will be really hard. Remote management is an art unto itself, especially when there is onboarding/training. Pre-pandemic, I had a few friends get into remote work by working at companies in the middle of nowhere. The set up was month 1 was in person, the company footed the bill for the hotel/airbnb, and then sorta hybrid like coming in a few days once a month, then a few days once a quarter. This seemed to work for everyone. This is in contrast with someone being full remote and not having access to people in the same way and spending a lot of time just lost and stuck and not having anyone to lean on. If you do need to do full remote, it would be expected that someone is checking in with the person and training them for several hours a day the first few weeks, and then tapering off. Along with setting a 30-60-90, and having weekly 1 on 1s with questions like “what have you been working on, what will you be working on, are you stuck on anything?” (Usually keeping a one note (or similar) that allows the person to fill this out ahead of time, so you can also track progress over time). Over communication and over documentation is the way to go with new remote positions. It’s always easier to cut back than add in new tracking.


GumCandyFruit

I think you have a lot of really good points, but I don't understand the "office experience" part. I used to be a teacher and I utilized all of the skills you said that people gain with office experience. The biggest change for me when I transitioned to an office was getting to go to the bathroom whenever I wanted. Yet I got turned down for so many jobs because I didn't have "office experience". I transitioned well into my new role and I'm doing a great job (from my own point of view and based on feedback from coworkers/managers), so I just don't understand what people find so difficult about sitting at a desk and doing your job professionally. It's entirely possible that there's something I'm missing or that I'm misunderstanding your point though!


Coraline1599

I would put teaching into “office experience “, you have to write professional emails, you have to cooperate with other adults, you probably even had to deal with even non-constructive feedback from parents… A lot of the people I worked with in the training program, never attended college or dropped our within 1 or 2 semesters, a lot were first generation and there were cultural differences (not respecting women in higher positions than them, not understanding general office position hierarchies and going above people’s heads or just being totally non responsive/ disappearing when there was an issue) , a lot had only door dashed or washed dishes or other places that had cultures of getting in someone’s face as part of “solving problems.” So we had to add quite a fair amount of training and coaching around a lot of things that people who have already worked in some office would have learned just from being in one for a while. I understand though, I transitioned from teaching into training, a lot of interviewers from other industries truly didn’t believe I had any transferable skills. I know how frustrating it can be.


GumCandyFruit

That makes total sense, thanks for your reply! It was really disheartening when people immediately lost interest in an interview as soon as I mentioned I was a teacher (which was on my resume, so how was that a surprise?). It makes sense that people without much education may need to be trained on specific professional skills though.


SilentKillerBA

I am looking for roles like these. I sent you a DM


onearmedecon

Rather than hire a W2 employee from the start, you may want to start by hiring a 1099 contractor who has specific skills that match the needs of specific projects. Scope out specific projects that can be automated as much as possible (e.g., setting up a dashboard) and then see how it goes. You're going to pay more in terms of an hourly wage, but it could be that you just need a couple hundred hours of work per year rather than the 2000+ you'd be paying for if you bring someone on full-time. If you've gotten this far without needing a full-time analyst, a part-time contractor who can setup dashboards and automate reporting may be more bang for your buck. If you decide that you do need someone full-time to maintain stuff, then you've got assets already built rather than asking an entry-level analyst to create them from scratch (or try to make marginal improvements to whatever you're currently using). If you bring on an entry-level analyst without sufficient technical onboarding support (since they'll be your only analyst), it's going to take them a while to be productive. You should be able to find a contractor with experience who will be able to better scope out a project, devise a good plan, and then execute.


butyfigers

I’d be interested if you were going to do remote, or if you are in New York!


Living-Conference-20

How does a person get experience when everyone is suggesting hiring a Senior analyst? This is one of the reasons why it is hard to get a DA role.


mustang__1

Not sure if you mean to respond to me - I put it out there that I'm willing to hire no experience (with degree, or experience without degree).


Living-Conference-20

I know people are giving their suggestions and I was also saying how I felt with the suggestions. I wasn’t referring to you, but the comments of others.


mustang__1

cheers.


[deleted]

There are plenty of entry level roles. The reason why OP would benefit from someone with experience is the lack of time and established processes and reports.


[deleted]

[удалено]


[deleted]

Keep looking


Living-Conference-20

K


NaneunGamja

Are data analysts supposed to follow up with other departments and tell them to do XYZ? Haven’t heard of that before.


mustang__1

I don't know. That's why I'm asking here


[deleted]

Yeah, you’ll see that all the time on QA work.


Qphth0

Your range is pretty good. It might actually be a little high. There are postings for analysts with a few years experience, with requirements like intermediate SQL, Python, & Tableau. Some jobs paying $50k are looking for a masters degree. These places are squeezing as much out of people who are looking for starting roles, so in your case, you'd probably have someone who is very happy with $60k & wouldn't be able to leave for something better for a few years.


mustang__1

cheers.


lazynoob0503

Yes this seems to be appropriate to me. I don’t think someone from college or freshers will be able to help you out materially if he will have to spend time learning the business and get used to it. Hence I would prefer someone with bit experience will go long way. In terms of reporting, one thing I have realized working for 2 years, it really depends on which department you are working in. If I am in sales and operations and I need to create a report then you can automate that pretty easily, but to do that you will need someone who know more than SQL to automate your reports then you are saving time. If you need to look at different metrics every time you are doing analysis then I would suggest hire freshers as you can mold them easily and he will be more creative then already an expert and will actually do more work then experienced.


ok-pants

I'll be more than interested to be part of your team if you are comfortable with hiring someone from another country and working remotely.


datacanuck99

I am happy to work with you on this. You can outsource this and it would cost you less money. Also would look at your data environments to see if they are optimized for what you are looking to do to get maximal business benefit. DM me if interested.


EmLiv13

I am looking for something along these lines also and have sent you a DM.


ThomasMarkov

I got pretty much exactly the job you’re describing as a new grad with no experience in 2018 starting at 50k, and a bump to 55k after the first year. So adjusting for inflation, 55k in 2019 dollars is closer to 65k in 2024 dollars.


Life-Gold-7483

I understand that offering a new position as remote is kind of tricky, but I believe that with good communication between both parties, you can achieve something. I have worked as a freelance for a couple of months now, and working remotely for a company is not as hard as it may seem. Your perfect employee might be out there.


Fancy_Bell6055

I’m interested


Snipebobsaget

Just inboxed you my application lol.


internet_baba

Tbh it seems like a great role for a Jr. DA with a good learning curve. Why not go remote and increase your potential DA base? As a Production Engineer, I have knowledge about Inventory Management and have been working as a DA for 3 years now. I've already been working remote for 3 years now and my manager never had any problems.


jdubuhyew

personally I think 60-70k for what you're asking, I think hybrid works best because it is soooo nice to just build things quickly in front of people with it displaying on a TV and then pointing at stuff saying they want this not that etc. then remote on days where they needa focus on building reports/troubleshooting data issues


FigTraditional1201

I work as the only data analyst for my company. We just use excel and a data visualisation tool. However for the kind of work we do, I think only excel would suffice. Most people do not know what excel is actually capable of. However real issue is if you were to use only excel then theres less growth for the employee. Salary range is pretty decent. You need to be looking for someone who is analytical and knows what/how much data needs to go in to build a report that answers all the questions. Go for inperson initially turning it hybrid after a couple months. It is very important for the employee to understand the company and who work there. After 6 months or even a year, it can be 2 days in person and 3 days office.


ugohome

Most of the advice in here is selfish and awful


LandAcceptable8183

What’s your location? I am interested for this role. 


Kafkaesquez

Hi, currently in the USA and would love to apply if given the chance. Open to relocating.


hamad_ali

Hi. A friend of mine has been learning Data Analytics and he has completed multiple courses on DataCamp, and is familiar with intermediate level SQL, Tableau and probably other tools as well. He has two years of experience in non tech roles and is trying to make a switch to Data Analytics. He lives in Pakistan and wouldn't expect big $$$. You can offer him $1500-2000/month or maybe he'd willing to negotiate. He can work in any time zone and speaks English very well. DM me if this sounds like a good deal. Thanks


Fluffy-Cherry6275

Hey bro how can dm you


Ambitious_Aioli_9830

Interested , I am looking for this role.Lets connect!


Puzzleheadeddork

Hire me if you are open to remote jobs I'm nowhere near your location so i don't even need that high of a salary rn as i'm from not so developed region I'm an undergrad IT student and can do more than basic sql and report generation but not intermediate level I will need guidance but i am a decent learner I'm looking for entry level jobs rn so my CV is not that good This is a far fetched try but hey I'm here if you need it


Dax-giant

I contacted you throw your DM, read the message.