Load locations, then departments referencing them, then jobs, then grades and grade rates, then positions referencing jobs, departments and locations. Show a load failing because its dependency was not loaded first, then verify the full structure.
The sequence is the lesson, and it is worth keeping as a reusable runbook: getting it wrong wastes hours on failures that are purely ordering, and those failures look like data problems.
Structures load before people. Always.