Database Analyst

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