Integration Engineer

Agility Partners; Charlotte (NC); On-site; USD 120,000 - 170,000; Full time

Job summary

Agility Partners seeks a Senior Real Estate Integration and Reporting Consultant to optimize technology across real estate units. You will evaluate applications, data architectures, integrations, and reporting systems after acquisitions and growth.

The role requires documenting the landscape, identifying consolidation opportunities, defining integration requirements, and delivering SQL-based solutions within Real Estate Tech initiatives.

Qualifications

• Advanced proficiency in SQL Server database administration and T-SQL development.
• Experience documenting data feeds, database interfaces, REST/SOAP APIs, ETL processes.
• Strong background producing interface/requirements documents and test scenarios.

Responsibilities

• Document application ecosystems, data flows, and reporting capabilities across real estate operations.
• Identify and map source/target systems, data feeds, interfaces and dependencies.
• Translate business needs into functional requirements, technical specs, and mappings.
• Develop, enhance, and maintain SQL extracts, transformations, and data-quality scripts.
• Evaluate capabilities and document transition plans before recommending new tools.
• Support consolidation planning with migration risk analysis and phased implementation.
• Design and execute integration, regression, and user acceptance tests.
• Provide ongoing SQL development support and ad-hoc reporting.

Skills

SQL

T-SQL

Data integration

Data analysis

Documentation

Tools

Databricks

Azure data platform

Power BI

SSRS

Job description

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