Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
Knot My President!
Jan 10, 2005

Who I am: Recent college grad with a BA in Economics and an AA in Business Administration
What I did: Predominantly worked in Stata, SPSS, and R. The majority of my upper division was analyzing survey data and running regressions.
What I want to do: Make more than minimum wage. For the love of god please

I'm at a loss. I'm assuming it would be beneficial for me to get experience with Excel and VBA and learn a programming language but I'm unsure of entry positions in my area (San Diego North County) that are both career-building and won't leave me impoverished.

Any ideas? "Jobs for econ majors" on college websites don't seem to help at all. I don't wanna get a CPA. :saddowns:

Adbot
ADBOT LOVES YOU

Knot My President!
Jan 10, 2005

Kim Jong Il posted:

I hire people like this sort of profile as entry level researchers, but you'd have to be in the NYC area. Most of the data analyst jobs out there are for finance with some marketing. If you're interested in public policy like I am though, the best options are consulting-ish firms like Mathematica or MDRC. If by chance that's what you're interested in I'm happy to talk, otherwise search for jobs with titles like "analyst" or "research", and skills like VBA, vlookup, STATA, etc...

There's probably some low hanging fruit for you. Learn vlookup and pivot tables for Excel like your life depends on it, and learn basic SQL queries (pretty much know what SELECT, INNER JOIN, and WHERE do.) Those are both pretty easy to learn but very useful and in demand.

Perfect reply. Thanks much! Gonna spend the next two days brushing up on my Excel skills so I know what to expect. :)

Knot My President!
Jan 10, 2005

Kim Jong Il posted:

Can you PM me a link to a resume, save it on a Google drive or something like that?

Do you mind if I do the same? :ohdear:

Knot My President!
Jan 10, 2005

Thanks to this thread I now know how to (very roughly) use macros, vlookup, and nested equations. It really wasn't as bad as I thought it would be, hah. Now, what is with this "SQL" thing and is it important to learn? (I am assuming yes) Where is the best place to learn such a thing?

Knot My President!
Jan 10, 2005

I just got my first job/internship as a market research analyst. They were impressed with my resume, but all of my experience comes from Stata and a lot of what they want me to do involves Excel. What's the easiest way to keep my head above water? The job mainly focuses around survey creation, implementation, and statistical inferences arising from results, but I'm also creating various forms for the company in Excel and have absolutely no idea where to start. Any good resources to brush myself up? :ohdear:

Knot My President!
Jan 10, 2005

DukAmok posted:

The SA Excel thread is a great resource for small questions, and otherwise I've used MrExcel.com as a general knowledge resource. Congratulations! Is it really a job, or an internship? I guess what I mean is, are you being paid? Hope so, and good luck :)


Ragingsheep posted:

For Excel, if you know how to use pivot tables and basic formulas, then you have a pretty good solid base. Google has pretty much gotten me through 3 years of market research on Excel and if you're ever stuck on trying to figure out how to do X, pretty much just googling "how to do X excel" will give you a decent answer.

Also don't be afraid to try something new and generally if you get the feeling that "there's probably a better way to do this", then there probably is so spend a little time looking into it and introduce that solution to your team/manger. Worst case is that nothing happens but if it is genuinely more useful, you've just increased productivity and demonstrated some initiative which is always good when it comes to performance reviews and bonus time.


Xguard86 posted:

Finally, I can contribute to an answer:

One thing to remember with excel is that you may find an answer that works, but there is a more elegant or quicker way to reach the same result. So don't stress if you're not getting the A+ solutions, as long as you're getting the desired results and learning to be faster/better next time you will have it down very soon.



Thanks guys :) It's basically what I have been doing so far and they've been happy. Gonna tackle some of those online resources while I look at some forecasting documents I've found.

The job is a paid internship that their department requested I personally fill the position of due to a great interview. It was originally set aside for somebody working toward a master's but because I'm a recent graduate they boosted it from part to full time at $10/hour 40 hours a week. I research statistics, surveys, and Excel all day. It' pretty much awesome and I have tons of freedom. Apparently if things go well they'll hire me on full time as an in-house market research analyst since they've never had one. :sun:

Knot My President!
Jan 10, 2005

Xguard86 posted:

excel skills also pop up everywhere, being able to say you know basic-intermediate excel functions opens a lot of entry level doors. I would also recommend you get very comfortable with hotkeys and avoid the mouse where you can. It takes some time but once you've got it down you can fly through stuff and look like a genius.

keyrocket is a cool piece of software that helps you learn shortcuts by popping up reminders when you complete a task with the mouse you could have done with the keyboard. Their free trial is for 1 program so you can set it to excel and get to know the common shortcuts in a week or two for free.

There may be a better solution and obviously make sure its OK for you install 3rd party software but I found getting that instant correction and reminder very effective in helping me learn.

Awesome, thanks for the tip! Company doesn't mind me installing anything on my system as long as it isn't internet_virus.exe and they've given me tons of free reign to do stuff like use Stata for my regressions since Excel's data analysis toolbar addon, while identical in theory, doesn't come close to the power nor online library of Stata. Keyrocket seems like a great idea and I'm definitely gonna install it on the work PC today (already did on my home PC too!).

