ETL/Data Migration Engineer

Thomson Reuters

ETL/Data Migration Engineer responsible for planning, executing, and validating data migrations to and from the Legal Tracker platform, collaborating across multiple teams and stakeholders.

Posted 6/22/2026full-timeMexico City • 🇲🇽 MexicoMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Plan and execute end-to-end data migrations, including extraction, cleaning, transformation, validation, loading, and reconciliation.
Analyze source data, create field mappings, and define transformation rules for migration into or out of Legal Tracker.
Prepare and validate CSV, Excel, XML, and other import/export file formats.
Write SQL queries for data extraction, validation, and reconciliation across relational databases.
Develop and execute test plans, perform mock migrations, and reconcile source and target system records.
Troubleshoot migration errors, resolve data exceptions, and ensure complete and accurate conversion outcomes.
Work with APIs, SFTP, middleware, and integration workflows to support automated data feeds and system-to-system transfers.
Collaborate with legal operations, finance, IT, outside counsel, vendors, and implementation partners throughout the migration lifecycle.
Maintain documentation to ensure secure, auditable, and compliant data migration processes.
Develop strong knowledge of legal operations data, including matters, invoices, vendors, timekeepers, budgets, accruals, and related metadata.

Requirements

What you’ll need

3 to 4 years of experience planning and executing data migrations, including data extraction, transformation, cleaning, validation, loading, and reconciliation
Bachelor's degree or equivalent experience.
Proficiency in writing SQL queries for data extraction, transformation, validation, and reconciliation.
Experience working with relational databases and structured datasets.
Advanced Excel skills, including lookups, pivot tables, formulas, data validation, and large-file handling.
Experience preparing and validating CSV, Excel, XML, or similar structured file formats.
Understanding of APIs, SFTP, middleware, and enterprise integration workflows.
Experience coordinating with technical and business stakeholders in client-facing environments.
Strong communication skills to explain technical issues to non-technical stakeholders.
Strong analytical skills and attention to detail.
Ability to troubleshoot migration errors and ensure accurate reconciliation of source and target systems.
Familiarity with legal data domains such as matters, invoices, law firms, timekeepers, rate cards, cost centers, business units, matter types, practice areas, budgets, accruals, and invoice line items.
Understanding of UTBMS codes, LEDES invoice formats, billing guidelines, and legal spend management concepts.
Familiarity with Legal Tracker and other eBilling or legal operations platforms such as TeamConnect, CounselLink, SimpleLegal, Onit, or Passport is a plus.
English proficiency.

Benefits

Comp & perks

Hybrid Work Model: We’ve adopted a flexible hybrid working environment (2-3 days a week in the office depending on the role)
Flex My Way is a set of supportive workplace policies designed to help manage personal and professional responsibilities
Career Development and Growth: By fostering a culture of continuous learning and skill development
Industry Competitive Benefits: We offer comprehensive benefit plans including flexible vacation, two company-wide Mental Health Days off, access to the Headspace app, retirement savings, tuition reimbursement, employee incentive programs
Social Impact: Make an impact in your community with our Social Impact Institute. We offer employees two paid volunteer days off annually

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data migrationdata extractiondata transformationdata cleaningdata validationdata loadingSQLExcelAPIsrelational databases

Soft Skills

communicationanalytical skillsattention to detailtroubleshootingcollaboration

Certifications

Bachelor's degree