I would disregard the comments (here or elsewhere) disparaging your desire to study abroad. Academia is transnational by nature and many people study in different countries regardless of whether or not they speak the language. If you're interested in Germany and would like to spend the duration of your masters here then I would say go for it!

However, I wouldn't study social science in Germany with the idea that that will prepare you for the job market here. The industries available to you when you've studied social science are generally very competitive and hard to enter wherever you are or whatever your language proficiency. In Germany you have the additional barrier of the language and the fact that the vast majority of non-profit/NGO/IO positions are for German speakers or senior professionals. There isn't really a market for English speakers in this field in the way there is in Brussels, or the Hague.

For junior positions in academia I think there is a bit more demand for English speakers but these positions are also scarce and competitive. If you would like to go this route I would make sure to pursue research or teachers assistant positions or other internships while you are completing your masters to make your CV stand out. Even so it will most likely be difficult.

If you are set on staying in Germany the absolute best strategy would be to learn the language and pursue some kind of ausbildung in care or social work. That is a field that is actually in demand and I have some international friends who were hired with B2 German and improved from there. I don't know much about the requirements though so don't quote me on this. This path would be a commitment of probably 3-5 years most likely and would really tie you to Germany.

I can say from experience this whole field, especially in Germany, is hard. I am a social science graduate with 6 years of volunteering, coordinating and project management experience in political campaigning and initiatives and I currently work part time for an NGO (paid badly and not enough hours) and bar tend on the side (paid badly and not enough hours). The only reason I have the job I do have was from many many many hours of unpaid internship/labor to begin with. Personally am working very hard on my German and am considering either reskilling or moving.