The Role
Hands-on Database Analyst responsible for extracting, transforming, validating, and governing financial and real estate data across multiple databases and platforms. The role includes SQL optimization, Python-based automation, data-flow mapping, documentation, data-quality standards, curated datasets for workflows and interfaces, and direct support for acquisitions teams. Candidates will work remotely with US stakeholders and finance analysts.
Summary Generated by Built In
Company Overview:
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.
Roles & 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)
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*
Real estate or commercial real estate data experience (deal pipelines, loan servicing, property data)
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
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
Skills Required
- 5-8 years of experience in database analyst, data analyst, or database administrator roles
- Expert SQL skills, including complex joins, data modeling, and query optimization on large relational datasets
- At least 5 years of hands-on Python experience with pandas, NumPy, or similar technologies for data manipulation and automation
- Working comfort with financial data, including loan, deal, or investment datasets
- Experience documenting processes and establishing data-quality or governance standards
- Strong written and spoken English for direct client exposure to US stakeholders
- Ability to work independently in a fully remote setup with partial overlap with US business hours
- Real estate or commercial real estate data experience
- Familiarity with deal-management platforms such as Dealpath
- Data warehousing experience, including schema design and ETL/ELT
- Experience supporting dashboards or lightweight user interfaces built on curated datasets
- Availability to join within 3-4 weeks
Similar Jobs
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Gallagher & Mohan is a real estate knowledge process outsourcing (KPO) and professional services firm serving real estate developers, investment funds, and property management companies. Founded by commercial real estate private-equity veterans Doug Gallagher and Arshey Mohan, it provides accounting, financial analysis, statement preparation, lease administration, asset management, and other back-office services to clients across international markets, with a focus on cost-efficient offshore operations.
