Overview
A national organization is seeking a Data Analyst to support the Asset Management department by improving data quality, automating reporting, and delivering clear portfolio insights for a national affordable housing portfolio. This remote role involves developing dashboards, reports, and analysis tools; consolidating data from multiple systems; supporting financial and portfolio analysis; and preparing recurring reports for internal and external stakeholders.
Schedule: Monday-Friday, 8:00 AM - 5:00 PM
Location: Remote
Pay Range: $34.13/hr - $37.88/hr based on experience
Responsibilities
- Analyze budget-to-actual results, key performance indicators, cash flow projections, and portfolio trends; identify variances, risks, and opportunities for Asset Managers.
- Support annual operating and capital budgeting, replacement reserve reimbursement requests, and other capital funding processes.
- Research and summarize market, leasing, demographic, financial, and property information to support portfolio decision-making.
- Assist with financial modeling, scenario analysis, due diligence, and documentation requests for acquisitions, dispositions, refinancings, and recapitalizations.
- Prepare portfolio analytics, including financing profiles, maturity schedules, and performance segmentation, to support transaction and portfolio planning.
- Prepare monthly, quarterly, annual, and ad hoc reports for senior management, the Board, investors, lenders, regulatory agencies, and other stakeholders.
- Provide documentation and analysis to support affiliate-level reporting, watchlist summaries, compliance reporting, and special projects.
- Perform other job-related duties and projects as assigned.
Requirements
Education & Experience:
- Bachelor’s degree in real estate, finance, accounting, economics, business administration, data analytics, or a related field preferred.
- Three (3) years of relevant experience preferred, ideally in multi-family asset management, property management, affordable housing, real estate finance, or data analytics.
- Affordable housing experience, including HUD, LIHTC, Section 8, or PRAC programs, is a plus.
Technical Skills:
- Strong skills in Excel and data visualization tools such as Power BI or Tableau; experience with Power Query, pivot models, macros/VBA, SQL, or similar tools preferred.
- Ability to integrate, clean, validate, and analyze data from multiple systems; experience with MRI, RealPage, Yardi, or similar software preferred.
- Financial modeling and real estate transaction analysis experience preferred.
Other:
- Ability to work flexible hours.
- Ability to travel is required.
Compensation & Benefits
- Comprehensive Medical, Dental & Vision Insurance
- 403(b) Retirement Plan with Discretionary Employer Contribution
- Generous Paid Time Off (Vacation, Holidays & Sick Leave)
- Life Insurance & Short-Term Disability Coverage
- Employee Assistance Program for personal and professional support
- Wellness Incentives (up to $350 annually)
- Early Pay Access (up to 50% up to $1000 of earned wages)
- Career Development Opportunities
Location
Remote position with a Monday through Friday, 8:00 AM to 5:00 PM schedule.