When a compensation review process is finalised, does the data automatically update in employee's profiles?

Yes. Once a compensation review process is finalised by the Compensation Manager, any remuneration related changes or payments are updated in the employees' profile and can be exported to your payroll department / payroll provider.