Commercial Real Estate Reporting Specialist
Commercial Real Estate Reporting Specialist
Posted on :
12-07-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
12-07-2025
Job Description
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 youre 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. Youre intimately familiar with time value of money calculations. Youre comfortable holding conversations with non-technical business users on real estate and investment topics.
Technical Knowledge Requirements
Youve 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. Youre 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.
Summary of Competitive Benefits & Perks:
- Health/Medical Insurance including Dental and Vision
- 401(k) with company match
- Paid time off
- Bonus/Target Incentive
- Tuition Reimbursement
- Complimentary usage of modern in-house fitness center
- On-premise full-service dining center discounts
- Discounts via the companys EAP
- Monthly Employee Recognition Programs
- Referral bonus
- Pre-tax transportation options
- Plus more!
Soft Skills Requirements
- Youre an excellent communicator that knows how to toggle between technical conversations with department colleagues and high-level plain English conversations with business teams. Youre comfortable presenting in front of a large audience.
Other Requirements
- Youre internally motivated driven and very curious. You love to build things and are obsessed with efficiency. You understand that our firm is made up of mostly real estate professionals and does not have an engineering culture. Most of your colleagues will not understand the details of your work. You also understand that our firm emphasizes reliable working solutions over the use of cutting-edge technologies. You have a whatever it takes mentality and will roll up your sleeves to do data wrangling report formatting and quality assurance work where necessary.
Responsibilities
- Manage maintain and optimize on-premises SQL Server data warehouse for core business reporting.
- Manage monthly & quarterly business processes to generate and deliver timely and accurate reporting.
- Develop reports analyses visualizations integrations and automation processes for business teams.
- Collaborate with business teams to understand data-related pain points and develop high-quality solutions.
- Build frameworks workflows and tools that create efficiencies for the Data & Analytics team.
- Achieve mastery of commercial real estate concepts and calculations regarding leasing financial accounting appraisals valuation forecasting budgeting debt derivatives and returns.
- Communicate technical concepts clearly and concisely to non-technical counterparts.
- Assist with non-technical tasks that support the mission of the Data & Analytics team and/or the firm.
- Research and advise on use cases for modern technologies such as AI and cloud computing.
Education / Additional Job Qualifications
- Bachelor of Business Administration or Analytics
- Passed CFA Level 1 (or MBA)
- 5 years building data warehouses
- 5 years experience building advanced reports in Excel
Core Company Competencies
- Perseverance
- Focus
- Accountability
- Empathy
- Social Responsibility
Core Job Competencies
- Communication - Interact with employees at many levels of the organization and must have the ability to express ideas and information orally and in writing keeping in mind the intended audience.
- Analysis skills - Can be counted on to gather understand and process information that is critical to the organizations operations.
- Planning & Organization - Accomplishing specific goal(s) while managing time and resources to meet deadlines and expectations.
- Attention to Detail - Focus on all areas of a project and paying close attention to all aspects of it.
- This position is based in an office environment with prolonged periods of sitting at a desk and working on a computer.
Working Conditions/Physical Requirements
$120000 - $140000 a year
The actual base pay offered is determined by several variables including as appropriate the applicants 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 Managements 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 contactor .
Equal Opportunity Employer/Veterans/Disabled
Required Experience:
Unclear Seniority
Employment Type
Full Time
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
