Senior Analyst – MIS

4 hours ago

Hyderabad, Telangana, India Cantor Fitzgerald Full time ₹ 8,00,000 - ₹ 24,00,000 per year
Description

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.

Responsibilities

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.
Qualifications

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

  • MIS Analyst

    1 week ago

    Hyderabad, Telangana, India Tanla Solutions Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    MIS Analyst MIS Analyst LocationHyderabad, Telangana IN DepartmentProduct & Engineering Job Role‍We are seeking a detail-oriented MIS Analyst to join our team. The ideal candidate will have strong analytical skills, a good grasp of telecom domain metrics, and the ability to transform data into actionable insights. What you'll be responsible for?‍Report...

  • MIS Analyst

    1 week ago

    Hyderabad, Telangana, India Tanla Platforms Limited Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    We are seeking a detail-oriented MIS Analyst to join our team. The ideal candidate will have stronganalytical skills, a good grasp of telecom domain metrics, and the ability to transform data intoactionable insights.You'll be Responsible for:Report Automation: Develop and maintain automated reports using SQL, Advanced Excel, and other tools to streamline...

  • MIS Data Analyst

    6 days ago

    Hyderabad, Telangana, India Moderate Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Job Summary:We are seeking a highly analytical and detail-oriented Data Analyst C MIS Executive to join our team in Hyderabad. The ideal candidate will have hands-on experience in managing large-scale data, reporting, and analytics with strong expertise in MS Excel, Google Sheets, and Power BI. Experience in eCommerce operations, inventory management, and...

  • MIS Data Quality Analyst

    2 days ago

    Hyderabad, Telangana, India Innova ESI Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Role: MIS Data Quality AnalystExperience: 2 to 5 YearsLocation: HyderabadNotice: Immediate Joiners OnlyJob Summary:We are seeking aData Quality Analystto ensure the accuracy, consistency, and reliability of e-commerce data through robust QA checks and process improvements. The role involves executing quality spot checks, maintaining QA tracking, identifying...

  • MIS Data Analyst

    3 weeks ago

    Hyderabad, Telangana, India, Telangana Moderate Full time

    Job Summary:We are seeking a highly analytical and detail-oriented Data Analyst C MIS Executive to join our team in Hyderabad. The ideal candidate will have hands-on experience in managing large-scale data, reporting, and analytics with strong expertise in MS Excel, Google Sheets, and Power BI. Experience in eCommerce operations, inventory management, and...

  • MIS Executive

    1 week ago

    Hyderabad, Telangana, India Tanla Platforms Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Job DescriptionRole: MIS AnalystLocation: HyderabadAbout the Role: We are seeking a detail-oriented MIS Analyst to join our team. The ideal candidate will have strong analytical skills, a good grasp of telecom domain metrics, and the ability to transform data into actionable insights.You'll be Responsible for:Report Automation: Develop and maintain automated...

  • MIS Data Analyst

    2 weeks ago

    Hyderabad, Telangana, India Innopark Private Limited Full time ₹ 6,00,000 - ₹ 7,20,000 per year

    Job SummaryWe are seeking a highly analytical and detail-oriented Data Analyst & MIS Executive to join our team in Hyderabad. The ideal candidate will have hands-on experience in managing large-scale data, reporting, and analytics with strong expertise in MS Excel, Google Sheets, and Power BI. Experience in eCommerce operations, inventory management, and GST...

  • Senior Financial Analyst

    1 week ago

    Hyderabad, Telangana, India Ankura Homes Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Location: Mokila, HyderabadWorking Days: Monday to SaturdayAbout Ankura HomesAnkura Homesis one of the fastest-growing real estate companies with a strong portfolio of residential projects. With a commitment to quality, innovation, and customer satisfaction, we continue to redefine the housing experience for our customers. We are now expanding our Finance &...

  • Mis Executive

    1 week ago

    Hyderabad, Telangana, India Tanla Platforms Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    We are seeking a detail-oriented MIS Analyst to join our team. The ideal candidate will have strong analytical skills, a good grasp of telecom domain metrics, and the ability to transform data into actionable insights.You'll be Responsible for:Report Automation: Develop and maintain automated reports using SQL, Advanced Excel, and other tools to streamline...

  • Mis Executive

    2 days ago

    Hyderabad, Telangana, India Spy Health Full time ₹ 4,00,000 - ₹ 6,00,000 per year

    Company DescriptionSpy Health is a US-based healthcare revenue cycle management company specializing in providing exceptional back-office support to healthcare providers and billing companies. By enhancing efficiency in Revenue Cycle Management (RCM), Spy Health enables clients to focus on their strategic priorities and deliver the highest standards of care....