Senior Data Migration & ETL Engineer

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

Job summary

Cloudelligent in Islamabad is seeking a Senior Data Migration Engineer to lead end-to-end ETL migrations for LegalTech SaaS implementations. You will analyze legacy structures, map data to new schemas, run test conversions, validate results, and support go-live with detailed documentation.

The role requires 4+ years in data migration or ETL, strong SQL, Python (Pandas/NumPy), Excel/Power Query, and experience with SQL, CSV, JSON, and XML.

Qualifications

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

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

Skills

Advanced SQL

Python (Pandas/NumPy)

Excel/Power Query

Data analysis

Documentation

Communication

Tools

SQL databases

CSV/JSON/XML

ETL tooling

Job description

Cloudelligent in Islamabad is seeking a Senior Data Migration Engineer to lead end-to-end ETL migrations for LegalTech SaaS implementations. You will analyze legacy structures, map data to new schemas, run test conversions, validate results, and support go-live with detailed documentation.

The role requires 4+ years in data migration or ETL, strong SQL, Python (Pandas/NumPy), Excel/Power Query, and experience with SQL, CSV, JSON, and XML.