Data Systems Analyst Job at Herbert Smith, New York, NY

  • Herbert Smith
  • New York, NY

Job Description

The OpportunityKey Responsibilities:Provide 24x7 support for client and user‑facing 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 mission‑critical 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 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.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 non‑technical 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 Builder3–5+ years of experience delivering enterprise‑grade system integrationsProficient in SQL including querying, joins, and basic performance tuning for validation, reconciliation, and issue resolutionStrong background in integration delivery and operational support, including:Deep understanding of REST APIs, authentication methods (OAuth2, API keys, token-based auth), and webhooksSkilled in working with JSON/XML, data mapping, transformations, and schema validationSolid knowledge of core data‑integration concepts, such as:Error handling, dead‑letter queues, monitoring, and alertingScheduling, incremental data loads, and change trackingExperience supporting production integrations with a focus on stability and performance, including:Managing SLAs, incident response, root‑cause analysis, and long‑term problem managementProven ability to understand business requirements and translate them into effective technical solutionsStrong knowledge of application setup principles and best practicesHands-on experience installing, configuring, documenting, testing, training, and deploying new applications and systemsExcellent analytical and problem‑solving skillsAdvanced command of SQL and SQL Server toolsetsIn‑depth understanding of database security, backup/recovery, and performance monitoringFamiliarity with relational and dimensional data‑modeling techniquesScripting skills in PowerShell and Unix shellExposure to SSAS, SSIS, and SSRSExceptional written and verbal communication skillsHigh level of attention to detailCompensation:Exact compensation may vary based on skills and experience and salary range is $135,000 - $160,000.Pay RangeTeamInformation TechnologyWorking PatternFull timeLocationNew YorkContract typePermanent ContractWe 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 Values—Human, 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.Job SummaryJob number: R-102885Date posted : 2026-06-24Profession: Business ServicesEmployment type: Full Time

Job Tags

Full time, Local area

Similar Jobs

UPS Store 2468

UPS Store Center Associate Job at UPS Store 2468

At The UPS Store, we are committed to customer-centered excellence, operating as a unified team, and fostering relentless growth. We are seeking a driven, positive, and team-oriented superstar who thrives under pressure and is ready to deliver exceptional customer experiences... 

Pocruises

Executive Pastry Sous Chef - Cruise Ship Galley Lead Job at Pocruises

 ...while overseeing and training the pastry staff. The ideal candidate has at least 5 years of experience in prestigious environments and possesses a formal culinary degree. This role demands flexibility and teamwork in a fast-paced cruise ship setting.#J-18808-Ljbffr... 

Ricavvo

Digital Marketing Manager Job at Ricavvo

 ...new book, ARMBAR: The Leverage Blueprint for Sales Mastery on Amazon Job Title : Digital Marketer Location : Remote (Anywhere in the US) Employment Type : Part-Time Employee About Ricavvo, LLC At Ricavvo, we transform sales into predictable value through... 

SynergisticIT

Web Developer (Junior)- Remote Job at SynergisticIT

 ...strong projects, interview confidence, and a clear story about the value they can bring. That is especially important in competitive entry-level and junior hiring. Since 2010, we've helped thousands of candidates land full-time jobs at tech leaders like Google, Apple,... 

The Walt Disney Studios

Disney Store: Sales Associate (Seasonal) Job at The Walt Disney Studios

 ...Seasonal Cast MemberDisney store and DisneyStore.com are the retail merchandising arms of Disney Parks, Experiences and Products, the business segment of The Walt Disney Company and its affiliates that extends The Walt Disney Company's brands to merchandise. Disney store...