The science council had an old database feeding their WordPress website to provide the scientific community with contact information from scientists all over the UK. They also had Salesforce which stored a similar set of data.
Keeping both sets of data in sync was challenging and a very manual process.
Previous consultancy partners had failed to deliver on expectations and some requirements were over engineered and confusing to users.
Science Council also had limits on the number of Salesforce API calls that could be made. The solution had to support this limitation.