VBA Developer at Newmark in Hyderabad, Telangana, India | Kablio

Role

Description

error handling

dashboard development

data quality

platform integration

data pipelines

vba tools

Implement robust error handling, logging, and performance optimization for large workbooks and multi-sheet models.
Develop dashboards, scenario analyses, and templated packages for investment committees and lender reporting.
Ensure data quality, compliance with internal controls, and protection of sensitive information.
Integrate with real estate platforms (e.g., MRI, RealPage, Argus Enterprise exports) to streamline monthly and quarterly reporting.
Automate data pipelines: import, transform, and validate data from CSV/Excel files, SQL databases, and APIs; standardize property/lease/GL datasets.
Design, build, and optimize Excel-based VBA tools for underwriting, lease analysis, cash flow modeling, budgets, and variance reporting.
Establish version control, code reviews, and structured release processes for macros and templates.

Requirements

power bi

sql

vba

excel

python

sox

Power BI (preferred), Power Automate (nice to have)
Strong SQL fundamentals and experience connecting Excel/VBA to databases (ADO/ODBC).
Microsoft Excel, VBA, Power Query, Power Pivot
Power BI and DAX experience for extended reporting; Power Automate for workflow orchestration.
Argus Enterprise (exposure preferred), Yardi/MRI/RealPage data exports
5+ years of professional experience developing Excel VBA solutions in a business environment.
Proven ability to build financial models; familiarity with real estate concepts such as NOI, cap rates, IRR, DCF, sensitivity tables, and waterfall structures.
Python or Office Scripts for complementary automation; familiarity with REST APIs.
Understanding of SOX/internal controls and audit-ready documentation.
Experience handling large datasets, data validation, and reconciliation across multiple sources.
Clear written and verbal communication; ability to gather requirements and train non-technical users.
Expertise in VBA, advanced Excel features (Power Query, Power Pivot, named ranges, dynamic arrays), and workbook optimization.

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Founded 1929

Year Established

The company has grown to be a global leader in commercial real estate services, with a strong legacy built over nearly a century.

Offers a comprehensive suite of services including leasing, capital markets, property management, and advisory.
_INVOLVED_ in significant projects across various sectors such as commercial, residential, industrial, and retail.
سابق Opera specialized in complex transactions, capital structuring, and operational strategies.
_INVOLVED_ advisory services are widely recognized for providing deep market insights and tailored solutions.
INVOLVED_ in handling diverse, high-stakes real estate challenges, from urban developments to large-scale industrial projects.

Culture + Values

Client-focused innovation
Integrity and transparency
Collaboration and teamwork
Commitment to excellence
Entrepreneurial spirit
Diversity of thought
Accountability and results-driven

Environment + Sustainability

2040

Net Zero Emissions Target

Aiming to achieve net zero emissions by a specific year, demonstrating a commitment to reducing environmental impact.

Prioritizing green building certifications and sustainable practices
Implementing energy efficiency measures across properties
Promoting renewable energy and sustainable construction practices
Tracking and reducing carbon footprint

Inclusion & Diversity

Developing diverse talent pipelines
Ensuring equitable opportunities for career advancement
Gender diversity initiatives with a focus on leadership roles
Increasing representation of women and minorities in management positions
Regular training and programs to foster an inclusive culture

Articles

Newmark Careers

News & Insights

Role

Description

error handling

dashboard development

data quality

platform integration

data pipelines

vba tools

Implement robust error handling, logging, and performance optimization for large workbooks and multi-sheet models.
Develop dashboards, scenario analyses, and templated packages for investment committees and lender reporting.
Ensure data quality, compliance with internal controls, and protection of sensitive information.
Integrate with real estate platforms (e.g., MRI, RealPage, Argus Enterprise exports) to streamline monthly and quarterly reporting.
Automate data pipelines: import, transform, and validate data from CSV/Excel files, SQL databases, and APIs; standardize property/lease/GL datasets.
Design, build, and optimize Excel-based VBA tools for underwriting, lease analysis, cash flow modeling, budgets, and variance reporting.
Establish version control, code reviews, and structured release processes for macros and templates.

Requirements

power bi

sql

vba

excel

python

sox

Power BI (preferred), Power Automate (nice to have)
Strong SQL fundamentals and experience connecting Excel/VBA to databases (ADO/ODBC).
Microsoft Excel, VBA, Power Query, Power Pivot
Power BI and DAX experience for extended reporting; Power Automate for workflow orchestration.
Argus Enterprise (exposure preferred), Yardi/MRI/RealPage data exports
5+ years of professional experience developing Excel VBA solutions in a business environment.
Proven ability to build financial models; familiarity with real estate concepts such as NOI, cap rates, IRR, DCF, sensitivity tables, and waterfall structures.
Python or Office Scripts for complementary automation; familiarity with REST APIs.
Understanding of SOX/internal controls and audit-ready documentation.
Experience handling large datasets, data validation, and reconciliation across multiple sources.
Clear written and verbal communication; ability to gather requirements and train non-technical users.
Expertise in VBA, advanced Excel features (Power Query, Power Pivot, named ranges, dynamic arrays), and workbook optimization.

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found