I think this is a common problem in the data world for sure.
It all comes down to self-awareness and communication. Knowing your strengths, weaknesses and limitations, then knowing how to communicate them.
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001