Your work contacts will appear in the Google provided contacts and SMS apps. Other applications will need support for reading contacts from your Android Work Profile.