Data Migration Technical Lead (Hybrid Setup)

SYSGEN RPO; Makati; Hybrid; PHP 800,000 - 1,400,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

ThirdEye seeks a seasoned data migration lead to orchestrate end-to-end migrations across complex multi-system environments. You will translate business needs into actionable migration designs, run discovery workshops, and present approaches to executive stakeholders.

Expertise in SQL, Python, and ETL tooling is essential, with a track record of delivering on-time migration outcomes. Hybrid delivery is expected with monthly on-site engagements to coordinate with client teams, accelerate

Qualifications

• Delivered end-to-end data migration projects across multi-system environments.
• Proficient in SQL for data profiling and transformation; Python for automation.
• Hands-on experience with enterprise ETL tools (ADF, Informatica, Talend).
• Managed high-volume data loads, API bulk patterns, rate limits and governance.

Responsibilities

• Facilitate sessions to define data scope, cleansing rules, transformation logic and acceptance criteria.
• Lead discovery workshops translating business needs into migration designs.
• Present technical approaches to clients and manage expectations at all levels.
• Produce source-to-target mappings, data dictionaries, and transformation specs.
• Design and build ETL/ELT pipelines and automate bespoke transformation logic.
• Coordinate migration runs, triage failures, and drive cutover to production readiness.

Skills

Stakeholder management

Requirements gathering

Workshop facilitation

Data migration

ETL design

SQL proficiency

Python scripting

Client relationship

Delivery leadership

Tools

Azure Data Factory

Informatica

Talend

open-source ETL tooling

Job description

• Facilitate working sessions to agree data scope, cleansing rules, transformation logic, and acceptance criteria.
• Lead discovery workshops and requirements-gathering sessions, translating business needs into clear, actionable migration designs.
• Own the room with clients by presenting technical approaches, managing expectations, and building trust at all levels—from data owners to C-suite stakeholders.

Technical Delivery

• Produce and maintain source-to-target mapping specifications, data dictionaries, and transformation design documents.
• Design and build ETL/ELT pipelines using tooling such as Azure Data Factory, Informatica, Talend, or open-source equivalents.
• Write and optimise SQL for data profiling, extraction, deduplication, cleansing, and validation against legacy source systems.
• Develop Python (or equivalent) scripts to handle bespoke transformation logic and automation tasks.
• Execute migration runs, triage failures, and iterate through multiple mock and cutover cycles through to production readiness.
• Manage file and attachment migration workstreams.

Standards & Practice

• Define and enforce delivery standards across migration workstreams, including testing frameworks, reconciliation reporting, and sign-off processes.
• Contribute to ThirdEye's internal migration methodology, reusable accelerators, and best-practice documentation.
• Support Architects during pre-sales activities by scoping migration efforts, producing estimates, and contributing to proposals and client presentations as required.

Qualifications

Technical Experience

• Delivered multiple end-to-end data migration and ETL projects in complex, multi-system environments.
• Demonstrated proficiency in SQL for legacy data profiling and transformation, and in at least one scripting language (Python preferred) for automation.
• Hands-on experience with one or more enterprise ETL tools: Azure Data Factory, Informatica, Talend, or comparable open-source tooling.
• Managed high-volume data loads with an understanding of API bulk patterns, rate limits, and governor constraints.

Consulting & Delivery Background

• Consulting background with exposure to varied clients across multiple industries or verticals.
• Seen programmes through end-to-end, from initial scoping and workshop facilitation through to UAT, cutover, and post-migration hypercare.
• Accountable for delivery outcomes on a programme of work or defined workstream, with a track record of hitting milestones in pressured environments.
• Strong workshopping and facilitation skills; able to engage both technical teams and non-technical business stakeholders with equal confidence.

Nice to Have

General

• Experience with Salesforce or other CRM data migrations.
• Familiarity with cloud data platforms (Azure Synapse, Databricks, Snowflake).
• Exposure to data governance frameworks or MDM tooling.
• Certifications in relevant platforms (e.g. Azure Data Engineer, Informatica).

Legal Sector Migrations

• Delivered data migrations from or between legal practice management systems, including platforms such as Aderant, Elite 3E, Proclaim, iManage, and MatterSphere.
• Worked hands-on with legal data structures: matters, clients, parties, time recordings, disbursements, and document/matter histories.
• Held working knowledge of legal data models such as Nebulaw, or finance/PSA platforms such as Certinia (FinancialForce).

Work Arrangement: Hybrid (Once a Month On-site)