While it doesn’t solve historical jobs - it does going forward. The way I would approach it is when jobs are completed, use an automation to create an item on a log board. It will say who was assigned, the name of the job, the date completed, etc.
Now you can easily filter that board by date and person to see.
You could probably set up some automations to create items for previous completed. One time use situation.