Solutions Consultants are responsible for designing and implementing solutions for new clients, ensuring efficient onboarding and unlocking value from Addepar's platform. They advise clients on financial modeling, manage projects, and ensure client satisfaction.