Are there any novels where a protagonist is reincarnated into a world with a unique, non-combat-focused profession that becomes central to their success?

The concept of a protagonist transmigrating or reincarnating into a new world and facing unique challenges is a popular one. In your case, you're looking for a story where the protagonist's new role isn't about fighting or immense power, but rather a more mundane or specialized profession that they leverage for success. This can lead to very creative storytelling as the author explores how everyday skills can be applied in extraordinary circumstances.

One novel that touches on this theme, though with a cosmic twist, is "The Game Cafe in Marvel and DC". While the protagonist, Zeref, is in a multiverse filled with gods and monsters, his primary challenge is running a cosmic cafe. This implies that his success and journey will likely revolve around managing his establishment, interacting with powerful beings as customers, and perhaps using his gaming knowledge or transmigrated perspective to navigate this grand setting, rather than direct combat. It offers a unique blend of the extraordinary setting with a more grounded, business-oriented challenge at its core. The focus is on the management and the interactions within this unique cafe environment.