5 - 8 years

6 - 9 Lacs

Posted:4 days ago| Platform: Naukri logo

Apply

Work Mode

Hybrid

Job Type

Full Time

Job Description

Excel VBA Developer Real Estate Analytics & Reporting

Location:

Employment Type:

Industry: Open

Shift:

About the Role

highly skilled Excel VBA Developer

Key Responsibilities

  • Develop, enhance, and maintain

    Excel VBA tools

    for underwriting, lease analysis, cash flow modeling, budgets, and variance reporting.
  • Automate data import, transformation, and validation processes from

    Excel/CSV, SQL databases, and APIs

    .
  • Build

    interactive dashboards, scenario models, and reporting templates

    for investment committees and lenders.
  • Integrate with real estate systems like

    MRI, RealPage, or Argus Enterprise

    to simplify monthly and quarterly reporting.
  • Implement

    error handling, logging, and performance optimization

    for complex workbooks.
  • Maintain

    version control, documentation, and structured release processes

    for macros and templates.
  • Ensure

    data quality, internal control compliance, and confidentiality

    across all reports and tools.

Required Qualifications

  • 5+ years

    of professional experience in Excel VBA development.
  • Deep knowledge of

    VBA, Power Query, Power Pivot, dynamic arrays, and advanced Excel features.

  • Strong SQL fundamentals and experience connecting Excel to databases (

    ADO/ODBC

    ).
  • Proven experience building

    financial models and real estate analytics tools

    (NOI, IRR, DCF, cap rates, sensitivity, waterfall).
  • Skilled in managing

    large datasets

    , performing data validation, and reconciling data from multiple sources.
  • Excellent

    communication skills

    and ability to train non-technical users.

Preferred Qualifications

  • Experience with

    Power BI, DAX, and Power Automate

    for reporting and workflow automation.
  • Exposure to

    Python or Office Scripts

    for additional automation and integration tasks.
  • Familiarity with

    real estate systems

    (Argus Enterprise, MRI, RealPage, Yardi).
  • Understanding of

    SOX/internal controls

    and audit documentation practices.

Tools & Tech Stack

  • Microsoft Excel, VBA, Power Query, Power Pivot

  • SQL Databases (ADO/ODBC)

  • Power BI / Power Automate (preferred)

  • Argus Enterprise, Yardi, MRI, RealPage (exposure preferred)


Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

sahibzada ajit singh nagar, punjab, india

hyderabad, pune, greater noida