Data Migration Consultant

I-Novate Arabia DMCC; Dubai; On-site; AED 300,000 - 420,000; Full time

Job summary

I-Novate Arabia DMCC is seeking an ETL & Data Engineer to design, build and maintain data pipelines powering a large-scale digital transformation program. The role spans data migration, ETL/ELT integration, data platform engineering and BI enablement across SAP S/4HANA, Salesforce Automotive Cloud and Proaxia.

You will work closely with ETL leads, reporting teams and implementation partners to ensure accurate, secure data movement, quality and timely analytics.

Qualifications

• 5–8 years in ETL development, data integration or data engineering

Responsibilities

• Design, develop and run ETL/ELT pipelines for enterprise data integration
• Plan and execute migration of data from legacy systems to SAP S/4HANA, Salesforce and Proaxia
• Build and maintain the enterprise data platform and its staging, integration and presentation layers
• Prepare curated, business-ready datasets for reporting and analytics and partner with BI teams
• Define and run data quality checks for accuracy, completeness, consistency and timeliness
• Document ETL processes, data mappings, transformation logic and platform designs

Skills

ETL development

Data integration

Data engineering

SQL

Python

Power BI

SAP Analytics Cloud

Data modelling

CI/CD

Tools

Azure Data Factory

Informatica

Talend

SAP Data Services

Azure Synapse

Databricks

Snowflake

Airflow

Git

CI/CD pipelines

Microsoft Purview

Collibra

Job description

Candidates from India also can apply .

Data Migration

We are seeking an ETL & Data Engineer to build, run and maintain the data pipelines, platforms and datasets that underpin a large-scale digital transformation program.

The role combines hands-on ETL analysis with data engineering. It covers four areas: data migration, ETL and data integration, data platform engineering, and data analytics & BI enablement.

The ETL Analyst & Data Engineer will work closely with the ETL Lead, reporting teams, functional teams and implementation partners. Together they will ensure accurate, secure and efficient movement of data across SAP S/4HANA, Salesforce Automotive Cloud, Proaxia VSS and other integrated platforms.

The role is central to data quality, reconciliation and consistency across systems, during implementation and through post-go-live operations.

Key Responsibilities

1. ETL & Data Integration

• Design, develop and run ETL/ELT pipelines for enterprise data integration
• Extract data from SAP ERP, Salesforce, operational support systems and external sources
• Transform, cleanse and enrich data for target systems and reporting platforms
• Map source data structures to target data models and maintain mapping specifications
• Build batch and near-real-time integrations using APIs, files and database connectors
• Schedule, orchestrate and monitor pipeline jobs, handling failures and reruns
• Tune pipeline and SQL performance for volume and load windows

2. Data Migration

• Plan and execute migration of master and transactional data from legacy systems to SAP S/4HANA, Salesforce and Proaxia
• Build repeatable migration scripts and load programs for mock loads, dress rehearsals and cutover
• Run pre-load and post-load validation and reconciliation (record counts, financial balances, key fields)
• Manage data cleansing and de-duplication with business data owners
• Support SIT, UAT and cutover activities, including defect triage and resolution
• Maintain migration trackers, load logs and sign-off evidence

3. Data Platform Engineering

• Build and maintain the enterprise data platform (data warehouse, data lake or lakehouse) and its staging, integration and presentation layers
• Design data models (dimensional, star/snowflake schemas) for analytics and reporting
• Implement data pipeline frameworks, reusable components and engineering standards
• Apply version control, CI/CD and automated testing to data pipelines
• Implement role-based access, data masking and encryption in line with security and privacy policies
• Monitor platform health, capacity, cost and performance
• Support integration of cloud data services (e.g. Azure, SAP BTP / Datasphere)

4. Data Analytics & BI Enablement

• Prepare curated, business-ready datasets and semantic models for reporting
• Partner with reporting teams building dashboards in Power BI, SAP Analytics Cloud and other enterprise tools
• Develop KPIs, measures and data marts for sales, after-sales, finance and operations
• Perform ad-hoc data analysis to answer business questions and validate reports
• Ensure pipelines deliver timely, reliable data for operational and management reporting

5. Data Quality & Governance

• Define and run data quality checks for accuracy, completeness, consistency and timeliness
• Investigate and resolve data discrepancies across systems
• Reconcile data between legacy systems and new platforms
• Maintain data lineage, data dictionaries and metadata
• Apply enterprise data governance, master data and data protection standards

6. Documentation & Process Support

• Document ETL processes, data mappings, transformation logic and platform designs
• Maintain migration, integration and runbook documentation
• Support the ETL Lead in setting data engineering and transformation standards
• Provide hypercare and knowledge transfer to support teams after go-live

7. Program Scope

The role supports data migration, integration, platform and reporting work across:

• SAP S/4HANA ERP
• Salesforce Automotive Cloud
• Proaxia Vehicle Sales & Service (VSS)
• Document management systems such as Doxis
• Digital signature platforms such as DocuSign
• Payment gateways and external transaction systems
• Enterprise data platform (data warehouse / lakehouse)
• Reporting and analytics platforms (Power BI, SAP Analytics Cloud)

8. Required Experience & Skills

Must-Have

• 5–8 years in ETL development, data integration or data engineering roles
• Proven delivery of ETL/ELT pipelines from extraction through load and monitoring
• Strong SQL and relational database skills (query tuning, stored procedures, data modelling)
• Hands-on experience in at least one enterprise data migration or system integration project
• Working knowledge of data warehousing concepts and dimensional modelling
• Scripting in Python (or similar) for data processing and automation
• Experience preparing datasets for BI tools such as Power BI or SAP Analytics Cloud
• Strong analytical, problem-solving and reconciliation skills
• Ability to work with technical teams, business stakeholders and implementation partners

Nice-to-Have

• SAP data experience: S/4HANA data structures, SAP Migration Cockpit, SAP Data Services, SAP Datasphere / BW
• Salesforce data experience: Data Loader, APIs, Automotive Cloud objects
• ETL / integration tools: Azure Data Factory, Informatica, Talend, SAP Data Services
• Cloud data platforms: Azure Synapse, Microsoft Fabric, Databricks or Snowflake
• Orchestration and DevOps: Airflow, Git, CI/CD pipelines
• Data quality and governance tools (e.g. Microsoft Purview, Collibra)
• Power BI data modelling (DAX, Power Query)
• Automotive retail or dealer management data
• Experience in GCC-based digital transformation programs
• Certifications such as Microsoft Azure Data Engineer Associate, Fabric Analytics Engineer, or SAP data certifications

Key Success Metrics

• Migration loads completed on schedule and reconciled with business sign-off
• Reliable, monitored pipelines with minimal failed or late loads
• High data quality and consistency across enterprise systems
• Timely delivery of trusted datasets for reporting and analytics
• A scalable, secure and well-documented data platformFast resolution of data discrepancies and pipeline incidents

Reporting Line

Reports to: Enterprise Architecture & Integration Manager

Works closely with:

• Enterprise Architect
• Integration Architect
• Data Migration Lead
• Reporting & Analytics Teams
• SAP Functional Teams
• Salesforce Product Teams
• Infrastructure, Cloud & Information Security Teams
• Implementation Partners

Digital Transformation