ETLData Migration Engineer

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.

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

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

Whats in it For You

• Hybrid Work Model: Weve 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 tomorrows 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 Compete to Win Challenge (Y)our Thinking Act Fast / Learn Fast and Stronger Together.

• Social Impact: Make an impact in your community with our Social Impact Institute. We offer employees two paid volunteer days off annually and opportunities to get involved with pro-bono consulting projects and Environmental Social and Governance (ESG) initiatives.

• Making a Real-World Impact:We are one of the few companies globally that helps its customers pursue justice truth and transparency. Together with the professionals and institutions we serve we help uphold the rule of law turn the wheels of commerce catch bad actors report the facts and provide trusted unbiased information to people all over the world.

About Us

Thomson Reuters informs the way forward by bringing together the trusted content and technology that people and organizations need to make the right decisions. We serve professionals across legal tax accounting compliance government and media. Our products combine highly specialized software and insights to empower professionals with the data intelligence and solutions needed to make informed decisions and to help institutions in their pursuit of justice truth and transparency. Reuters part of Thomson Reuters is a world leading provider of trusted journalism and news.

We are powered by the talents of 26000 employees across more than 70 countries where everyone has a chance to contribute and grow professionally in flexible work environments. At a time when objectivity accuracy fairness and transparency are under attack we consider it our duty to pursue them. Sound exciting Join us and help shape the industries that move society forward.

As a global business we rely on the unique backgrounds perspectives and experiences of all employees to deliver on our business goals. To ensure we can do that we seek talented qualified employees in all our operations around the world regardless of race color sex/gender including pregnancy gender identity and expression national origin religion sexual orientation disability age marital status citizen status veteran status or any other protected classification under applicable law. Thomson Reuters is proud to be an Equal Employment Opportunity Employer providing a drug-free workplace.

We also make reasonable accommodations for qualified individuals with disabilities and for sincerely held religious beliefs in accordance with applicable law. More information on requesting an accommodation here.

Learn more on how to protect yourself from fraudulent job postings here.

More information about Thomson Reuters can be found on