Well, I haven't got any experience modding civ4, but I am an experienced programmer in object oriented java. As we speak, or rather as I am typing, I'm familiarizing myeself with python.
I have two brothers that are huge fans of the games as well, and might be sources of ideas and/or content...