I am not sure about special things with Trial of Iron saves, but the official save locations are:
Windows
%USERPROFILE%\Saved Games\Pillars of Eternity
%USERPROFILE% usually is something like C:\Users\your-name-here
OS X
For Steam, GOG, and DRM-free backer disc versions:
~/Library/Application Support/Pillars of Eternity/Saved Games
If you bought Pillars of Eternity from the Apple App Store, your save game directory is located here:
~/Library/Containers/com.mpdigital.pillarsofeternity/Data/Library/Application Support/Pillars of Eternity/Saved Games
Linux
$XDG_DATA_HOME/PillarsOfEternity/SavedGames
If $XDG_DATA_HOME is not defined, it's stored in ~/.local/share
Steam cloud saves
The steam cloud saves functionality syncs your local save files with the steam cloud. Modifying your save file outside of steam will likely cause this functionality to pop up a warning message about the cloud and local versions being out of sync the next time you launch the game. You can find more information about the steam cloud in this gaming.se question.
It can be enabled/disabled by right-clicking on the Pillars of Eternity game in your library and selecting the "Properties" option, then going to the bottom of the updates tab and checking/unchecking the "steam Cloud Synchronization" box as in the below screenshot.
Best Answer
Generally, no.
Certainly, some builds will be stronger than other, but there is very little actual content that is meaningfully gated by stats, class, or background. There is quite a bit of dialog reactivity around stats - and in some cases, you can leverage say... your high Might score to intimidate an NPC into doing what you want. But sometimes, trying to do that will backfire and start a totally unnecessary fight, closing off content.
If you're the sort of person that will get angry about dialog options not being available because of the character you rolled (Even when they almost always have no bearing on the outcomes of the dialog and simply provide flavor and style!), you'll want 15's in Int and Resolve, will want to put points in Might, and will probably not want to dump Perception. This is a tough stat spread to realistically build in many cases, and is distinctively poorly optimized. You'll also want to be either a Cleric or Paladin. You'll note that you can't be both. Even within either of those classes, you're going to have to choose an order, and some orders have more dialog than others. But they all have dialog. The point is, it's a fools errand to try to do this; build a character that fits your vision and has mechanical stats that make sense for what you want your character to do in the world - it will work out if you do that.
Mechanically, again, it's pretty hard to screw up too much, because Pillars is a party based game. Since you can fill 5 slots in your party with totally custom adventurers if need be, it's not a big deal, even if the PC you make is dead weight. And it's pretty hard to make truly dead weight, because every stat benefits every character to some extent. Maxing out Perception and Resolve on a Rogue isn't ideal - the two stats contribute absolutely bupkis to a Rogues offensive ability, and they don't really have any specialized tools or talents to make them better tanks - but a Rogue with maxed Per and Res is going to be very hard to hit, and can stand in the middle of a battlefield doing not much damage (since you presumably tanked Might... tsk tsk) for a very long time, and outlast many enemies, and shrug off friendly fire while a Wizard with tons of might blasts them to kingdom come. And sometimes, counterintuitive stat spreads can work beautifully; the classic Barbarian has high Might and Con, and Might is important for any offensive character, but in Pillars, arguably the best stat for a Barbarian is Intellect - it increases the range of their AoE and Cleave abilities, and the duration of important buffs like Frenzy.