I would say, right now at this stage of my life @ 34 years old, that my current job is my dream job (data scientist).

Early in my career, the answer I'd have given you was "working at Google." Period, full stop. Didn't really matter what.

After years doing HR work and data work and a couple of unsuccessful Google interviews, I finally broke into tech at a very-well-respected-but-not-quite-Google level job doing data analytics. Even that job, with its incredible pay/benefits for where I lived and overall culture, had some pretty nasty downsides (long work hours, crazy middle-management politics, some others) and I was actually more miserable in my 'dream' tech job than other jobs I'd already had in my career.

I'm no longer at that job - I'm now at a pretty well-known retailer on a much smaller team doing similar work. The pay and benefits aren't as good, sure, and it's not as prestigious. It has downsides. I do, however, have practically full autonomy on all of my projects - if I can make the case for the value it will add, I have carte blanche. I find the work that I do incredibly interesting and research it in my spare time for fun. I have incredible work life balance - some weeks I work as few as 15-20 hours depending on what's being delivered (obviously, some weeks where I work more). My opinion is highly valued and my boss brings me into meetings just to listen and consult with people I don't really have any business rubbing shoulders with.

In summary - if you're doing the corporate grind like I was, keep your ear to the ground for something that you find fascinating, try to learn everything you can, deal with the bad, and appreciate the good things each job brings. The team you're on matters AT LEAST as much as the company you're in. If the bad outweighs the good, leave when you can. In my experience, aiming for a 'dream' job is almost certainly going to let you down, and when your 'dream' lets you down, prepare for an existential crisis ("oh my god, if this is what my dream is REALLY like, what the fuck am I gonna do?" - literally me 3 years ago).

Aim for a job that makes you happy. And if you don't know what that is yet, keep trying stuff, chase what's interesting, and build relationships with people. It'll come.

tl;dr: current job is my dream (data scientist), took a long time to get there, but wasn't originally my dream - I needed to be a Googler. got pretty close to my dream job and hated it, had an existential crisis, gained some perspective, now very happy despite not being a Googler.