Company Overview:

Gallagher & Mohan is a distinguished firm specializing in delivering world-class financial analysis, marketing expertise, and accounting support tailored to the real estate sector. We serve an exclusive clientele of private equity investors, developers, fund managers, brokers, and other industry leaders. Renowned for our commitment to excellence, clear communication, and strong work ethic, we seamlessly integrate with our clients teams to create long-term value. Our portfolio spans diverse real estate transactions-from multifamily apartment communities to large-scale office towers across the United States and European markets, with deal sizes typically ranging from $25 million to over $500 million USD.

Role Overview:

As a Database Analyst, you will sit at the intersection of the clients databases, software platforms, and acquisitions team. You will be responsible for ensuring that information is accurate, well-structured, and reliably flows between systems.

The clients data is distributed across deal-management platforms and multiple loan databases. Your role will be to bring these disparate datasets together into clean, reliable, query-ready structures that can support acquisitions workflows and potentially new user interfaces.

This is a hands-on individual-contributor role with direct client exposure. You will work closely with our finance analyst team and collaborate with US-based stakeholders.

Roles & Responsibilities:

SQL & Data Management

- Write, optimize, and maintain complex SQL queries across multiple databases and datasets.
- Extract, transform, and analyze large relational datasets.




- Design and maintain reliable data structures that support business and acquisitions workflows.
- Identify opportunities to improve query performance and data efficiency.

Data Validation & Quality
- Audit datasets for accuracy, completeness, and consistency.
- Identify discrepancies and investigate issues back to their source.
- Implement processes and checks to improve data quality.
- Establish repeatable standards for maintaining reliable datasets.

Data Flows & Systems
- Map how data moves between databases, platforms, and business processes.
- Monitor and maintain end-to-end data flows.
- Develop a strong working understanding of the clients software platforms and their front ends.
- Support interface and UI buildouts using curated, structured datasets.

Documentation & Governance
- Create and maintain SOPs covering how data is entered, transferred, validated, and maintained.
- Establish and maintain data-structure, quality, and governance standards.
- Ensure processes are documented, repeatable, and auditable.

Acquisitions Support
- Connect data from multiple platforms and systems to acquisition-related workflows.
- Produce structured, query-ready outputs that enable the acquisitions team to make informed decisions.
- Work closely with finance analysts to understand business requirements and translate them into reliable data solutions.





Process Improvement & Automation
- Identify opportunities to improve internal data processes.
- Automate repetitive workflows using Python.
- Develop scripts and scheduled jobs to improve efficiency, reliability, and scalability.

What We Are Looking For:

5-8 years of experience in database analysis, data analysis, or database administration

Expert-level SQL skills, including complex joins, data modeling, and query optimization

Solid Python skills for data manipulation and automation, particularly pandas or similar libraries

Experience working with financial data such as loans, deals, or investments

Strong understanding of data quality, documentation, and governance

Excellent written and spoken English

Ability to work independently in a fully remote environment with partial US-hours overlap

Desired Qualifications:

Real estate or commercial real estate data experience

Experience with deal-management platforms such as Deal path or similar tools

Data warehousing, schema design, ETL/ELT experience

Experience supporting dashboards or lightweight UIs built on curated datasets

Job Details:

Location: Remote - India

Type: Full-time | 40 hrs/week

Experience: 5-8 years

Availability: Candidates who can join within 3-4 weeks preferred

Required Skills

Work Consistency SOP creation salesforce Technical Skills real estate python SQL

Disclaimer: This job description has been sourced from a public domain and may have been modified by Naukri.com to improve clarity for our users. We encourage job seekers to verify all details directly with the employer via their official channels before applying.

📌 Database Analyst (New Delhi)
🏢 Gallagher & Mohan
📍 New Delhi