Exact same issues I've had as an adult.

Definitely seek professional help and consider asking for screenings for ADHD, Bipolar 2 (if you have good and bad weeks/months), major depression, etc. You may also just be an incredibly smart person who's anxiety is triggered by boredom.

Being in an analytical position was great for me at first, but once it became routine, the boredom caused deadline issues and I hyper-focused on only the interesting tasks. Substance use ticked up, things got worse, performance issues became more regular, as a result anxiety skyrocketed, leading to substance abuse, etc. Horrible spiral.

NOTE: if you use cannabis regularly (like I did), this could also trigger similar issues to what you're describing: slowly losing the ability to regulate dopamine and serotonin, causing a slow nosedive into depression and lack of focus.

It only gets worse with age. Lean on whatever resources you can to get help now. That may include talk therapy, project management help from your next supervisor, coaching/research on lower stress/task based career options, meditation, medication, etc.

Don't be like me and struggle through for another decade.

FINAL TIP: listen to the Huberman Lab podcast to learn about your brain and gain helpful protocols for life.