Senior Data Transformation Consultant

ABeam Consulting (Singapore); Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

ABeam Consulting (Singapore) is seeking a senior data transformation specialist to lead data analysis, profiling, and quality initiatives across complex source-to-target migrations in the financial services domain. You will design mapping specs, validate ETL pipelines, prepare governance-ready documentation, and partner with Business, Compliance, Operations, and Tech teams to ensure data integrity.

This role requires 10+ years in data roles, strong SQL and Power BI capabilities, and experience

Qualifications

• Bachelor's degree in CS/IT/Data Analytics/Engineering or related field.
• Minimum 10 years in data analysis, migration, data management or related roles.
• Hands-on SQL with SQL Server and advanced SQL development skills.
• Experience with ETL, data integration and migration pipelines.
• Knowledge of data governance and data quality frameworks.
• Experience in multinational banking or financial services preferred.
• Strong communication and stakeholder management abilities.
• Detail-oriented with a strong commitment to data quality and governance.

Responsibilities

• Perform data analysis and profiling of source and target systems.
• Develop source-to-target data mapping specifications and migration rules.
• Prepare functional and technical documentation and validation plans.
• Identify data anomalies and implement remediation actions.
• Validate ETL processes and migration pipelines, troubleshoot issues.
• Execute UAT, data reconciliation, and production migration validation.
• Collaborate with Business, Compliance, Operations, Data Governance and Technology teams.

Skills

Data analysis

Data migration

Data profiling

Root cause analysis

Stakeholder management

Problem solving

Communication

Attention to detail

Education

Bachelor's Degree in Computer Science, Information Technology, Data Analytics, Engineering, or a related discipline

Tools

Microsoft SQL Server

SQL development

Power BI

Job description

ABeam Consulting (Singapore) is seeking a senior data transformation specialist to lead data analysis, profiling, and quality initiatives across complex source-to-target migrations in the financial services domain. You will design mapping specs, validate ETL pipelines, prepare governance-ready documentation, and partner with Business, Compliance, Operations, and Tech teams to ensure data integrity.

This role requires 10+ years in data roles, strong SQL and Power BI capabilities, and experience