I’ll take a very rough stab at this, and we can refine it if I misunderstood.
Sump pumps, as I’m sure you know, take care of groundwater - that is to say, the water that is below the ground surface. Groundwater is funny stuff; I’ve worked with geotechnical engineers and hydrogeologists long enough to know that nothing below grade is completely predictable. In general, the “topography” of groundwater (it can be modeled and contoured) will follow the surface topography, but there are plenty of exceptions to that, so we should just start out with that as only a preliminary assumption. And the groundwater surface is not static like the ground surface. It can fluctuate based on weather conditions, or whether people are drawing it down with wells. Your neighbor up the street could put an addition on his house, and you might see results months later. So there is a great deal of “maybe” in this response without having groundwater monitoring wells or test pits.
Your sump pump’s frequent on/off behavior may be from two common occurences, although I am doubting it from your description. Nevertheless, let’s get them out of the way.
-Sometimes pumps “cycle” because of a very small difference between the float switches. If your pump “on” float turns the pump on, and it ejects the water in the sump, and quickly reduces the water in the sump, the pump will then shut off. If there is no valve to keep the water in the pipe from returning, this water will come back into the sump, triggering the on switch, ad nauseum. If so, you may be able to adjust the float switches or make the sump larger to avoid this.
-Or, the outfall for your sump pump could be discharging quite close to your sump. The water quickly finds its way back down below grade and fills the sump. In this case, extend the pipe discharge away from the sump.
Let’s say that neither of these is applicable.
Your house has a high ground surface in the front, and a low ground surface to the back. Let’s start with the assumption that the groundwater is following the existing grade. Therefore, the groundwater will be higher along your basement wall to the front, and will slope down to where it is some distance below your basement slab in the rear. By the time it reaches your retaining wall (I am assuming here that the high side of the wall is on your property and the base of the wall is the walking path), the groundwater is far enough below grade that the weepholes (relief drains in the wall) are not seeing any water.
In a perfect world, your builder should have installed a subdrain (sometimes called a french drain) around the footings of your foundation. This is typically a PVC perforated pipe surrounded by crushed stone, and that whole package surrounded by an envelope of filter fabric. The idea is to intercept groundwater at an elevation lower than your basement slab so that your basement won’t see groundwater.
It is possible that you have this, but instead of discharging to the rear of your property, the pipes enter through your foundation walls and into your sump. Can you see pipes coming into the sump hole? If so, you may be able to connect to this line (at the rear of your house if it extends all around the footings) and take the drainage away from your house. If not, then you may not have a subdrain.
And that’s too bad, because the cost and effort to install this is laughably small compared to the cost of the foundation work - at least before the foundation and footings are backfilled. If you want to do this now, you will be in for some backbreaking work at the front of your house. If you are up for the work, or know someone who has a backhoe, you could install it now.
But I wouldn’t have it discharge to your sump. The sump should be the emergency backup for any water the subdrain didn’t intercept. The ideal solution would be to bring the discharge pipe to the rear of your property and have it “daylight” or discharge at grade elevation. With a 10% grade, it shouldn’t be too long to reach grade.