LOG IN
SIGN UP
Canary Wharfian - Online Investment Banking & Finance Community.
Sign In
or continue with e-mail and password
Forgot password?
Don't have an account?
Create an account
or continue with e-mail and password
By signing up, you agree to our Terms & Conditions and Privacy Policy.

Data Systems Analyst

ExperiencedNo visa sponsorship

Posted 3 days ago

No clicks

**Data Systems Analyst**: Support 24/7 client services, mapping legal data, and building custom integrations using Intapp Integrate. Design and execute SQL queries, automate tasks, and manage system performance. Expertise in REST APIs, JSON, XML, and SQL Server; experience with mission-critical enterprise systems. 3-5+ years in enterprise-grade system integrations.

Compensation
$135,000 – $160,000 USD

Currency: $ (USD)

City
New York City
Country
United States

Full Job Description

The Opportunity

Key Responsibilities:

Provide 24x7 support for client and userfacing products and services with a strong focus on data quality, system reliability, and seamless integrations. Responsible for mapping and transforming legal practice data to enable downstream processes and analytics.

Design and build custom data integrations using Intapp Integrate (Integration Builder), leveraging Intapp APIs, data models, and workflow tools. Demonstrate expertise integrating with missioncritical enterprise systems such as Active Directory/Azure AD, HRIS platforms, DMS, CRM, Finance/ERP, matter management, billing/time systems, and data warehouses.

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 scriptingpreferably using PowerShell, Python, or C#to enable pre and postprocessing operations and streamline data workflows.

Deploy, maintain, and troubleshoot core business applications, including configuration, reporting, and system optimization.

Collaborate with internal and external stakeholders to define project scope, system objectives, and detailed requirements.

Develop, analyze, prioritize, and document requirement specifications, data mappings, diagrams, and process flows.

Translate complex technical specifications into clear, easy-to-understand nontechnical requirements.

Manage system setup, configuration, and environment preparation.

Define and coordinate testing activities, including test planning, test case development, and quality assurance oversight.

Create and maintain comprehensive documentation for system processes, workflows, and procedures.

Implement maintenance routines, monitor system performance, collect operational metrics, and resolve reported issues.

Design, implement, and upgrade information systems to meet evolving business and user needs.

Perform performance tuning and optimization of integration systems.

Install, upgrade, and administer integration platforms and related components.

Diagnose and troubleshoot integration and system-related errors.

Build and manage database reports, visualizations, and dashboards.

Automate recurring tasks to improve operational efficiency.

Develop and enforce policies, procedures, and standards for system management and governance.

Create and maintain backup and recovery strategies aligned with industry best practices.

Monitor and optimize integration system performance, providing recommendations to enhance scalability and efficiency.

Ensure system security, integrity, and availability, including planning and executing disaster recovery measures.

Qualifications:

Mandatory experience on Integration Builder

35+ years of experience delivering enterprisegrade system integrations

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

Solid knowledge of core dataintegration concepts, such as:

Error handling, deadletter 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, rootcause analysis, and longterm 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 problemsolving skills

Advanced command of SQL and SQL Server toolsets

Indepth understanding of database security, backup/recovery, and performance monitoring

Familiarity with relational and dimensional datamodeling 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

Compensation:

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

Pay Range

Team

Information Technology

Working Pattern

Full time

Location

New York

Contract type

Permanent Contract

We are committed to attracting people from all backgrounds and creating a respectful and inclusive culture where everyone thrives. We see this as essential to our success, including our ability to innovate and achieve sustained high performance. This is a key part of our ValuesHuman, Bold, and Outstanding.

Herbert Smith Freehills Kramer is an equal opportunity employer. The firm is committed to creating and maintaining a workplace in which all employees have an opportunity to participate and contribute to the success of the business and are valued for their skills, experience, and unique perspectives. The firm does not discriminate on the basis 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 expression or any other criteria prohibited under applicable federal, state or local law.

Location: New York

Time Type: Full time

Data Systems Analyst

Compensation

$135,000 – $160,000 USD

City: New York City

Country: United States

Herbert Smith Freehills logo
Law

3 days ago

No clicks

at Herbert Smith Freehills

ExperiencedNo visa sponsorship

**Data Systems Analyst**: Support 24/7 client services, mapping legal data, and building custom integrations using Intapp Integrate. Design and execute SQL queries, automate tasks, and manage system performance. Expertise in REST APIs, JSON, XML, and SQL Server; experience with mission-critical enterprise systems. 3-5+ years in enterprise-grade system integrations.

Full Job Description

The Opportunity

Key Responsibilities:

Provide 24x7 support for client and userfacing products and services with a strong focus on data quality, system reliability, and seamless integrations. Responsible for mapping and transforming legal practice data to enable downstream processes and analytics.

Design and build custom data integrations using Intapp Integrate (Integration Builder), leveraging Intapp APIs, data models, and workflow tools. Demonstrate expertise integrating with missioncritical enterprise systems such as Active Directory/Azure AD, HRIS platforms, DMS, CRM, Finance/ERP, matter management, billing/time systems, and data warehouses.

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 scriptingpreferably using PowerShell, Python, or C#to enable pre and postprocessing operations and streamline data workflows.

Deploy, maintain, and troubleshoot core business applications, including configuration, reporting, and system optimization.

Collaborate with internal and external stakeholders to define project scope, system objectives, and detailed requirements.

Develop, analyze, prioritize, and document requirement specifications, data mappings, diagrams, and process flows.

Translate complex technical specifications into clear, easy-to-understand nontechnical requirements.

Manage system setup, configuration, and environment preparation.

Define and coordinate testing activities, including test planning, test case development, and quality assurance oversight.

Create and maintain comprehensive documentation for system processes, workflows, and procedures.

Implement maintenance routines, monitor system performance, collect operational metrics, and resolve reported issues.

Design, implement, and upgrade information systems to meet evolving business and user needs.

Perform performance tuning and optimization of integration systems.

Install, upgrade, and administer integration platforms and related components.

Diagnose and troubleshoot integration and system-related errors.

Build and manage database reports, visualizations, and dashboards.

Automate recurring tasks to improve operational efficiency.

Develop and enforce policies, procedures, and standards for system management and governance.

Create and maintain backup and recovery strategies aligned with industry best practices.

Monitor and optimize integration system performance, providing recommendations to enhance scalability and efficiency.

Ensure system security, integrity, and availability, including planning and executing disaster recovery measures.

Qualifications:

Mandatory experience on Integration Builder

35+ years of experience delivering enterprisegrade system integrations

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

Solid knowledge of core dataintegration concepts, such as:

Error handling, deadletter 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, rootcause analysis, and longterm 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 problemsolving skills

Advanced command of SQL and SQL Server toolsets

Indepth understanding of database security, backup/recovery, and performance monitoring

Familiarity with relational and dimensional datamodeling 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

Compensation:

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

Pay Range

Team

Information Technology

Working Pattern

Full time

Location

New York

Contract type

Permanent Contract

We are committed to attracting people from all backgrounds and creating a respectful and inclusive culture where everyone thrives. We see this as essential to our success, including our ability to innovate and achieve sustained high performance. This is a key part of our ValuesHuman, Bold, and Outstanding.

Herbert Smith Freehills Kramer is an equal opportunity employer. The firm is committed to creating and maintaining a workplace in which all employees have an opportunity to participate and contribute to the success of the business and are valued for their skills, experience, and unique perspectives. The firm does not discriminate on the basis 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 expression or any other criteria prohibited under applicable federal, state or local law.

Location: New York

Time Type: Full time