Insights/delete orphaned series

Created by: coury-clark

Closes #26757 (closed)

Delete data series that have been soft deleted in a background process. This will serve as a garbage collection process for data that is no longer in use.

Test plan

Included one automated test to verify all of the tables are deleted, as well as tested manually by running the job and verifying the series were deleted.