https://websoilsurvey.sc.egov.usda.gov/App/WebSoilSurvey.aspx

Use the soil survey to see what your soils. The data isn’t 100% accurate but a good start. Odds are you have clayey soils which are kind of like a sponge. They’ll absorb water but once saturated become impermeable.

Take a look around your yard, are your neighbors properties sloping to yours, do you have downspouts that are discharging in that area?

If your neighbors yards slope to yours, I don’t think you can just put a berm on the property line to dam it up. So you need to collect the water and discharge it somewhere. Yard inlets can be bought at Home Depot and are effective, but you need to pipe it somewhere. If your yard slopes to the street or somwhere you can “daylight” a pipe, that’s ideal. But if you’re like me and have a flat or even low lying yard, you’ll need to do a dry well, which is just a hole in the ground with a fabric liner to keep the soil particles out, and an open graded gravel like #57 stone. Run the pipe to that and the water goes through the stone and permeates into the soil. If you have clayey soils the dry well will need to be pretty big which is why daylighting is preferred. Or if you did down and find you have sandy material, that had a higher permeability and will drain faster.

Edit: when was the last time you aerated your yard? Every time it rains or snows or you walk on your yard, it gets compacted. Before you go digging up your yard, try aerating it so it can open up and breathe. You can even mix in organic material to improve permeability (I’ve never done that so can’t speak on its effectiveness)