There are many options. It depends on what his contribution to the project is. You could say:
"He is the brains behind this project"
"He is the creative force behind this project"
"He is the driving force behind this project"
"He is the the main source of funding behind this project"
There are many options. It depends on what his contribution to the project is. You could say:
"He is the brains behind this project"
"He is the creative force behind this project"
"He is the driving force behind this project"
"He is the the main source of funding behind this project"
I think "conceptual artist" is how some people describe themselves. I wouldn't go so far as to say it's a job title though I'm sure it will be one day.