Maybe I should be more clear - I didn't go to a Tier1 public school, didn't get into an elite school, how screwed am I?
What matters a lot more than the name of the institution on your degree is experience; getting that experience may be a bit tougher at a small school (you don't have FAANGs or huge biotech firms recruiting there), but it is certainly not impossible.
Three of the last four engineers I hired had no formal CS degree (but they had gone to bootcamps).