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