ETL/Data Migration Engineer

About the role

In this opportunity as an ETL/Data Migration Engineer, you will: 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. About You You're a fit for the role if your background includes: 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. #LI-FZ1 What's in it For You? Hybrid Work Model: We've adopted a flexible hybrid working environment (2-3 days a week in the office depending on the role) for our office-based roles while delivering a seamless experience that is digitally and physically connected. Flexibility & Work-Life Balance: Flex My Way is a set of supportive workplace policies designed to help manage personal and professional responsibilities, whether caring for family, giving back to the community, or finding time to refresh and reset. This builds upon our flexible work arrangements, including work from anywhere for up to 8 weeks per year, empowering employees to achieve a better work-life balance. Career Development and Growth: By fostering a culture of continuous learning and skill development, we prepare our talent to tackle tomorrow's challenges and deliver real-world solutions. Our Grow My Way programming and skills-first approach ensures you have the tools and knowledge to grow, lead, and thrive in an AI-enabled future. Industry Competitive Benefits: We offer comprehensive benefit plans to include flexible vacation, two company-wide Mental Health Days off, access to the Headspace app, retirement savings, tuition reimbursement, employee incentive programs, and resources for mental, physical, and financial wellbeing. Culture: Globally recognized, award-winning reputation for inclusion and belonging, flexibility, work-life balance, and more. We live by our values: Obsess over our Customers,

Benefits

Additional Information

ETL/Data Migration Engineer Are you looking to join a forward-thinking technology organization focused on delivering accurate, secure, and efficient data solutions within legal operations? As an ETL/Data Migration Engineer, you will be responsible for planning, executing, and validating data migrations to and from the Legal Tracker platform. You will collaborate with legal operations, finance, IT, business stakeholders, and vendor teams to ensure structured, accurate, and auditable data conversions across systems. This role is ideal for detail-oriented professionals who thrive in structured environments, enjoy solving complex data challenges, and want to build expertise in legal technology and enterprise data management.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Thomson Reuters? Share your experience