Data Integration & Systems Engineer

Herbert Smith Freehills Kramer; New York (NY); On-site; USD 135,000 - 160,000; Full time

Job summary

Herbert Smith Freehills Kramer seeks a skilled data integration engineer to design, deploy, and optimize enterprise-grade system integrations using Intapp Integrate. The role focuses on data quality, reliability, and seamless workflows across enterprise systems.

You will develop SQL queries, automate tasks via PowerShell/Python/C#, and collaborate with stakeholders to translate requirements into technical solutions, ensuring robust security and performance.

Qualifications

• Mandatory experience on Integration Builder.
• 3-5+ years of experience delivering enterprise-grade system integrations.
• Proficient in SQL including querying, joins, and basic performance tuning
• Strong background in integration delivery and operational support, including REST APIs, authentication methods (OAuth2, API keys, token-based auth), and webhooks.
• Skilled in working with JSON/XML, data mapping, transformations, and schema validation.
• Solid knowledge of core data-integration concepts, such as: error handling, dead-letter queues, monitoring, and alerting.
• Scheduling, incremental data loads, and change tracking.
• Experience supporting production integrations with a focus on stability and performance, including: managing SLAs, incident response, root-cause analysis, and long-term problem management.
• Proven ability to understand business requirements and translate them into effective technical solutions.
• Strong knowledge of application setup principles and best practices.
• Hands-on experience installing, configuring, documenting, testing, training, and deploying new applications and systems.
• Excellent analytical and problem-solving skills.
• Advanced command of SQL and SQL Server toolsets.
• In-depth understanding of database security, backup/recovery, and performance monitoring.
• Familiarity with relational and dimensional data-modeling techniques.
• Scripting skills in PowerShell and Unix shell.
• Exposure to SSAS, SSIS, and SSRS.
• Exceptional written and verbal communication skills
• High level of attention to detail

Responsibilities

• Design, implement, and upgrade information systems to meet evolving business and user needs.
• Develop, analyze, prioritize, and document requirement specifications, data mappings, diagrams, and process flows.
• Translate complex technical specifications into clear, easy-to-understand non-technical requirements.
• Develop and execute SQL queries for data extraction, reconciliation, quality checks, troubleshooting, auditing, and performance validation.
• Deploy, maintain, and troubleshoot core business applications, including configuration, reporting, and system optimization.
• Create and maintain comprehensive documentation for system processes, workflows, and procedures.
• Monitor and optimize integration system performance, providing recommendations to enhance scalability and efficiency.

Skills

SQL queries

Data integration

REST APIs

PowerShell

Python

Tools

Intapp Integrate

SQL Server

SSAS

SSIS

SSRS

Active Directory/Azure AD

Job description

Herbert Smith Freehills Kramer seeks a skilled data integration engineer to design, deploy, and optimize enterprise-grade system integrations using Intapp Integrate. The role focuses on data quality, reliability, and seamless workflows across enterprise systems.

You will develop SQL queries, automate tasks via PowerShell/Python/C#, and collaborate with stakeholders to translate requirements into technical solutions, ensuring robust security and performance.