$7B Commercial Real Estate Investment Vehicle seeking entry-to-mid-level data professional to support Senior Associate with data system maintenance, business process management, report development, task automation, and quality control. This exciting and collaborative role will work very closely with the Senior Associate. System training and knowledge transfer are top priorities. Once mastery of the existing data infrastructure and proficiency with investment and real estate concepts has been demonstrated, opportunities to lead development on new reporting and analytics projects will be made available.
Duties & Responsibilities
• Maintain the firm’s SQL data infrastructure and manage all portfolio/investment information relevant to fund reporting, including, but not limited to, returns, leasing/occupancy, financials, investment activity, portfolio construction, leverage, and appraisals. • Manage periodic business processes that involve the scheduled receipt, storage, review, and/or delivery of datasets. This requires close tracking of scheduled events and follow-up with multiple contributors to ensure timely completion of complex multi-stage reporting processes. • Develop robust table and chart-based Excel reports to user specifications with SQL data connections that provide functionality for users to independently refresh datasets. • Develop VBA/SQL procedures to automate routine tasks for various departments. • Develop mastery of commercial real estate concepts, acronyms, and vocabulary, including, but not limited to, leasing mechanics, financial accounting, forecasting, and fund structure. • Communicate technical concepts clearly and concisely to non-technical counterparts.
Qualifications & Skills
Requirements • Bachelor’s degree in a quantitative subject, preferably computer science or finance. • 1 to 3 years of experience in SQL/VBA development. • Mastery of Excel (structured tables, advanced functions, conditional formatting, charts). • Knowledge of best practices for database development and quality control. • Strong desire to learn, internally motivated, and excellent communication skills
About ASB Real Estate
ASB Real Estate Investments is a leading real estate investment management firm with a focus on major U.S. markets.
ASB Real Estate Investments, a division of ASB Capital Management, LLC, is a leading U.S. real estate investment management firm with $7.8 billion* in gross assets under management from over 325 institutional clients. Headquartered in the Washington, D.C. area, ASB invests in major markets across the United States, concentrating in industrial, multifamily, office, retail, and self-storage properties.