This is Steven C Warner of the Notre Dame Folk Choir’s setting of Psalm 40. Like most of the songs in Voices As One it has liturgical uses beyond just the Sundays when the Psalm is set.
The text is available in the sample pages at WLP where the sheet music can be purchased.
The refrain is arranged SATB with the tenor line a counter melody. You can listen to the piece here. It is a lovely prayerful tune.