Nobody expects an analyst to be a good programmer, but we should expect them to be able to use the basic tools, write a simple program or some easy SQL statements or a flowchart, write a well-structured bug report or change request, etc.
Otherwise, they will literally have no clue what anyone is talking about at the daily and you need to ask yourself what you need them for.