I don't work at this company anymore, but I used python, powerbi, and sql when I was in corporate real estate in addition to GIS tools like placer.ai

We were a large retailer with over 1000 stores and 300 in the pipeline, over $20 billion in revenue. 

We developed in house, so you can imagine how python and sql were useful to us with current store operating data and applying that to underperforming stores and our pipeline.

 

Sounds like a ton of good data and interesting job. Could you expand a little more on a few examples of Python application at your previous job? Thanks in advance

 

Bump on this thread - anybody find any use outside of "data analytics" (might not be the best all encompassing term)? Does anyone see any relevance in an investment/development/acquisition style role?

Wondering if the integration of python into excel is a valid enough reason to pursue the skill (with potentially parlaying that into a more data scientist role).

 
Most Helpful

In acquisitions the use would be maybe saving yourself some time if you could set it up to feed the existing excel format.

Your bosses aren’t wasting time figuring out a new format though. CRE is super simple analysis relative to other finance fields. It’s relationship driven and imo the best analysis comes from market/product experts that already know the replacement costs, barriers to entry, and supply in their neighborhoods. Good acquisition guys know that off the top of their head.

I bet 90% of people on here or more could value an investment opportunity at a fair price. That’s the easy part to me. But how do you actually buy it at that right price?

How many could win the deal, line up partners, finance it, properly identify risks, run DD, potentially retrade it to the right price and still close? How many could get the deal before it hits the market?

I don’t want to discount using newer better tech to be more efficient because CRE is definitely archaic, and I can see it potentially identifying a trend here or there. But in a acquisition role I’m not sure your long term value is coming through becoming a data/modeling expert.

Maybe in more of a research, economist type role?

 

Definitely agree with this sentiment - think there could be some application as the above with a large scale co looking at a lot of data, but local knowledge for sure trumps data that looks pretty. Also agree with your statement that CRE is simple enough to run values and anything more than excel could be overkill.

Will be interesting as products become more and more commoditized if there is more use of tech in this space.

 

Ding ding ding. Very much this.

In my seat (research/economist role), I'm using SQL/Python/R/GIS platforms to merge disparate data sets and compile analytics/reporting across every US market. It helps inform the buy/hold/sell strategy given the local macro environments as well as provide site-level analytics and risk assessments for any given deal. This type of role only makes sense for bigger shops with a larger investment footprint - if you're local to say, Los Angeles, you should know your market inside and out without some data nerd telling you what's what. If you're covering ~50+ markets on the other hand... 

But at the end of the day, it's still just data. You need boots on the ground to actually understand the minutiae impacting a potential deal. A person in an acquistions seat would be much better served focusing on that rather than writing a Python script to rip together income growth, permits, and the like for everywhere under the sun. Most major shops have a dedicated research function to cover that.

In terms of something like underwriting, I haven't seen anyone do it before. So many input factors aren't provided in a standardized format - how many different rent roll formats have you all seen? - which would make 'operationalizing' that task incredibly difficult from a programming language perspective.

 

Organizing and cleaning data efficiently, automating reports, scraping publicly available data. There are so many options and it's kind of incredible that more people in the industry don't have a baseline proficiency.  Teaching myself on nights and weekends was one of the best things that I did professionally, and now that I have a baseline proficiency to build things that I can use I really enjoy it and find it interesting. Pretty amateur coder in the grand scheme of things, for the record. But cre boomers are still pretty impressed lol. Great for speeding up analytical drudge work 

As others have said, this industry is stuck in the stone ages in a lot of ways and I say that with love 

Run the money up i'm on that real estate shit - 21 Savage
 

Minima magnam id eos maiores. Cupiditate sit accusantium dolores perspiciatis voluptatem odio. Omnis natus et amet. Tempora minus modi possimus expedita in delectus. Consequatur voluptatem debitis itaque et tempore.

Vero iure eum natus. Iste dolore quod aperiam reprehenderit dolore. Officiis qui culpa est facilis. Iure voluptas dicta vel id quia.

Career Advancement Opportunities

June 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Lazard Freres No 98.9%
  • Perella Weinberg Partners New 98.3%
  • Harris Williams & Co. 24 97.7%
  • Goldman Sachs 16 97.1%

Overall Employee Satisfaction

June 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.9%
  • William Blair 02 98.3%
  • Lazard Freres 07 97.7%
  • Morgan Stanley 03 97.1%

Professional Growth Opportunities

June 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Perella Weinberg Partners 18 98.3%
  • Goldman Sachs 16 97.7%
  • Moelis & Company 05 97.1%

Total Avg Compensation

June 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (23) $378
  • Associates (95) $261
  • 3rd+ Year Analyst (14) $181
  • 2nd Year Analyst (69) $168
  • Intern/Summer Associate (34) $167
  • 1st Year Analyst (208) $159
  • Intern/Summer Analyst (153) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
kanon's picture
kanon
98.9
9
Jamoldo's picture
Jamoldo
98.8
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”