Want to hear how I work? Hit play.Find roles with Kablio AI to help build and power the world.Kablio AI helps you secure roles in construction, clean energy, facilities management, engineering, architecture, sustainability, environment and other physical world sectors.
Get hired, get rewarded!
Land a job through Kablio and earn a 5% salary bonus.
Exclusive benefits
5%Bonus
Excel VBA Developer
Newmark
Provides commercial real estate services including leasing, capital markets, property management, and advisory.
Develop and maintain Excel VBA tools for real estate finance and reporting.
Integrate with real estate platforms (e.g., MRI, RealPage, Argus Enterprise exports) to streamline monthly and quarterly reporting.
Ensure data quality, compliance with internal controls, and protection of sensitive information.
Automate data pipelines: import, transform, and validate data from CSV/Excel files, SQL databases, and APIs; standardize property/lease/GL datasets.
Establish version control, code reviews, and structured release processes for macros and templates.
Implement robust error handling, logging, and performance optimization for large workbooks and multi-sheet models.
Design, build, and optimize Excel-based VBA tools for underwriting, lease analysis, cash flow modeling, budgets, and variance reporting.
Develop dashboards, scenario analyses, and templated packages for investment committees and lender reporting.
What you bring
excel vba
power bi
power automate
sql
5+ years
financial modeling
Clear written and verbal communication; ability to gather requirements and train non-technical users.
Experience handling large datasets, data validation, and reconciliation across multiple sources.
Power BI and DAX experience for extended reporting; Power Automate for workflow orchestration.
Expertise in VBA, advanced Excel features (Power Query, Power Pivot, named ranges, dynamic arrays), and workbook optimization.
Argus Enterprise (exposure preferred), Yardi/MRI/RealPage data exports
5+ years of professional experience developing Excel VBA solutions in a business environment.
Understanding of SOX/internal controls and audit-ready documentation.
Strong SQL fundamentals and experience connecting Excel/VBA to databases (ADO/ODBC).
Power BI (preferred), Power Automate (nice to have)
Python or Office Scripts for complementary automation; familiarity with REST APIs.
Proven ability to build financial models; familiarity with real estate concepts such as NOI, cap rates, IRR, DCF, sensitivity tables, and waterfall structures.
Hey there! Before you dive into all the good stuff on our site, let’s talk cookies—the digital kind. We use these little helpers to give you the best experience we can, remember your preferences, and even suggest things you might love. But don’t worry, we only use them with your permission and handle them with care.