Company Overview:
ASB Real Estate Investments, a division of ASB Capital Management LLC, is a leading U.S. real estate investment management firm from over 300 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.
ASB has built success around talented, hard-working individuals who collaborate to gain a broad and integrated understanding of real estate disciplines to deliver attractive risk-adjusted returns. We encourage a culture of collaboration, and all members of our team engage in offering their points of view on major decisions in an extremely inclusive management process.
Introduction
Commercial Real Estate Investment Manager with $6B in assets is seeking an innovative, forward-thinking, and experienced reporting and data warehouse specialist that has deep domain knowledge in real estate private equity. You will take over day-to-day responsibilities on managing, maintaining, and reporting on our internal data warehouse that centralizes core business data, such as leasing, appraisals, financials, receivables, performance, and debt. As a Reporting Specialist you will wear many hats, including data warehouse engineer, ETL developer, API engineer, database administrator, data architect, and data quality assurance analyst on the back-end side, in addition to report developer, report automation engineer, and visualization specialist on the front-end.
Domain Knowledge Requirements
It is extremely important that you’re very comfortable with data modeling for long-term commercial leases. You have experience building integrations with property management and appraisal systems such as MRI, Yardi, OneSite, and Argus. You understand mechanics, calculations, and jargon around commercial leasing, recoveries, appraisals, leverage, returns, receivables, and other real estate industry concepts. You know how to build financial statements from general ledger data. You’re intimately familiar with time value of money calculations. You’re comfortable holding conversations with non-technical business users on real estate and investment topics.
Technical Knowledge Requirements
You’ve successfully delivered data warehousing projects, ideally in SQL Server. You have a deep understanding of data modeling, especially regarding temporal dimensions and rollup calculations. You are also an expert in Excel, PowerPoint, and VBA, and fully understand how to build sophisticated, visually appealing Excel-driven reporting for recurring delivery. You’re comfortable writing the occasional Python script for automation of routine tasks. You understand how to build visualizations in business intelligence tools, such as Tableau. You can confidently integrate the data warehouse to source systems via API, linked servers, and flat files. You are qualified to migrate the data warehouse from on-premises SQL Server to a cloud solution, such as Snowflake or Databricks, if the need arises.
Soft Skills Requirements
Other Requirements
Responsibilities
Education
Additional Job Qualifications
Core Company Competencies
Core Job Competencies
Working Conditions/Physical Requirements
$120,000/yr - $140,000/year
The actual base pay offered is determined by several variables, including, as appropriate, the applicant's qualifications for the position, years of relevant experience, distinctive skills, level of education attained, certifications or other professional licenses held. Base pay is one component of ASB Investment Management's total compensation package, which also includes access to or eligibility for healthcare benefits, a 401(k) plan, short-term and long-term disability coverage, basic life insurance, bonus plans and more.
ASB Real Estate Investments is proud to be an equal opportunity workplace. We foster an environment that recognizes employees’ unique skillsets and ensure that all employees have an equal opportunity to grow and advance.
If you are a candidate in need of assistance or an accommodation in the application process, please contact [email protected] or 301-986-6000.
Equal Opportunity Employer/Veterans/Disabled
...Warehouse Coordinator / 613462nd Shift | $60K$65K MondayFriday, 1:00 PM 10:00 PM Overtime available on weekends and for special... ...to join a fast-paced manufacturing environment. This full-time, onsite role offers an exciting opportunity to play a key role...
About FinkBrandCoach FinkBrandCoach is a leading agency specializing in e-commerce and TikTok marketing for health supplements. Our brands, Nature Planets and Vyxion Soursop , are one of top sellers on Amazon and TikTok Shop . We also help other E-Commerce brands...
...client experiences, with a focus on delivery, excellence, and obsession over customer outcomes. This position involves contributing to HashiCorp's offerings, now part of IBM, which empower organizations to automate and secure multi-cloud and hybrid environments. You will...
...Rewards, Regular Full-Time Work Location: Hybrid, Parsippany, NJ, US Salary Range : $90,000 - $100,000 About Us : Delta Dental of New Jersey, established in 1969 as the state's largest dental coverage provider, has grown over more than 50 years to serve...
...Manufacturer has an immediate opportunity for a Manufacturing/Operations Equipment Adminstrator. Administrator will work onsite with occasional travel to other plants. Prior WMS and Ops Administrator experience is required to be successful in this role. Position starts...