ETL/Data Migration Engineer
Core
Plan, execute, and validate end-to-end data migrations for the Legal Tracker platform, ensuring accurate and auditable data conversions across systems.
Role type
ETL/Data Migration Engineer
Builds
Data migrations and system-to-system transfers for legal operations platforms
Domain
Legal technology / Enterprise data management
Deliverable
production ML models | product features | dashboards & analysis | research | client delivery | infrastructure | physical/clinical work
Required skills
SQL, relational databases, structured file formats (CSV, Excel, XML), API integration, SFTP, middleware, data reconciliation, UTBMS codes, LEDES invoice formats
Preferred skills
Legal Tracker, TeamConnect, CounselLink, SimpleLegal, Onit, Passport
Responsibilities
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; Prepare and validate import/export file formats; Write SQL queries for data extraction and validation; Develop and execute test plans and perform mock migrations; Troubleshoot migration errors and resolve data exceptions; Work with APIs, SFTP, middleware, and integration workflows; Maintain documentation for secure and compliant processes.
Seniority
Mid-level, hands-on IC
