Integration Engineer

Our client, a leading investment management firm, is seeking a Senior Real Estate Integration and Reporting Consultant to join a specialized team focused on assessing and optimizing technology capabilities across multiple real estate business units. This role will play a critical part in evaluating applications, data architectures, integrations, and reporting systems following recent acquisitions and organic growth. The successful candidate will document the current technology landscape, identify consolidation opportunities, define integration requirements, and deliver SQL-based solutions while supporting broader Real Estate Technology initiatives.Responsibilities:Participate in comprehensive discovery sessions to document application ecosystems, data flows, integration patterns, and reporting capabilities across acquired and existing real estate business operationsIdentify and map source and target systems, data feeds, interfaces, reports, system owners, end users, manual workarounds, and undocumented technical dependenciesTranslate business needs into actionable artifacts including functional requirements, technical specifications, source-to-target mappings, feed specifications, report specifications, and detailed acceptance criteriaDevelop, enhance, and maintain SQL extracts, data transformations, reconciliation queries, data-quality validation scripts, system interfaces, and operational reportsEvaluate existing enterprise technology capabilities and document tactical solutions with clearly defined transition plans and retirement criteria before recommending new toolsSupport system consolidation planning by analyzing overlapping capabilities, mapping dependencies, identifying migration risks, and defining logical implementation phasesDesign, prepare, and execute integration testing, regression testing, and user-acceptance testing protocols; investigate data discrepancies and document root-cause analysisProvide ongoing support for business-as-usual priorities including SQL development work, feed troubleshooting, ad-hoc reporting requests, testing coordination, data reconciliation, and production issue resolutionThe ideal candidate:Advanced proficiency in SQL Server database administration and T-SQL development with demonstrated ability to write complex queries, stored procedures, and optimization techniquesProven experience documenting data feeds, database interfaces, REST/SOAP APIs, scheduled ETL processes, or file-based integration patternsStrong background producing detailed business requirements documents, interface specifications, source-to-target mapping documentation, report specifications, and comprehensive test scenariosDemonstrated ability facilitating discovery workshops with business stakeholders and technical teams, converting ambiguous requirements into documented decisions and actionable next stepsExperience with operational reporting, financial reporting, management reporting, or investment reporting including data quality frameworks and reconciliation processesExceptional documentation skills, communication abilities, analytical problem-solving capabilities, and knowledge-transfer aptitudePreferred: Commercial real estate, investment management, or capital markets lending domain experiencePreferred: Hands-on experience with Databricks, Azure data platform services, Power BI, or SQL Server Reporting Services (SSRS)Preferred: Background supporting corporate acquisitions, system integration projects, data migrations, or platform consolidation initiativesPreferred: Familiarity with real estate or investment management platforms such as property management systems, deal management tools, portfolio analytics platforms, or financial planning applicationsReasons to love it:Opportunity to work on high-impact integration and consolidation projects within a dynamic real estate investment organizationExposure to complex, enterprise-scale technology ecosystems spanning multiple business units and acquired companiesCollaborative environment working alongside business stakeholders, technical teams, and senior leadershipHands-on role combining strategic assessment work with tactical solution deliveryChance to shape the future technology landscape for real estate operations through thoughtful consolidation and optimizationProfessional development opportunities working with modern data platforms, business intelligence tools, and industry-leading real estate systemsMeaningful contribution to post-acquisition integration success and long-term platform rationalization strategy