Secret Agent 6 logic and 6 charisma
There are 7 job titles for the first part
After you get to the "top" of Secret Agent you need to choose between Diamond Agent or Villain
Diamond Agent you need 10 Logic and 8 Charisma. Your daily task will be Romantic Interactions. There's 3 job titles: Sky Captain, Shadow Agent and finally Double Diamond Agent
Villain Branch You need 10 Logic and 6 Mischief. There are 4 job titles. You'll need to use Mischief.
Here's a great guide, thanks to Sims VIP. I had no part in creating it.
https://simsvip.com/the-sims-4-secret-agent-career-guide/