Work in the USA

My very good friend is an independent life insurance broker. He is based in Los Angeles, California and wants to hire me. I am a french resident with a high school degree and no job experience or training. I want to get employed in his company (first as a secretary-computer guy, he needs an english-spanish-french speaking person with computer skills and can’t find any in the us) and then pass the exam in order to become a life insurance broker too and work with him.

Does it sound realistic ?

What visa do i want in order to be able to work for my friend ?