jobapplier

Sr. Data Migration Engineer (C4-1125150)

cloudelligent

Sr.

8am-5pm CST Location: Lahore About Cloudelligent Cloudelligent is a Cloud-native consultancy and AWS Advanced consulting partner! We specialize in providing bespoke cloud solutions to the Startups, SMB & enterprise segment.

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.

About cloudelligent

  • Being a next gen cloud service provider, Cloudelligent helps businesses to make the most out of their cloud investment.
  • We have an international footprint with a diverse team of domain experts, and we are customer- obsessed.
  • Job Objective We’re looking for a Senior Data Migration Engineer to drive the data conversion work that powers successful LegalTech SaaS implementations.

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

Requirements

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

Preferred

  • Experience in legal-tech, professional services, or financial systems is a plus.