M.Sc

The scope of big data/ analytics is generating immense data everyday that get unmanageable over time.
Passion for coding is definitely a primary requirement for a data scientist or big data analyst at any level.
Btw, coding will be a very common practice 40 years down the line.
Work experience surely matters in the Masters courses of Business Analytics to make your profile stand out, to check the real-world credibility of your skills.
It should always be there regardless of the course.
If you do big data and want to do analysis then yes you would be a data analyst and progress from there. It all boils down to which field you want to specialize in. Job opportunities aren't an issue if you are well prepared and know all the major concepts and have a great project portfolio to show.