Database Analyst

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 client's databases, software platforms, and acquisitions team. You will be responsible for ensuring that information is accurate, well-structured, and reliably flows between systems.

The client's 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 client's 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

✅ Strong 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

---