In Berlin, speaking German is not at all a requirement. In Munich, you can get by but you ought to learn. In Stuttgart, better speak German.

You're best off researching companies on cruchbase and angel.co, though http://berlinstartupjobs.com/ sometimes lists good opportunities.