No. Xbox Live profiles require an active internet connection and cannot be used for offline/local multiplayer on the same console.
Create a second offline profile (Settings → System → Memory → Profiles → Create Profile → "No, create offline profile"). This profile saves progress locally without needing Xbox Live. Switch profiles at the dashboard before launching the game.