None of these things are magic. None of these things are something someone can't learn "a little" about.
And yet, like programming, all of these require a great deal of effort to master any degree of proficiency; this 1) takes individual dedication, and 2) is undermined for individuals when they're told repeatedly and incorrectly that being a "programmer" is a label, and that it's easy.
As an example of what I mean, the word 'mathematician' usually refers to someone who works as an academic in a University department and teaches advanced mathematics and who contributes research. This is hard, requires considerable focus and dedication.
Most people in societies with good educational systems can do mental arithmetic, and a majority could learn to apply mathematical results to situations e.g. at work if they needed to. Some countries have invented a special words for this latter kind of maths use - 'numeracy' and 'functional skills' are in use in the UK.
So again the word 'programmer' or its various synonyms covers your case - a 'programmer' helps to produce complex software as part of a team (usually) and spends most of their time on that.
Other people may do tasks that look a bit like the easier bits of programming as a smaller part of their job. OA mentions complex spreadsheets (and wow can they get complex but that is often part of the problem) and I'd go so far as to include a bit of bash, and perhaps a few lines of python to help in administration tasks.
Perhaps it is the last activity that we need a word for?
Consider other fields:
- Is everyone suited to be a mathematician?
- What about a building engineer?
- An electrical engineer?
None of these things are magic. None of these things are something someone can't learn "a little" about.
And yet, like programming, all of these require a great deal of effort to master any degree of proficiency; this 1) takes individual dedication, and 2) is undermined for individuals when they're told repeatedly and incorrectly that being a "programmer" is a label, and that it's easy.