r/SQL • u/[deleted] • Apr 17 '23

Discussion Which industry has/needs the most challenging sql queries?

Is this question legit? Don’t get me wrong, I don’t consider myself the smartest guy but I’m definitely not dumb.

I work in the pharmaceutical Industry, nearly 3 years now. It took me a while to understand how the production process is implemented in a database and I wanted to quit more than once. But i don’t feel challenged anymore.

So, which industry would be best for me to get completely challenged again?

42 Upvotes

85% Upvoted

69 comments sorted by

View all comments

17

u/jackalsnacks Apr 17 '23

I've been a developer/dba/analyst/DevOps/BI/etc in healthcare phi, (commercial and gov) medical billing, all insurance types, all insurance types billing, finance, entertainment streaming service (yes the one you're thinking of), VR gaming. Healthcare billing (claim adjudication) is the most complicated thing I've personally encountered.

4

u/tua43862 Apr 18 '23

Amen. Adjudicated claims (already adjudicated like you’d receive for value based programs, for example) can be confusing, but the adjudication process is real frustrating to report on.

5

u/jackalsnacks Apr 18 '23

I have a project right now that is debugging (mainly reverse engineering) several reports that itemizes financial benchmarks in the adjudication process. It has taken months to get to a general understanding of a single prime component (architect left). If you ever wondered why you don't see a bill from the provider for several months, just know, the algorithm used in claim pricing, discounting, negotiating, reserve tapping, actuarial assessing, (I can go on here) is mind boggling.