Senior Data Migration Engineer: ETL for LegalTech SaaS

Cloudelligent; Lahore; On-site; PKR 1,200,000 - 1,800,000; Full time

Job summary

Cloudelligent is seeking a Senior Data Migration Engineer in Lahore to lead end-to-end data conversion for LegalTech SaaS deployments. You will analyze legacy data, map to modern schemas, run test conversions, validate results, and support go-live activities.

The role requires strong SQL, Python, and ETL experience, with a focus on data quality, documentation, and cross-functional collaboration with project managers and IT teams.

Qualifications

• 4+ years in data migration, ETL engineering or ERP/SaaS integration.
• Strong SQL skills including joins, CTEs, validation, and performance tuning.
• Proficient Excel/Power Query and Python experience (Pandas/NumPy).
• Experience with CSV, JSON, XML data formats.
• Ability to design end-to-end data migration strategies and documentation.

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

Skills

Advanced SQL

Excel / Power Query

Python (Pandas/NumPy)

ETL / Data Migration

Data Mapping & QA

Tools

SQL DBs

CSV/JSON/XML

Job description

Cloudelligent is seeking a Senior Data Migration Engineer in Lahore to lead end-to-end data conversion for LegalTech SaaS deployments. You will analyze legacy data, map to modern schemas, run test conversions, validate results, and support go-live activities.

The role requires strong SQL, Python, and ETL experience, with a focus on data quality, documentation, and cross-functional collaboration with project managers and IT teams.