Yes, you will need at least a Developer Edition (Express Edition does not include a profiler).
However, you do not need to install the database server itself in order to use the profiler. You will want to find something like "Client tools" in the installer.
Depending on your needs, you could use a third-party profiler, for example, the open-source SQL Server Express Profiler from AnjLab.
source share