Database Analyst

Gallagher & Mohan Pvt Ltd.; New Delhi; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Gallagher & Mohan Pvt Ltd. is building a data-extraction and management service for a US real estate client. You will sit between databases, software platforms, and acquisitions teams to clean and organize datasets for analysis and UI builds.

The role is a hands-on, solo contributor with direct client exposure and collaboration with finance analysts. Expect strong SQL, Python, and data governance, plus remote work with US-hour overlaps.

Qualifications

• 5-8 years in database analyst, data analyst, or database administrator roles.
• Expert SQL: complex joins, data modelling, and query optimization on large relational datasets.
• 5+ years of hands-on experience with Python and related technologies (pandas, NumPy, or similar) for data manipulation and automation.
• Working comfort with financial data - loan, deal, or investment datasets.
• Track record of documenting processes and setting data-quality or governance standards.
• Strong written and spoken English - this is a client-facing role with direct exposure to US stakeholders.
• Self-directed in a fully remote setup, with partial overlap with US business hours for key meetings.

Responsibilities

• SQL and data management - write and optimize SQL to extract, transform, and analyse data across multiple databases and datasets
• Data validation - audit datasets for accuracy and completeness; find and fix discrepancies at the source
• Data flows - map how data moves from one system or platform to another and keep it flowing correctly end to end
• SOPs - document how data is entered, moved, checked, and maintained so processes are repeatable and auditable
• Data governance - establish and maintain standards for how data is structured, managed, and controlled
• Systems and UI - build fluency with the client's software platforms and their front ends; support interface buildouts on top of the organized data
• Acquisitions support - connect data from various platforms and systems to acquisition-related workflows, delivering structured outputs the deal team can act on
• Process improvement - identify opportunities to make in-house data processes more efficient or automated (Python scripting, scheduled jobs)

Skills

SQL

Python

Data analysis

Data governance

Data validation

English proficiency

Remote/self-directed

Tools

Dealpath

Job description

We are a technology and data services firm working with US-based real estate investment clients. We are standing up a new data-extraction and management service for a client's acquisitions business - and this role is the anchor hire for that service.

Role Overview:

You will sit between the client's databases, software platforms, and acquisitions team, making sure information is accurate, well-structured, and flowing correctly between systems. The client's data lives across deal-management platforms and multiple loan databases; your job is to organize these disparate datasets into clean, reliable, query-ready structures that acquisitions workflows - and potentially new user interfaces - can be built on.

This is a hands-on, individual-contributor role with direct client exposure. Day-to-day, you will work alongside our finance analyst team.

SQL and data management - write and optimize SQL to extract, transform, and analyse data across multiple databases and datasets

Data validation - audit datasets for accuracy and completeness; find and fix discrepancies at the source

Data flows - map how data moves from one system or platform to another and keep it flowing correctly end to end

SOPs - document how data is entered, moved, checked, and maintained so processes are repeatable and auditable

Data governance - establish and maintain standards for how data is structured, managed, and controlled

Systems and UI - build fluency with the client's software platforms and their front ends; support interface buildouts on top of the organized data

Acquisitions support - connect data from various platforms and systems to acquisition-related workflows, delivering structured outputs the deal team can act on

Process improvement - identify opportunities to make in-house data processes more efficient or automated (Python scripting, scheduled jobs)

Must-Haves*

5-8 years in database analyst, data analyst, or database administrator roles - this is not an entry-level position

Expert SQL: complex joins, data modelling, and query optimization on large relational datasets

5+ years of hands-on experience with Python and related technologies (pandas, NumPy, or similar) for data manipulation and automation

Working comfort with financial data - loan, deal, or investment datasets

Track record of documenting processes and setting data-quality or governance standards

Strong written and spoken English - this is a client-facing role with direct exposure to US stakeholders

Self-directed in a fully remote setup, with partial overlap with US business hours for key meetings

Nice-to-Haves*

Familiarity with deal-management platforms (e.g., Dealpath or similar)

Data warehousing experience (schema design, ETL/ELT)

Experience supporting dashboards or lightweight UIs built on curated datasets

Location: Remote - India

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

Required Skills

Work Consistency SOP creation salesforce Technical Skills real estate python SQL