There are a variety of different was an offense can use a Tight End. Here is an excellent article on how to utilize a tight-end in your offense.