The problem is that job openings are often for multiple locations. (You can work in our SF or NYC offices.)

In general: Try to avoid organizing your data in hierarchies, and instead navigate by filters. (This is why SQL won over older hierarchal databases.)