Data Systems Analyst

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.
• 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.

Requirements

• 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 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 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

Benefits

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at herbertsmithfreehills? Share your experience