Hi everyone,
I have a second interview for a junior research analyst position at CBRE and I wil be tested on Excel, data interpretation and writing skills.
Any advice or experience about it? Will it be doing pivots tables, graphs,.. based on a huge excel database and write something about my observations ?
Anyone has already did these kind of test for a Real estate research analyst position ?
Any help will be really appreciated !
Thanks
| +48 | Being asked to stay behind and train my replacement | 14 | 3d | |
| +45 | New Comp Database - Google Form (Now with Data Validation) | 24 | 2h | |
| +30 | What does REPE actually do? | 12 | 1d | |
| +25 | Leave brokerage to be GP | 1 | 15h | |
| +24 | Public Homebuilders | 9 | 1d | |
| +24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 6h | |
| +22 | REPE/Development GPA | 15 | 1d | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 3d | |
| +16 | UC Berkeley MRED vs Columbia MSRED? | 2 | 5d | |
| +15 | Hospitality Finance - Perks? | 3 | 6d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Hey kyokura, sorry about the delay, but are any of these useful:
Or maybe the following WSO members have something to say: Biffa Kisame111Hoshigaki REMS_
You're welcome.
I don't know anything about the test, but a big part of a research analysts job is to create the quarterly reports for different asset classes. In that role, you have to use excel to track hundreds-thousands of buildings, so pivot tables are useful. From there, you will graph the data and then write about your findings. Basically what you're expecting.
I'd recommend getting a hold of a few reports from CB, Cush and JLL (you can download from their websites) and familiarizing yourself with the lingo.
Let me know if you have any questions, I work a lot with the research team at my company.
Good work buddy. If you've dealt with real estate models before you'll be fine. If not, go get some practice.
I work as an analyst in cre asset management and acquisitions. From my experience with broker analysts at cbre, cw, jll, and hff:
Pivot tables - doubt it
Graphs - maybe but doubt it
Huge excel dataset - doubt it
Build a small 10yr cash flow analysis - maybe
Edit/manipulate an existing model - likely
Good luck. If you can't figure out the answer then explain the steps you would theoretically do to arrive at it.
Thank you all for your responses. Finally the test was just a big database containing rental transactions with data such as location, surface area, tenant, annual renting,... The goal was to analyse the database and test my narrative skills.
I hope that it has gone well, the job seems very interesting :)
Was this in USA?
No, indeed, it's in Belgium (Europe)
Gottex research analyst interview (Originally Posted: 05/27/2010)
I will be interviewing for a Research Analyst position at Gottex Fund Management and was wondering if anyone here knows what the interview process is like (ie. interview questions, # of interviews, etc.). Any advice would be greatly appreciated!
My friend worked their last summer and he told me the interview process was very centered around your knowledge about the markets and current events as well as certain trading strategies
DJ Indexes Research Analyst Interview ??? (Originally Posted: 08/15/2010)
Hey guys, So out of the blue I got a call on Friday asking if I was interested in interviewing for a research analyst position with Dow Jones Indexes this upcoming Tues. It seems as if they're looking to hire 2 analysts; one equity index analyst and one alternative investment analyst. Both are entry level positions. I wasn't given much info, except that this phone interview would take place with some of the more senior members asking me about my resume and past experiences. Has anyone had any experience interviewing with DJ Indexes? Does anyone know what sort of questions, technical/behavioral, I should expect to get? Any help would be greatly appreciated.
Was this for the South Brunswick office? Apparently a lotta shit's been going on ever since DJI was bought out by Chicago Mercantile Exchange. How did the phone interview go? I'm friends with a lot of the interns there for this summer and a bunch of the full-timers. PM me if you've got questions the phone interview didn't answer.
Nam error impedit qui sed qui et. Blanditiis pariatur non nihil officiis. Vero rem est maxime illo eius qui maxime. Minima doloremque ut adipisci qui. Et reiciendis animi odio et nemo.
Sit sint hic commodi facilis tenetur hic temporibus. Architecto quis qui sed. Eius est natus asperiores sint quas soluta. Doloremque vel dolor eos cumque.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...