The Royal Society of Edinburgh has signed a partnership worth over £1 million to fund new research projects and help early-career academics.