What Career to Pursue - Role, Division, and Companies

Hi monkeys, I'm a first year entry-level analyst from a non-target school at my company (doing risk, not IBD or consulting) and I'm still trying to figure out what my ultimate position and job would be in the financial services. ***Before I begin I'd like to make clear that I am fully aware that I have just started and have a lot to learn and grow and that getting an MBA will further help me in terms of recruiting and career in general, so please try to advise based on that.

Speaking with numerous individuals and reading here in the forum, one of the most popular pieces of advice is to basically try new and several things (as there are a lot in finance) and then stick with what you like.

From my experience working at my company, I realize that I don't like some aspects of my job; it's pretty mundane - running reports, crunching numbers in Excel, and reporting to the seniors & my supervisor for them to use the data. I feel quite constrained and bored to be honest - at least this is how things are at my company. I feel that I'd definitely like to do something more interactive, with action, and rewarding. I'd like to use data and numbers as a means to an end and not the end in itself.

The way I imagine my future career, which I think I want it to be in Real Estate/M&A (and yes, it'll probably be more in senior/upper levels), is using data, arriving at an assumption, possibility, or even a conclusion, meeting with a client and negotiating, using the company's money to close a deal, and making a nice commission - sort of like an middleman between my company and prospect client. There is the raw side of things: data, numbers, charts, etc.; there is the passion and challenge; there is the interaction with people and more action in general; there is negotiation; and there is reward.

Based on what I've described, what would you say suit me? I've gone over WSO's job description if that helps. I know I don't enjoy just plugging and crunching numbers, I am not too passionate about trading and investing, and I'm definitely not interested in sitting with clients and working on their assets/pension plans/insurance.

***I still think that going through the IB/IBD and/or consulting experience is quite necessary regardless of my ultimate role and job in finance.