C
C

Database Analyst

csf
Mumbai, MH, IN 
+2 more
Full-timeRemote5 - 8 yrs
1d ago2 views0 clicked apply
Build, Review & Tailor Your Resume with AI (Create an ATS-friendly resume, improve it, and tailor it for this job instantly.)
Company Overview:
Gallagher & Mohan is a distinguished firm specializing in delivering world-class financial analysis, marketing expertise, and accounting support tailored to the real estate sector. We serve an exclusive clientele of private equity investors, developers, fund managers, brokers, and other industry leaders. Renowned for our commitment to excellence, clear communication, and strong work ethic, we seamlessly integrate with our clients’ teams to create long-term value. Our portfolio spans diverse real estate transactions—from multifamily apartment communities to large-scale office towers across the United States and European markets, with deal sizes typically ranging from $25 million to over $500 million USD.


Role Overview:
As a Database Analyst, you will sit at the intersection of the client's databases, software platforms, and acquisitions team. You will be responsible for ensuring that information is accurate, well-structured, and reliably flows between systems.
The client's data is distributed across deal-management platforms and multiple loan databases. Your role will be to bring these disparate datasets together into clean, reliable, query-ready structures that can support acquisitions workflows and potentially new user interfaces.
This is a hands-on individual-contributor role with direct client exposure. You will work closely with our finance analyst team and collaborate with US-based stakeholders.

Roles & Responsibilities:

SQL & Data Management

  • Write, optimize, and maintain complex SQL queries across multiple databases and datasets.
  • Extract, transform, and analyze large relational datasets.
  • Design and maintain reliable data structures that support business and acquisitions workflows.
  • Identify opportunities to improve query performance and data efficiency.

Data Validation & Quality

  • Audit datasets for accuracy, completeness, and consistency.
  • Identify discrepancies and investigate issues back to their source.
  • Implement processes and checks to improve data quality.
  • Establish repeatable standards for maintaining reliable datasets.

Data Flows & Systems

  • Map how data moves between databases, platforms, and business processes.
  • Monitor and maintain end-to-end data flows.
  • Develop a strong working understanding of the client's software platforms and their front ends.
  • Support interface and UI buildouts using curated, structured datasets.

Documentation & Governance

  • Create and maintain SOPs covering how data is entered, transferred, validated, and maintained.
  • Establish and maintain data-structure, quality, and governance standards.
  • Ensure processes are documented, repeatable, and auditable.

Acquisitions Support

  • Connect data from multiple platforms and systems to acquisition-related workflows.
  • Produce structured, query-ready outputs that enable the acquisitions team to make informed decisions.
  • Work closely with finance analysts to understand business requirements and translate them into reliable data solutions.

Process Improvement & Automation

  • Identify opportunities to improve internal data processes.
  • Automate repetitive workflows using Python.
  • Develop scripts and scheduled jobs to improve efficiency, reliability, and scalability.
What We Are Looking For:
5–8 years of experience in database analysis, data analysis, or database administration
✅ Expert-level SQL skills, including complex joins, data modeling, and query optimization
✅ Strong Python skills for data manipulation and automation, particularly pandas or similar libraries
✅ Experience working with financial data such as loans, deals, or investments
✅ Strong understanding of data quality, documentation, and governance
✅ Excellent written and spoken English
✅ Ability to work independently in a fully remote environment with partial US-hours overlap


Desired Qualifications:
Real estate or commercial real estate data experience
⭐ Experience with deal-management platforms such as Deal path or similar tools
⭐ Data warehousing, schema design, ETL/ELT experience
⭐ 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



RESUME BUILDER

Build Your Resume for Free in Minutes

Create ATS-friendly resumes with modern templates and AI-powered suggestions.

ATS Friendly
Rohan SharmaMarketing Manager

Professional Summary

Experience

ATS Friendly
RESUME REVIEW

Get Your Resume
Reviewed for Free

Discover missing skills, ATS issues, and get personalized suggestions to improve your chances.

Secure
92%
ATS Score
Review SummaryGood keywordsWell-structuredAdd metrics
Improve your score with the suggestions.
RESUME TAILORING

Tailor Your Resume for This Job

Match your resume to this job's requirements in one click.

96%Match