Only if a book were so morally problematic that it had absolutely no redeeming value and
it was positively poisonous to Christian faith and morals, would you face the possibility that you might have to ask your boss to excuse you from working on the project. Although there have been horror stories in recent years -- such as with The DaVinci Code
by Dan Brown and If I Did It
by O. J. Simpson -- most mainstream publishers of literary and commercial books do not often seek to publish books that are utterly unfit for publication from a moral perspective.
In preparation for a potential career in this industry, you may wish to track down a copy of How to Read a Dirty Book
by Irving and Cornelia Sussman. The Sussmans were lay Catholics who taught drama and literature at UC Berkeley in the 1960s and wrote this book to educate Catholics on how to read novels with morally problematic material. The book is out of print now, but you should be able to find it through interlibrary loan or through used-book services.
Can Catholics read explicit novels?
Questions about Evaluating and Watching Movies
by Steven Greydanus (scroll)