Generally, yes.
In the United States, tipping in any service industry is commonplace. Tattoo artists don't generally factor the tip into the final price of your tattoo but they'd probably appreciate a 20-30% tip. If you've booked multiple sessions for your piece, tipping for each session wouldn't be a bad idea as larger pieces can take months to complete.