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 operations
• Identify and map source and target systems, data feeds, interfaces, reports, system owners, end users, manual workarounds, and undocumented technical dependencies
• Translate business needs into actionable artifacts including functional requirements, technical specifications, source-to-target mappings, feed specifications, report specifications, and detailed acceptance criteria
• Develop, enhance, and maintain SQL extracts, data transformations, reconciliation queries, data-quality validation scripts, system interfaces, and operational reports
• Evaluate existing enterprise technology capabilities and document tactical solutions with clearly defined transition plans and retirement criteria before recommending new tools
• Support system consolidation planning by analyzing overlapping capabilities, mapping dependencies, identifying migration risks, and defining logical implementation phases
• Design, prepare, and execute integration testing, regression testing, and user-acceptance testing protocols; investigate data discrepancies and document root-cause analysis
• Provide ongoing support for business-as-usual priorities including SQL development work, feed troubleshooting, ad-hoc reporting requests, testing coordination, data reconciliation, and production issue resolution

The ideal candidate:

• Advanced proficiency in SQL Server database administration and T-SQL development with demonstrated ability to write complex queries, stored procedures, and optimization techniques
• Proven experience documenting data feeds, database interfaces, REST/SOAP APIs, scheduled ETL processes, or file-based integration patterns
• Strong background producing detailed business requirements documents, interface specifications, source-to-target mapping documentation, report specifications, and comprehensive test scenarios
• Demonstrated ability facilitating discovery workshops with business stakeholders and technical teams, converting ambiguous requirements into documented decisions and actionable next steps
• Experience with operational reporting, financial reporting, management reporting, or investment reporting including data quality frameworks and reconciliation processes
• Exceptional documentation skills, communication abilities, analytical problem-solving capabilities, and knowledge-transfer aptitude
• Preferred: Commercial real estate, investment management, or capital markets lending domain experience
• Preferred: 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 initiatives
• Preferred: Familiarity with real estate or investment management platforms such as property management systems, deal management tools, portfolio analytics platforms, or financial planning applications

Reasons to love it:

• Opportunity to work on high-impact integration and consolidation projects within a dynamic real estate investment organization
• Exposure to complex, enterprise-scale technology ecosystems spanning multiple business units and acquired companies
• Collaborative environment working alongside business stakeholders, technical teams, and senior leadership
• Hands-on role combining strategic assessment work with tactical solution delivery
• Chance to shape the future technology landscape for real estate operations through thoughtful consolidation and optimization
• Professional development opportunities working with modern data platforms, business intelligence tools, and industry-leading real estate systems
• Meaningful contribution to post-acquisition integration success and long-term platform rationalization strategy