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

At ModernPM, we are building a modern practice management platform for accounting firms in the U.S.
A key part of the product is converting historical data from legacy systems such as Practice Engine (PE) and CCH Practice CS into our data model.
We are looking for someone to take full ownership of these migration processes: someone very strong in SQL, with solid numerical judgment, and capable of understanding how real financial data behaves (WIP, AR, billing, adjustments, periods, etc.).
This role is critical to product quality and works closely with the CTO and the core team.

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

Postularme

Cargo y Tecnologías

De conformidad con la Ley Nº 18.331, el Decreto 414/09, art. 37 a 40 de la Ley 19.670 y el Decreto 64/20, de Protección de Datos Personales y Acción de Habeas Data, declaro que proporciono de manera voluntaria mis datos personales, y que los mismo pueden ser utilizados por BÚSQUEDAS IT en procesos de selección y administración de personal actuales y futuros y/o transferirse a clientes, socios clave u otras compañías locales e internacionales; y que BÚSQUEDAS IT podrá almacenarlos en sus servidores alojados en Estados Unidos, Texas, y procesarlos con fines comerciales amplios para el mejor cumplimiento de sus servicios. En caso de no querer formar mas parte de la base de datos enviar un correo solicitando la baja a info@busquedasit.com.