There are a number of subjects taught as part of the Hogwarts curriculum that involve one or another branch of science, and lead a practitioner to a wizard-world equivalent of a Muggle scientist career. Some examples of these fields, along with the Muggle equivalent and some practitioners mentioned by Rowling, include:
Astronomy - astronomy (Aurora Sinistra)
Herbology - botany (Pomona Sprout, Neville Longbottom, Tilden Toots)
Care of Magical Creatures - veterinary science, zoology (in wizardspeak, naturalists are called "Magizoologists": Rubeus Hagrid, Newt Scamander, Luna Lovegood)
Potions - chemistry (Severus "I don't expect many of you to appreciate the subtle science and exact art that is potion-making" Snape)
Alchemy - physics (n/a)
Arithmancy - computational mathematics (Hermione Granger, Percy Weasley, Barty Crouch Jr)
These examples indicate that, while some fields like engineering or quantum physics appear to be absent from wizard society, there are varieties of science, primarily related to the natural world, which are studied and practised. So while we have no wizards or witches quoting their opinions on science, we can infer with some certainty that they were not opposed to scientific endeavor. The reason it's much more limited in the wizard world compared to the Muggle world is probably because there is far less necessity to know how to build bridges or computers etc, when you can harness magic to get many of these jobs done much quicker and easier (c.f. the essay "Why Muggles Need Electricity").