The Role
Build and maintain reliable data structures across deal-management platforms and loan databases. Write and optimize SQL, use Python for automation, validate and govern data, map end-to-end data flows, document SOPs, and support acquisition workflows and lightweight interfaces. This client-facing, fully remote role requires collaboration with finance analysts and US stakeholders, plus opportunities to improve and automate data processes.
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
- 5+ years of hands-on Python experience, including 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
- 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 or similar
- Data warehousing experience, including schema design and ETL/ELT
- Experience supporting dashboards or lightweight user interfaces built on curated datasets
Am I A Good Fit?
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.
