Goldman Sachs has been working with the artificial intelligence startup Anthropic to create AI agents to automate a growing number of roles within the bank, the firm's tech chief told CNBC exclusively.