Composer Charles Villiers Stanford was born on September 30, 1852 in Ireland, but spent most of his life and career in England. He composed a wide variety of pieces: seven symphonies, multiple concertos and chamber works, ten operas, and, of course, much sacred choral music and several hymn tunes (list of works and longer biography at the link above).
He was also an acclaimed organist, conducted several choral groups and festivals, and was named the first professor of composition at the Royal College of Music in 1883. Later, he also taught at Cambridge University. His students included most of the prominent English composers of the next generation: Ralph Vaughan Williams, Samuel Coleridge-Taylor, John Ireland, Charles Wood, and Herbert Howells.
Though Stanford wrote several hymn tunes, only one of them is still in wide use today. ENGELBERG was written in 1904 to be sung with For all the saints, but Ralph Vaughan Williams' tune SINE NOMINE, written only two years later, has become the standard tune for that hymn. Stanford's original version of the tune was much more elaborate than we know it today; each verse had different harmony and not all the verses were sung in unison.
The text most commonly sung today with ENGELBERG is by Fred Pratt Green, and is still under copyright. However, you can see and hear When in our music God is glorified at the Oremus Hymnal site, where they have permission to reproduce it.
Some of Stanford's other hymn tunes can be heard at the Cyber Hymnal site, since they are unlikely to be sung in your church. The one I was most curious to hear is called GERONIMO, and I would also like to know how that name came to be matched with the tune. Though it may just be that Stanford thought it was a properly "exotic" one for early 20th-century England.