> Markdown version of [/jobs/ext/3041215-data-migration-engineer](https://www.wearedevelopers.com/jobs/ext/3041215-data-migration-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Migration Engineer - **Company:** After School Matters, Inc. - **Location:** Lahore, VA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Application Programming Interfaces (APIs), Automation of Tests, Big Data, Business Process Modeling, Software as a Service, Data Conversion, Extract Transform Load (ETL), Data Migration, Data Structures, JSON, Python (Programming Language), NumPy, Performance Tuning, Simple Data Format, SQL Databases, Systems Integration, Extensible Markup Language (XML), Scripting, Freeform SQL, Sql Optimization, Powerquery, Pandas - **Published:** September 23, 2026 - **Apply:** https://cloudelligent.applytojob.com/apply/iJvLpHfaho/Sr-Data-Migration-Engineer-C41125150?source=GS ## About the Role * 4+ years in data migration, ETL engineering, data conversion, or ERP/SaaS system integration. * Advanced SQL skills (joins, CTEs, schema work, validation logic, troubleshooting, performance tuning). * Strong Excel/Power Query skills and Python experience (Pandas/NumPy a plus). * Experience with structured and semi-structured file formats (CSV, JSON, XML). * Demonstrated ability to analyze complex datasets, identify patterns, and resolve data-quality issues. * Experience executing multi-object migration cycles (dry runs, reconciliations, cutovers). * Strong documentation habits and the ability to produce clear technical specifications. * Excellent communication skills and comfort working cross-functionally with non-technical stakeholders. * Experience in legal-tech, professional services, or financial systems is a plus. ## Description We're looking for a Senior Data Migration Engineer to drive the data conversion work that powers successful LegalTech SaaS implementations. As firms move from legacy tools to modern platforms, your work ensures that their financial, operational, and practice data is clean, accurate, and ready for day-one use. You'll lead the full ETL lifecycle analyzing legacy structures, mapping data to modern schemas, running test conversions, validating results, and supporting a seamless go-live experience., * Analyze legacy financial and practice-management data structures and design end-to-end conversion strategies. * Collaborate with project managers and implementation consultants to understand mapping requirements and business rules. * Translate functional requirements into clear, scalable technical migration plans. * Extract data from SQL databases, CSV exports, APIs, and other legacy sources. * Write and optimize complex SQL queries (joins, CTEs, validation queries, reconciliation logic). * Develop Python scripts or reusable ETL tools to automate recurring processes and improve consistency. * Build and maintain detailed data-mapping documentation across all migration objects. * Perform dry-run migrations and validate data accuracy across financial and operational modules. * Execute final production loads and deliver reconciliation reports for billing, WIP, AR, GL, and related datasets. * Investigate and resolve anomalies, data gaps, or logic errors across multiple data sources. * Create detailed technical documentation, mapping dictionaries, transformation logic, and conversion specifications. * Serve as a primary technical partner to project managers, implementation consultants, and client IT teams. * Clearly communicate data issues, risks, and recommendations in both technical and non-technical terms. * Help build and enhance migration templates, automation scripts, and best-practice playbooks. * Identify opportunities to streamline processes, reduce manual work, and strengthen data quality. ## Related Videos - [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Vectorize all the things! Using linear algebra and NumPy to make your Python code lightning fast.](https://www.wearedevelopers.com/videos/562-vectorize-all-the-things-using-linear-algebra-and-numpy-to-make-your-python-code-lightning-fast) - [Advanced Typing in TypeScript](https://www.wearedevelopers.com/videos/496-advanced-typing-in-typescript) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [System change: restart as developer?](https://www.wearedevelopers.com/magazine/39-system-change-restart-as-developer) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)