Data Migration Analyst

77GSI; Pasig; On-site; PHP 700,000 - 1,100,000; Full time

Job summary

77GSI is seeking a Data Migration & Data Quality Analyst to analyze, profile, cleanse, validate, transform, and prepare data from a legacy ERP system for migration to a new ERP platform. The role requires a highly analytical, independent individual who can assess data quality issues and make fact-based recommendations on data cleansing and migration decisions.

Hands-on experience with large-scale ERP data migration is preferred, involving complex transactional data.

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Information Systems, Data Analytics, Business Analytics, Accounting, or a related discipline.
• 5+ years of relevant experience in data analysis, data migration, data quality, ERP implementation, or related areas.
• Demonstrated experience in large-scale ERP data migration projects.
• Hands-on experience performing data profiling, cleansing, transformation, validation, and reconciliation.
• Experience working with SQL and relational databases.

Responsibilities

• Analyze, profile, cleanse, validate, transform, and prepare data from legacy ERP for migration.
• Assess data quality issues and recommend treatment for inconsistent or incomplete records.
• Collaborate with business process owners, ERP functional teams, technical teams, vendors, and project management to ensure data readiness.
• Support data mapping, migration testing, and reconciliation activities.

Skills

Data analysis

ERP data migration

Data quality

SQL

Data profiling

Data cleansing

Data transformation

Data validation

Data reconciliation

Data mapping

Transaction data

Education

Bachelor's degree in Information Technology/Computer Science/Information Systems/Data Analytics/Accounting

Tools

Power Query/Power BI

SQL Server

Oracle

ETL tools

Job description

The Data Migration & Data Quality Analyst will be responsible for analyzing, profiling, cleansing, validating, transforming, and preparing data from the organization's legacy ERP system for migration to a new ERP platform.

The role requires a highly analytical and independent individual who can assess data quality issues, determine appropriate treatment of inconsistent or incomplete records, and make fact-based recommendations on data cleansing and migration decisions.

The successful candidate should have hands-on experience in large-scale ERP data migration, preferably involving complex transactional data, and be comfortable working as an individual contributor with limited day-to-day supervision.

The position will work closely with business process owners, ERP functional teams, technical teams, vendors, and project management to ensure that migrated data is accurate, complete, consistent, traceable, and fit for use in the new ERP.

The Data Migration & Data Quality Analyst will be responsible for analyzing, profiling, cleansing, validating, transforming, and preparing data from the organization's legacy ERP system for migration to a new ERP platform.

The role requires a highly analytical and independent individual who can assess data quality issues, determine appropriate treatment of inconsistent or incomplete records, and make fact-based recommendations on data cleansing and migration decisions.

The successful candidate should have hands-on experience in large-scale ERP data migration, preferably involving complex transactional data, and be comfortable working as an individual contributor with limited day-to-day supervision.

The position will work closely with business process owners, ERP functional teams, technical teams, vendors, and project management to ensure that migrated data is accurate, complete, consistent, traceable, and fit for use in the new ERP.

Required QualificationsEducation

• Bachelor's degree in Information Technology, Computer Science, Information Systems, Data Analytics, Business Analytics, Accounting, or a related discipline.

Experience

Required:

• 5+ years of relevant experience in data analysis, data migration, data quality, ERP implementation, or related areas.
• Demonstrated experience in large-scale ERP data migration projects.
• Hands-on experience performing data profiling, cleansing, transformation, validation, and reconciliation.
• Experience working with large and complex datasets.
• Experience dealing with master data and transactional data.

Preferred:

• Experience with ERP platforms.
• Experience in insurance, financial services, brokerage, accounting, supply chain, or other transaction-intensive environments.
• Experience participating in ERP replacement or legacy-system modernization projects.
• Experience working with SQL and relational databases.

Technical Skills

The candidate should have strong practical knowledge of:

• SQL
• Relational databases
• Excel / advanced Excel
• Data profiling
• Data cleansing
• Data transformation
• Data validation
• Data reconciliation
• Data mapping
• Data quality management
• ETL concepts
• Source-to-target mapping
• Master data management
• Transactional data analysis
• Data migration methodologies

Preferred tools/technologies:

• Power Query / Power BI
• Python for data analysis and cleansing
• SQL Server / Oracle / other enterprise databases
• ETL/data integration tools
• Data quality or profiling tools