REF: #1820
DATA MIGRATIONS ENGINEER (Financial Systems)
busquedasIT
OPEN

  • Design and maintain data migration scripts from legacy systems (PE, CCH, others).
  • Write complex SQL queries to transform, normalize, and reconcile financial data.
  • Migrate and validate information related to:
    • Work In Progress (WIP)
    • Accounts Receivable (AR)
    • Invoicing, payments, credits, write-offs, adjustments
  • Perform numerical reconciliations (before / after) to ensure data integrity.
  • Identify and document conversion rules and historical edge cases.
  • Create supporting scripts in Ruby (or Python) for ETL processes, parsing, and automation.
  • Collaborate with the team to iterate on the data model when necessary.
  • Document processes so migrations are repeatable and auditable.

Advanced SQL (very important):

  • Complex JOINs
  • CTEs (WITH)
  • CASE statements, aggregations, window functions
  • Experience working with large databases and inconsistent datasets

Strong numerical / financial understanding:

  • Understanding of the Difference between WIP and AR
  • Billed vs. unbilled
  • Adjustments, credits, reversals, accounting periods
  • Experience with PostgreSQL and/or SQL Server.
  • Ability to validate results, not just execute scripts.

Previous experience migrating data from:

  • Accounting systems
  • ERPs
  • Billing / invoicing platforms
  • Basic knowledge of Ruby or Python for scripting.
  • Experience with data migration or ETL processes.
  • Experience working with financial or accounting software.

  • We are not looking for a data scientist or a full-stack developer — this is a deeply technical, data-focused role.

An opportunity to join an innovative software company at the forefront of practice management for CPA firms.

  • Flexible remote/hybrid working arrangements.
  • Professional development and growth opportunities.
  • Competitive salary and benefits.

Apply

Role and Technologies

In accordance with Law No. 18,331, Decree 414/09, art. 37 to 40 of Law 19,670 and Decree 64/20, on the Protection of Personal Data and Action of Habeas Data, declares that I voluntarily provide my personal data, and that they it can be used by BÚSQUEDAS IT in selection processes and administration of current and future personnel and/or transferring to clients, key partners or other local and international companies; and that BUSQUEDAS IT will be able to store them it on its servers located in the United States, Texas, and process them it with broad commercial fines for the best fulfillment of its services. If you no longer want to be part of the database, send an email requesting unsubscription to info@busquedasit.com.