WordPress Backend Developer: Custom Post Types (ACF) & Bidirectional Relationships

I am building a comprehensive natural history web project. The site is currently running on WordPress (Astra theme). I do not need front-end design or a new theme installed. The visual journal aesthetic utilizing a dark teal, burnt orange, slate, and sand color palette is already established. I need a backend database architect to build a relational content structure. You will be building five interconnected Custom Post Types (CPTs) that pass data to one another automatically. The Architecture Needed: Episodes: Needs custom fields to link to specific Locations, Species, and Gear. Locations: Must automatically display the Episodes filmed there and the Key Species found there. Species (Flora & Fauna): Must automatically count and display the Episodes where the species is seen, and link to the relevant Habitat and Location. Habitats: Must dynamically display the associated Locations, Native Species, and Episodes. Gear (The Outpost): Affiliate product database that links to the Episodes where the gear was used. (optional) Technical Requirements: Expertise in Advanced Custom Fields (ACF Pro). Proven experience setting up complex bidirectional relationships. Ability to map these custom backend fields to Astra theme front-end templates. Deliverables for Milestone 1: Build the 5 CPTs and establish the bidirectional logic. Populate the backend with the provided dummy data for the established 10-episode thematic sequence. Demonstrate that tagging a "Species" in an "Episode" automatically updates both front-end pages. To Apply: Please start your proposal with "Relational Database Ready" so I know you have read this brief. Include one link to a previous WordPress build where you successfully implemented ACF/JetEngine bidirectional relationships. See attached mockups for an idea of the expected (but negotiable) output. Ability to make front-end templates is also a bonus