Senior Data Migration Engineer: ETL for LegalTech SaaS

Cloudelligent; Lahore; On-site; PKR 2,400,000 - 4,200,000; Full time

Job summary

Cloudelligent in Lahore is seeking a Senior Data Migration Engineer to lead end-to-end data conversions for LegalTech SaaS implementations, ensuring financial and practice data is clean and ready for day-one use. You will analyze legacy data, map to new schemas, run test conversions, and support go-live, collaborating with PMs, consultants, and client IT teams.

Strong SQL, Python, ETL experience required. The role is based in Lahore with standard hours; you will build templates, documentation,

Qualifications

• 4+ years in data migration, ETL engineering, data conversion, or ERP/SaaS integration.
• Advanced SQL skills with performance tuning.
• Strong Excel/Power Query and Python (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.
• Experience in legal-tech, professional services, or financial systems is a plus.

Responsibilities

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

Skills

Advanced SQL

ETL Engineering

Python (Pandas/NumPy)

Excel / Power Query

Data Analysis

Documentation

Cross-functional Communication

Tools

SQL Server

ETL Tools

Pandas

APIs

Job description

Cloudelligent in Lahore is seeking a Senior Data Migration Engineer to lead end-to-end data conversions for LegalTech SaaS implementations, ensuring financial and practice data is clean and ready for day-one use. You will analyze legacy data, map to new schemas, run test conversions, and support go-live, collaborating with PMs, consultants, and client IT teams.

Strong SQL, Python, ETL experience required. The role is based in Lahore with standard hours; you will build templates, documentation,