My current major allows a few lines with only day trips. I assume those are somewhat senior. But maybe not too senior because you'd have to live close to the airport, and even then I know many locals who really prefer two-day trips, simply to minimize the driving/parking/shuttle bus/security drill.
My regional also had some day trips, those went pretty senior. They also had CDO's... opposite of sleeping in your own bed, but you go to work after dinner, fly one leg, get a nap in a hotel, one leg back and home in time for breakfast. You have your day to yourself. CDO's went senior as well, some folks had other jobs or businesses during the day.
As GF said, overnights are a part of the (airline) business because somebody has to fly the late flight that parks overnight at the outstation, and somebody else has to fly the early am flight back to the hub. So crews have to be in position overnight at outstations.
Except Allegiant... their business model is still pretty much all day trips to my knowledge.
So it can be done, but you'll have to accept that it will take some dues paying to get the necessary seniority, and you'll have to select both employer and base with those schedules in mind. And live in base obviously.
For part 91/135, there are plenty of employers with little or no overnights, you'd have to research that. But that might be 1/3 of career airline compensation.