About the role
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 datasetsData validation — audit datasets for accuracy and completeness; find and fix discrepancies at the sourceData flows — map how data moves from one system or platform to another and keep it flowing correctly end to endSOPs — document how data is entered, moved, checked, and maintained so processes are repeatable and auditableData governance — establish and maintain standards for how data is structured, managed, and controlledSystems and UI — build fluency with the client's software platforms and their front ends; support interface buildouts on top of the organized dataAcquisitions support — connect data from various platforms and systems to acquisition-related workflows, delivering structured outputs the deal team can act onProcess 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 positionExpert SQL: complex joins, data modelling, and query optimization on large relational datasets5+ years of hands-on experience with Python and related technologies (pandas, NumPy, or similar) for data manipulation and automationWorking comfort with financial data — loan, deal, or investment datasetsTrack record of documenting processes and setting data-quality or governance standardsStrong written and spoken English — this is a client-facing role with direct exposure to US stakeholdersSelf-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 datasetsJob Details:
Location: Remote – India💼 Type: Full-time | 40 hrs/week🎯 Experience: 5–8 years🕐 Availability: Candidates who can join within 3–4 weeks preferred