Knot My President!
Jan 10, 2005

I'm currently interning at a company as a market research analyst but I don't know if they'll have a full time position for me afterward. What are some good job positions to look into with demographic and statistical business research on my resume? I just don't wanna be hosed come winter. :ohdear:

Knot My President!
Jan 10, 2005

I'm in the same boat as Bread. Well, kind of.

I'm at a paid internship working 40 hours a week as a market research analyst. I only make $10/hour, which is fine as it's my first real job outside of college, but I'm wondering how much experience is necessary before I actually can start to accrue a, well, living wage. I know I have it lucky being able to have a paid internship right out of college but my contract is almost up and from what I hear they won't have any open positions for me because they see no need for a research analyst and say I'm too new to the industry. Well, one person, but he's the COO-- every department I meet with says they need to create my department and have me in it since the work I'm doing is excellent.

I've developed state and county-level demographic libraries for many facets of the industry I work in and have been helping spearhead a lot of changes to the way our customer support staff connects with clients, including creating framework for surveys and assisting in creating automated customer retention programs in ClickDimensions and remapping of the territories our sales team targets to be more in-line with the quotas pressed on them. I've also done barometric research into how much presence we have in the US market with great results. I think my biggest weakpoint is that the job hasn't required me to do any quantitative statistic research in SPSS or Stata but I'm pretty much an Excel wizard now so I guess that's worth its weight?

"Median" for my area (SoCal) is 60-70k/year but even the bottom 10% is 30k a year, which is 50% more than I make right now. I just am kind of at a loss as to what to do since I don't have any bargaining power but at the same time I don't want to commute two hours total per day to San Diego in traffic. :geno: Is my job even classified as "market research"? What are my best options for employment?

Knot My President!
Jan 10, 2005

I have a good amount of experience with quantitative research using Stata in economics (BS Econ major) and my job has me looking at workforce and industry analysis reports and interpreting them for higher-ups to figure out methods of identifying and capturing market share. I wouldn't say my skills are entirely entry level but I agree that the work I'm doing is entry level (I really wish they'd give me more to do). As long as I'm making more than minimum wage I'm happy. :)

Knot My President!
Jan 10, 2005

Yeah, looking elsewhere is what I'm gonna be doing come winter. As far as marketing myself: the entire office loves me-- I won best costume on Halloween, made the best side on Thanksgiving, and each office department head wants me there-- except the COO, since he says I'm still too new, so I'm kind of boned in that regard, because I'm an intern and they give me projects as they see fit and they never ask me to do anything crazy advanced and have shut down any requests I've had for advanced data I need to find actual results. Trying to gauge my ability as a full working professional with the aforementioned just isn't working in my favor.

Damned either way I guess. Just got until the end of December then I should have no trouble finding something paying at least 20% to... 100% more money. :geno:

Knot My President!
Jan 10, 2005

Man, indeed.com is depressing in my area. My contract/internship is about to come to an end here, and while I have job prospects at a family friend's software company as a market consultant, I really would like something more permanent as well.

What are my job options for post-graduation, post-internship positions with experience as a market researcher? Here's my linkedin if anybody is interested:

http://www.linkedin.com/pub/sean-phillips/3b/11a/5a7

I really don't wanna move to the opposite coast to find work. :ohdear:

Knot My President!
Jan 10, 2005

Hey man, thanks for the reply, insight, and kind words!

I agree, a gig in San Diego would be a wonderful thing. I should clarify about my gripes with that commute I complained about:

The company I was interviewing for that required that commute started me off with a four hour case study interview of awful logic puzzles and simple algebra. They didn't like my "I could Google the calculations in five minutes but you can't honestly expect me to remember formulas off the top of my head I learned a half decade ago, do you?" answers I gave, even after giving them the right answers for math, reasoning, and economic insight. Then again, I didn't want the job from as soon as HR explained what Encore Capital actually did: They're a company that specializes in statistically tracking people too poor to pay their cellphone bills and, furthermore, so poor that cellphone companies refuse to go after the debt... then promptly sues them to make money. So I think I was a bit bitter being enlightened to knowing a company like that existed in that regard. Any company that refuses to purchase indoor lighting for their coworkers and laughs about laying off half of their staff to make more money is a company that will be first against the wall in the glorious revolution. I almost walked out during the interview several times.

For the right job, I wouldn't mind commuting to San Diego if it meant building my experience. I'll look into those positions you posted and hopefully report back with some success. :)

Adbot
ADBOT LOVES YOU

Knot My President!
Jan 10, 2005

PhD's are important, but most of the connections and fieldwork that will potentially get your foot in the door is through your university's connections. My friend is doing development economics and is still working on his PhD, in between in Uganda and Kenya figuring out problems with small scale loans and banking. Both of these came through his economic development adviser who has solid clout in that industry. (Jon Robinson, if you're wondering-- probably the best professor/teacher I've ever had) It also helps to have a really solid knowledge of Stata or another equivalent software suite. With a PhD after school, your prospects are high for work with NGOs and you'll always be working on something interesting.

Man, this makes me wanna go back to college to pursue more econ. :smith:

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply