Talent.com
Excel VBA Developer - Python/SQL
Excel VBA Developer - Python/SQLPravi HR Advisory • Hyderabad
Excel VBA Developer - Python / SQL

Excel VBA Developer - Python / SQL

Pravi HR Advisory • Hyderabad
30+ days ago
Job description

Job Title - Excel VBA Developer - Real Estate Analytics & Reporting

About the Role :

We are seeking an Excel VBA Developer to build and maintain robust automation, reporting, and financial modeling solutions that support acquisitions, asset management, property management, and investor relations. You will transform data from multiple sources into actionable insights, streamline underwriting workflows, and improve reporting accuracy and turnaround times across our real estate portfolio.

Key Responsibilities :

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

Required Qualifications :

  • 5+ years of professional experience developing Excel VBA solutions in a business environment.
  • Expertise in VBA, advanced Excel features (Power Query, Power Pivot, named ranges, dynamic arrays), and workbook optimization.
  • Strong SQL fundamentals and experience connecting Excel / VBA to databases (ADO / ODBC).
  • Proven ability to build financial models; familiarity with real estate concepts such as NOI, cap rates, IRR, DCF, sensitivity tables, and waterfall structures.
  • 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.
  • Preferred Qualifications :

  • Power BI and DAX experience for extended reporting; Power Automate for workflow orchestration.
  • Python or Office Scripts for complementary automation; familiarity with REST APIs.
  • Understanding of SOX / internal controls and audit-ready documentation.
  • Tools & Tech Stack :

  • Microsoft Excel, VBA, Power Query, Power Pivot
  • Power BI (preferred), Power Automate (nice to have)
  • Argus Enterprise (exposure preferred), Yardi / MRI / RealPage data exports
  • Work Arrangement :

  • Location : On-site, hybrid
  • Employment Type : Full-time.
  • Interview Process :

  • Initial screening (skills and experience).
  • Technical assessment : VBA exercise and Excel modeling review.
  • Final round focused on problem-solving and stakeholder communication.
  • (ref : hirist.tech)

    Create a job alert for this search

    Developer • Hyderabad

    Related jobs
    PL / SQL + BI Reporting

    PL / SQL + BI Reporting

    Tata Consultancy Services • Hyderabad, Telangana, India
    PLSQL development experience in data engineering or data analytics platforms.Write complex SQL queries and stored procedures to extract and analyze data for reporting purposes.Develop, maintain, an...Show more
    Last updated: 24 days ago • Promoted
    27-Nov-25_Virtual Drive_Databricks with Python

    27-Nov-25_Virtual Drive_Databricks with Python

    Tata Consultancy Services • Hyderabad, Telangana, India
    Currently, looking for an experienced Individual, worked on.Data-Bricks, Data Lake with Python.Kindly reach-out to me if you inherit these tools. Extensive expertise in designing and implementing da...Show more
    Last updated: 4 days ago • Promoted
    Lead SQL Database Specialist

    Lead SQL Database Specialist

    Programmers.io • Hyderabad, Republic Of India, IN
    Job Title : Senior SQL Developer.Shift Timings : 2 : 30 PM - 11 : 30 PM IST.Location : Remote, India, Work from Home.Experience Required : 7 - 13 Years. Design, develop, and maintain SQL Server database...Show more
    Last updated: 21 days ago • Promoted
    Caliber Technologies - Data Analyst - Python / SQL

    Caliber Technologies - Data Analyst - Python / SQL

    CALIBER TECHNOLOGIES PRIVATE LIMITED • Hyderabad
    Description : Key Responsibilities : - Work closely with product managers and analytics leads to translate b...Show more
    Last updated: 30+ days ago • Promoted
    PL / SQL Developer ( REMOTE )

    PL / SQL Developer ( REMOTE )

    ADV TECHMINDS • Hyderabad, Telangana, India
    Remote
    Releavant exp min 5+ years experience as an Oracle PL / SQL Developer.Strong proficiency in PL / SQL development in Oracle environments. Proven expertise in writing complex stored procedures, functions,...Show more
    Last updated: 30+ days ago • Promoted
    PL / SQL Developer

    PL / SQL Developer

    Tata Consultancy Services • Hyderabad, Telangana, India
    Secondary Skills : Linux Shell Scripting.Design, model, develop, and deploy Oracle DB objects including tables, views, triggers, stored procedures. Self-coordinate with CIO and Business stakeholders...Show more
    Last updated: 30+ days ago • Promoted
    MongoDB Developer - Database Integration

    MongoDB Developer - Database Integration

    Akshaya IT Business solutions • Hyderabad
    Description : Job Title : MongoDB Developer Location : Hyderabad, Bangalore Show more
    Last updated: 30+ days ago • Promoted
    Data Analyst - Python & SQL

    Data Analyst - Python & SQL

    Incanus Technologies Private Limited • Hyderabad
    Description : About the Role : Join an innovative team leveraging data to drive business decisions! We...Show more
    Last updated: 16 days ago • Promoted
    Indium Software - Data Analyst - SQL / Python

    Indium Software - Data Analyst - SQL / Python

    INDIUM SOFTWARE • Hyderabad
    Role : Data Analyst Location : : 2.Notice Period : Immediate or <15 Days.Job Description : ...Show more
    Last updated: 30+ days ago • Promoted
    PL-SQL Developer - Database Integration

    PL-SQL Developer - Database Integration

    Akshaya IT Business solutions • Hyderabad
    Description : Job Title : PL- SQL Developer Location : Hyderabad, Bangalore Show more
    Last updated: 30+ days ago • Promoted
    Aggne - Database Developer - Snowflake DB

    Aggne - Database Developer - Snowflake DB

    Aggne Global IT Services Private Limited • Hyderabad
    Job Summary : We are seeking a skilled and detail-oriented Database Developer with 46 years of experience to join our data team. The ideal candidate should hav...Show more
    Last updated: 18 days ago • Promoted
    PL / SQL Developer

    PL / SQL Developer

    People Prime Worldwide • Hyderabad, IN
    Our client is a Palo Alto–based AI infrastructure and talent platform founded in 2018.It helps companies connect with remote software developers using AI-powered vetting and matching technology.Ori...Show more
    Last updated: 3 hours ago • Promoted • New!
    27-Nov-25_virtual Drive_databricks With Python

    27-Nov-25_virtual Drive_databricks With Python

    Tata Consultancy Services • Hyderabad, Republic Of India, IN
    Currently, looking for an experienced Individual, worked on.Data-Bricks, Data Lake with Python.Kindly reach-out to me if you inherit these tools. Extensive expertise in designing and implementing da...Show more
    Last updated: 4 days ago • Promoted
    Mysql Dba

    Mysql Dba

    Tata Consultancy Services • Hyderabad, Republic Of India, IN
    Location : Bangalore, Hyderabad, Noida, Pune.Installation, configuration, and maintenance of MySQL database servers and instances. Managing database access, security, and user permissions.Performing ...Show more
    Last updated: 30+ days ago • Promoted
    MSBI Developer

    MSBI Developer

    Tata Consultancy Services • Hyderabad, Telangana, India
    Noida, Pune, Hyderabad, and Bangalore.We are seeking a skilled and detail-oriented.The ideal candidate will be responsible for designing, developing, and maintaining robust ETL solutions, data mode...Show more
    Last updated: 11 days ago • Promoted
    Macquarie - Data Lead - Python / SQL

    Macquarie - Data Lead - Python / SQL

    Macquarie • Hyderabad
    Description : Macquarie Asset Management (MAM) is a global asset manager, integrated across public and private markets.We focus on generating positive outcomes for o...Show more
    Last updated: 4 days ago • Promoted
    SQL Database Solutions Specialist

    SQL Database Solutions Specialist

    ViaPlus • Hyderabad, Republic Of India, IN
    ViaPlus is actively searching for a passionate, innovative, and results-oriented DB technical professional with a profound commitment to success to join our database development team.In this role, ...Show more
    Last updated: 18 days ago • Promoted
    Accellor - Senior Snowflake Data Engineer - Python / SQL

    Accellor - Senior Snowflake Data Engineer - Python / SQL

    Accellor • Hyderabad
    Description : As a Senior Data Engineer specializing in Snowflake, you will be responsible for designing, developing, a...Show more
    Last updated: 30+ days ago • Promoted