Herbert Smith Freehills Kramer

Data Systems Analyst

New York · Full-time

Sponsorship not specified$135k-$160kDetected 28 days ago

PythonC#PowerShellSQLAzureLinuxRESTOAuthIncident ResponseCRMAuditingERPHRISCommunication

About the role

Responsible for mapping and transforming legal practice data to enable downstream processes and analytics.
Define and coordinate testing activities, including test planning, test case development, and quality assurance oversight.
Install, upgrade, and administer integration platforms and related components.

Provide 24x7 support for client and user‑facing products and services with a strong focus on data quality, system reliability, and seamless integrations.
Design and build custom data integrations using Intapp Integrate (Integration Builder), leveraging Intapp APIs, data models, and workflow tools.
Develop and execute SQL queries for data extraction, reconciliation, quality checks, troubleshooting, auditing, and performance validation, with strong competency in joining complex datasets and supporting integration logic through SQL.
Support automation and custom connector development through scripting-preferably using PowerShell, Python, or C#-to enable pre‑ and post‑processing operations and streamline data workflows.
Deploy, maintain, and troubleshoot core business applications, including configuration, reporting, and system optimization.
Develop, analyze, prioritize, and document requirement specifications, data mappings, diagrams, and process flows.
Manage system setup, configuration, and environment preparation.
Collaborate with internal and external stakeholders to define project scope, system objectives, and detailed requirements.
Create and maintain comprehensive documentation for system processes, workflows, and procedures.
Implement maintenance routines, monitor system performance, collect operational metrics, and resolve reported issues.

3-5+ years of experience delivering enterprise‑grade system integrations
Solid knowledge of core data‑integration concepts, such as:
Experience supporting production integrations with a focus on stability and performance, including:
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
Familiarity with relational and dimensional data‑modeling techniques
Mandatory experience on Integration Builder
Proficient in SQL including querying, joins, and basic performance tuning for validation, reconciliation, and issue resolution
Strong background in integration delivery and operational support, including:
Deep understanding of REST APIs, authentication methods (OAuth2, API keys, token-based auth), and webhooks
Skilled in working with JSON/XML, data mapping, transformations, and schema validation
Error handling, dead‑letter queues, monitoring, and alerting
Scheduling, incremental data loads, and change tracking
Managing SLAs, incident response, root‑cause analysis, and long‑term problem management

Exact compensation may vary based on skills and experience and salary range is $135,000 - $160,000.

of race, color, creed, religion, sex, national origin, veteran status, mental or physical handicap or disability, age, citizenship status, alienage, ancestry, marital status, sexual orientation, gender identity, or expre

This listing is sourced directly from Herbert Smith Freehills Kramer's careers page and normalized into a canonical job model.