I’m in much the same job role (data analyst). I haven’t done any interviewing in years, since I work for a consulting firm I’ve moved from one job to another within the same firm.
BUT - that said, if your public domain stuff wasn’t acceptable, perhaps you could take an example of some SQL you’ve written that demonstrates some interesting problem-solving, and sanitize it with different field names. You could download the desktop version of Oracle, and make a small database so you can run the code and provide some output. Be prepared to describe what the problem was and how this code addressed it.
In my field, we would expect candidates to be able to analyze a business opportunity and prepare a presentation. We do NOT expect them to bring in current work. Instead, we give them a topic and ask them to research it from the public domain, then prepare a short presentation. This tests a few things, including critical thinking, the ability to find information, and their skills at preparing and giving a presentation.
In the OP’s case, if the employers wants to know about his skills with data analytics, I would think public domain examples of his work would be fine.
One of my first jobs in my 20s was with a “hot up-and-coming ecommerce consulting firm” in Boston (back when Boston was a relevant tech hub). They actively sought to hire “overachievers with diverse backgrounds and interests” as opposed to “antisocial computer nerds”. People who graduated from MIT, Harvard and other top schools and ran Iron Man triathlons or were alternates on the USA Olympics team in their spare time. Of course then they made them work 100 hours a week coding, turning them into the very sort of people they didn’t want to hire in the first place.
Isn’t this somewhat common in the field of gaming, especially for folks without a history in the industry? My impression is that gaming companies hire heavily from folks who’ve made well-regarded mods or other fan projects.
Do you also bill the company for your travel expenses is driving to the interview site, or for your time spent interviewing?
4-6 hours of background prep for a professional job interview doesn’t seem overly ridiculous to me. Much more than that would be.
In my field (graphic design) this is called “spec work” and it’s heavily frowned upon. I’ve done it anyway in desperation (to my detriment), but generally any employer that requires free work ahead of an interview is one swinging a red flag. I guess it’s different in other fields, maybe, but in my field its expected to have a portfolio already set to go so as to put a stop to requests for free work. If you can’t look at 15 of my other projects and determine if I’m competent at my job and still require free work just for you…you’re probably really bad at interviewing people, among other things.
There’s a difference, I think, between asking someone to perform an exercise, and asking someone to create something usable. My understanding is that the coding samples would be exercises that wouldn’t be of any material benefit to the company. If that’s not what’s meant, I agree with you.
As an engineer I’ve only heard of one job interview that required the interviewee to produce product as part of the process. It was we’re drilling a well here tell us how to do it.
Now that I’ve been a consultant I would charge them for the 10+ hours that my friend put in on their assignment or decline the position. As it was I gave him some of the work my company produced in the area and he cleaned it up to fit their requirements. Luckily all of that stuff can be grabbed from the BLM data base.
In my experience coding exercises with no business value are relatively common. For example I recently was asked to submit code that correctly calculated a total bowling score given a file of 10 frames, which of course consists of more than looping through the numbers and adding them up.
Prior to finding my current position, I interviewed with a company that required as part of the application process… an original poem about the last role you held.
This was for an IT job. Systems administrator specifically.
It was a fun part of the conversation when I went in for the interview, and while I didn’t get the position, it did verify that I do not have a future as a poet.
They used it as a filter for applicants. If someone wasn’t willing to go a bit out of the regular job role, it wasn’t someone that they wanted to hire.