Data Services Analyst

Litera•Raleigh, NC
•Hybrid

About The Position

The Data Services Analyst supports customer implementations of Litera Case & Matter Management (CMM) and Foundation by preparing, transforming, migrating, integrating, and validating customer data. Working with implementation consultants, project teams, and customer stakeholders, the analyst translates complex data requirements into dependable migration and integration outcomes from discovery and testing through go-live and post-implementation support. This is a client-facing role in which data quality directly affects customers’ transitions to Litera’s platforms. The position is hybrid and based in Raleigh, with at least three days per week in the office. The analyst profiles legacy data, builds data transformation and ETL solutions, creates and maintains integrations, executes test migrations, supports production cutover, and documents project status and risks. The role also contributes reusable scripts, automation assets, and templates to reduce manual effort and improve consistency.

Requirements

  • Hands-on experience with SQL and T-SQL, including data extraction, transformation, reconciliation, stored procedures, and ETL processes.
  • Experience supporting data migration, systems integration, application implementation, or customer onboarding projects.
  • Experience with Microsoft Power Platform, particularly Power Automate.
  • Experience building or maintaining Azure Data Factory pipelines and connecting on-premises SQL data sources with cloud services.
  • Working knowledge of API-based integrations, JSON, authentication methods, secure credential handling, and production access controls.
  • Strong analytical, documentation, and communication skills.
  • Ability to troubleshoot root causes, manage multiple tasks, and work effectively with technical and non-technical stakeholders in a client-facing environment.

Nice To Haves

  • Experience with legal technology, law-firm data, case and matter management, or other regulated professional-services systems.
  • Experience with Litera CMM, Foundation, Foundation CX365, Peppermint, or comparable matter-management and firm-intelligence platforms.
  • Knowledge of PowerShell, SSIS, Azure Service Bus, Azure Key Vault, C#, .NET, JavaScript, or Python.
  • Familiarity with staging-database setup, go-live controls, and implementation artifacts such as Statements of Work, test plans, defect logs, and customer acceptance processes.

Responsibilities

  • Work with implementation consultants and customer stakeholders to translate source-system, data-mapping, migration, integration, security, and validation requirements into outcomes for CMM and Foundation projects.
  • Profile and assess legacy data, document transformation rules and exceptions, and create T-SQL scripts, stored procedures, and ETL processes to extract, cleanse, transform, and load data into Litera staging and target formats.
  • Design, configure, and maintain data flows and integrations using Microsoft Power Platform, Power Automate, Dataverse, Azure Data Factory, APIs, and custom connectors.
  • Execute test migrations and integrations, reconcile results, and validate data accuracy, completeness, and access controls to support customer review and sign-off before production deployment.
  • Support cutover and go-live, including final data preparation, migration execution, validation, troubleshooting, and post-go-live stabilization.
  • Maintain clear documentation and communicate status, risks, and dependencies to project teams and customers.
  • Improve reusable scripts, automation assets, and templates to reduce manual effort and increase consistency.

Benefits

  • Meaningful stretch opportunities, visibility, and career development.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service