Data Services Analyst

Litera

Raleigh (NC)

Hybrid

USD 80,000 - 110,000

Full time

1 hour ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Litera is seeking a Data Services Analyst in Raleigh, NC, to lead data preparation, transformation, migration, and integration for CMM and Foundation projects. You will work with implementation consultants and customers to translate complex data requirements into reliable outcomes and validate data quality before go-live.

You’ll design and maintain data flows using Power Platform, Dataverse, Azure Data Factory, and APIs, building reusable scripts and automation to reduce manual effort and

Qualifications

  • Hands-on experience with SQL and T-SQL for data extraction, transformation and ETL.
  • Experience supporting data migration, systems integration, or customer onboarding projects.
  • Experience with Microsoft Power Platform, particularly Power Automate.
  • Experience building Azure Data Factory pipelines and connecting on-premises SQL data sources with cloud services.
  • Knowledge of API-based integrations, JSON, authentication methods, secure credential handling, and production access controls.
  • Strong analytical, documentation, and communication skills for client-facing work.

Responsibilities

  • Translate source-system, data-mapping, migration, integration, security, and validation requirements into reliable outcomes for CMM and Foundation projects.
  • Profile and assess legacy data, document transformation rules, and build T-SQL scripts, ETL processes to load data.
  • Design, configure, and maintain data flows and integrations using Power Platform, Power Automate, Dataverse, Azure Data Factory, APIs, and connectors.
  • Execute test migrations and integrations, reconcile results, and validate data accuracy and access controls.
  • Support cutover and go-live, including final data prep, migration execution, validation, and post-go-live stabilization.
  • Maintain documentation and communicate status, risks, and dependencies to project teams and customers.

Skills

SQL & T-SQL
ETL processes
Data migration & integration
Power Platform
Azure Data Factory
APIs & JSON
Analytical & communication

Tools

Power Automate
Dataverse
Azure Data Factory
SQL Server

Job description

Ready to Help Shape the Future of Legal Tech?!

At Litera, we don’t just build software, we transform how the world’s top law firms operate. Every day, we Raise The Bar™ for what’s possible through AI, innovation, and solutions that power millions of legal professionals worldwide. If you’re energized by scale, real impact, and meaningful challenges, you’ll feel right at home here.

Where You’ll Work

Hybrid: This is a hybrid role based in Raleigh with the expectation to be in office at least 3 days a week for collaboration and connection.

Why this Role Matters

As a Data Services Analyst, you’ll be the data expert behind successful customer implementations of Litera Case & Matter Management (CMM) and Foundation — preparing, transforming, migrating, integrating, and validating the data that law firms rely on every day. Working alongside implementation consultants, project teams, and customer stakeholders, you’ll translate complex data requirements into reliable migration and integration outcomes, from discovery and test cycles through go-live and post-implementation support. This is a client-facing, high-impact role where the quality of your work directly determines how smoothly a firm transitions to Litera’s platforms. If you’re energized by solving complex data challenges and turning messy legacy systems into clean, trusted data, this is your opportunity.

What You’ll Deliver
  • Partner with implementation consultants and customer stakeholders to translate source-system, data-mapping, migration, integration, security, and validation requirements into reliable outcomes for CMM and Foundation projects.
  • Profile and assess legacy data, document transformation rules and exceptions, and build T-SQL scripts, stored procedures, and ETL processes that extract, cleanse, transform, and load data into Litera’s 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 — supporting 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 — while improving reusable scripts, automation assets, and templates that reduce manual effort and increase consistency.

Litera is committed to providing reasonable accommodations throughout the recruitment process. If you need an accommodation, please let us know and we’ll work with you to meet your needs.

What You’ll Bring
Must-Haves
  • 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, with the ability to troubleshoot root causes, manage multiple tasks, and work effectively with both 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.
What You’ll Experience
  • A team that shows up. Work alongside people who collaborate, support one another, and lead with integrity.
  • Global Reach. Partner with teams around the world to solve complex challenges that matter.
  • Real opportunity for growth. Expand your impact through meaningful stretch opportunities, visibility and career development.
  • AI‑driven innovation. Work at the intersection of legal technology, customer outcomes, and cutting‑edge AI.

Litera is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Solutions Consultant – Foundation
Solutions Consultant – Foundation

Litera • Raleigh (NC)

Hybrid
USD 100,000 - 125,000
Implementation Consultant
Implementation Consultant

Litera • Raleigh (NC)

Hybrid
USD 90,000 - 120,000
Solutions Consultant – Foundation
Solutions Consultant – Foundation

Litera • Holmdel Township (NJ)

Hybrid
USD 100,000 - 125,000
Solutions Consultant – Foundation
Solutions Consultant – Foundation

FREEDOM SOLUTIONS GR • Raleigh (NC)

Hybrid
USD 100,000 - 125,000
Manager, Technical Support
Manager, Technical Support

FREEDOM SOLUTIONS GR • Denver (CO)

Hybrid
USD 100,000 - 115,000
Medical insurance
401(k) with company match
Employee recognition programs
Manager, Technical Support
Manager, Technical Support

Litera • Denver (CO)

Hybrid
USD 100,000 - 115,000
Software Engineer (C#, .Net, SSAS, ETL, Datawarehouse)
Software Engineer (C#, .Net, SSAS, ETL, Datawarehouse)

the LitEra • Denver (CO)

Hybrid
USD 120,000 - 150,000
Medical benefits
401(k) with match
Bonus plan eligibility
Enterprise Customer Adoption Manager
Enterprise Customer Adoption Manager

FREEDOM SOLUTIONS GR • Raleigh (NC)

Hybrid
USD 110,000 - 160,000
Technical Lead, Software Engineer
Technical Lead, Software Engineer

Litera • Denver (CO)

Hybrid
USD 150,000 - 180,000
Medical, Dental, Vision
401(k) with company match
Hybrid work model
Customer Adoption Manager, Corporate
Customer Adoption Manager, Corporate

FREEDOM SOLUTIONS GR • Raleigh (NC)

Hybrid
USD 90,000 - 120,000