Looks like a 3rd now. Unfortunate. Top contributors. I'd like some more details too but in general I don't get why people find the need to be so abrasive (my guess to what happened). It's just code.
The desk-aligned dev spot is a tough one to land. If you’re not hailing from CalTech, MIT, et al, I suggest the highest-probability strategy is an indirect one: get a client-facing job at hedge fund administrator, get great at Excel+vba; over-deliver for the fund’s CFO and/or traders in all their post-trade questions (that’s why Excel+vba expertise is important: it’s easy to deploy to them as just an Excel file); get recruited. The right spot at a fund administrator is much less competitive, and you get an opportunity to impress the same people you would if you were hired directly onto a desk.
Excel+vba is an odd beast because, nowadays, it's rarely seen as a differentiating skill -- it's not taken seriously -- and yet on almost any trading desk there is an infinite series of todo's where Excel+vba is just the right tool for the job.
I think you could argue it's created a class of wealthy and super wealth admins who don't add value. From what I've read several studies have shown the vast increase in college expense has been sucked up by administrators and non teaching staff. I was looking at my college's (midwest state school) payroll and the various provost were making $600k. Kinda wondering what in god's name these people do.
I honestly don't think you're far off, but I also tend to think the "wealth admins" are a response to system inputs.
Take an example of catering to veteran students. Previously, many schools had a single person who was the veteran liaison as a side duty and not their primary function. When the post 9/11 GI Bill promised much more money for service members, colleges responded by having entire dedicated teams to help veterans navigate school. From the outside this may look like admin bloat to some, but for the college it actually does add value by helping attract students and guaranteed tuition payments. In a perfect world, that increase in students would ideally offset the salary for those positions, but I'm not sure if that happens. Please note that I'm not necessarily saying that's a bad thing, it just highlights that "wealth admins" may be providing something considered valuable to the university. Multiply that by all the various special interest groups and the number of administrative personnel can grow quite fast.
They sit around and make sure the teachers work. For some reason teachers think their 50k salary isn’t enough, so you need someone to keep them in line.
Note: Actually, I have no idea, but that is what my mind immediately went to when hearing provost.
I cannot recommend "About Face" enough. However it is a long read and covers the whole life story of Colonel Hack.
Instead you might want to check out "Steel My Soldiers' Hearts" where he focuses specifically on the time when he turned around the worst fighting battalion in Vietnam.
Yeah heard that was good too. Thanks for the tip. I feel like that would give you the real details that one would need to know for a situation like that.
Anyone have an example of using window functions in a non time series data set? Kinda seems like a bit of a flag in my head that if I'm asked to do some analysis w/ time series data (depending on the question) a window function might be a good the tool. Reading this you can tell I'm not particularly fluent in them. We use them at work and I was asked during my interview about them (did not know but got job anyway).
Say you have to grab a bunch of files a few times a day and zip them up and drop them on and endpoint somewhere. But the endpoint has a max file size for a single upload.
If you have a table of metadata about your files (zipped_size and location, for example) you can window on the sum of the zipped_size to collect some number of files you can get that will be under the file size limit.
I've personally seen and done both. At one job (first actual dev job) it was a lot of complex business queries for analytics. I put these into their own python module as string "constants" and imported them (I would not do this again). At my current job we put them in .sql files and have a 3 line function that opens and reads them into a string. I sometimes write them inline. I've come to only one real conclusion though is that unless it's super trivial I put the SQL outside of where they are being invoked and name the .sql something that makes sense. It's just noise in my code and I want to see the logical steps.
Take my upvote. This has helped us a ton. So nice that it resolves dependencies. Only issue we're running into is that we don't use it to manage our dependencies for our internal packages (only using it at the application level). I've been advocating we change so that we simply read in the generated requirements.txt/requirements-dev.txt in setup.py
> Yet an underlying concern is that pilot programs like these could alienate riders from taking public transportation entirely.
I thought this was the best line of the whole thing. If you can't pay for it then how can you be alienated? If you are paying for it then isn't the so called "hostile" design no longer hostile?
