Sekai Saikou no Ansatsusha, Isekai Kizoku ni Tensei suru

The greatest assassin on Earth knew only how to live as a tool for his employers—until they stopped letting him live. Reborn by the grace of a goddess into a world of swords and sorcery, he's offered a chance to do things differently this time around, but there's a catch... He has to eliminate a super-powerful hero who will bring about the end of the world unless he is stopped. Now known as Lugh Tuatha Dé, the master assassin certainly has his hands full, particularly because of all the beautiful girls who constantly surround him. Lugh may have been an incomparable killer, but how will he fare against foes with powerful magic? (Source: Yen Press)