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, transparent 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 t