I suppose if you're looking for the optimal location, you would have to find the point on a fixed - pinned beam with an overhang, where the positive moment in the span matches the negative moment on the overhang, under the applied loading, which would then be measured from the point of fixity of the sheet piles. It could be derived (and probably has been somewhere), but it would change depending on the balance between the linearly increasing loads (soil pressure) and uniform loads (surcharge).
Most people would assume a simple span from the bottom of the exposed height to an assumed tieback height, calculate the moment on the simple span, calculate the moment on the cantilever portion above the tieback, and maybe go through a couple iterations to get them to approximately balance. That's what I would do, assuming that practical considerations (ease of construction) on the placement of the tieback didn't take precedence over optimizing the sheet piling.