What is the relationship between science and faith?

In this sermon, Tyler Tankersley explores the tension between science and faith.  Why do these forces seem to so often be in conflict with one another?  How do we reconcile our faith with our understanding of science?  Perhaps there isn't a conflict at all; perhaps we're just not asking the right questions.