Data Analyst AB-019

INFOGAIN SOLUTIONS PTE. LIMITED; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

A leading technology solutions provider in Singapore is seeking a Senior Consultant, Data Analyst specializing in Data Migration. The ideal candidate will have over 10 years of experience in data analysis, particularly within banking or financial services. Responsibilities include data profiling, remediation, and validation, alongside developing Power BI dashboards. Excellent SQL skills are essential, as is familiarity with KYC and CLM requirements. This position offers the opportunity to work on significant data migration projects.

Qualifications

• Minimum 10 years of experience in data analysis roles, preferably with data migration.
• Strong banking or financial services experience.
• Knowledge of KYC / CLM regulatory requirements.

Responsibilities

• Perform data profiling on source and target systems.
• Execute data remediation to resolve data anomalies.
• Implement data quality checks and document findings.
• Prepare and maintain detailed documentation.
• Design test cases for data migration validation.
• Develop and maintain Power BI dashboards.

Skills

Data profiling

SQL

Power BI

Data quality assessment

Data remediation

Documentation

Collaboration

Education

Bachelor's degree

Tools

Informatica

Talend

SSIS

Job description

Role: Senior Consultant, Data Analyst - Data Migration (KYC & CLM)

Job Requisition Number: AB-19

Job Level: >10 years of relevant experience (L4)

Location: Singapore

Key Responsibilities

• Perform data profiling on source and target systems to assess data completeness, accuracy, and consistency.
• Execute data remediation activities to resolve data anomalies and ensure compliance with KYC and CLM standards.
• Implement data quality checks and document findings to support governance and audit requirements.
• Prepare and maintain detailed data profiling and remediation documentation aligned with project timelines.
• Design, prepare, and execute test cases for data migration validation.
• Create and manage test data (synthetic or masked production data) for SIT and UAT cycles.
• Perform SIT validation to ensure end‑to‑end data integrity, accuracy, and regulatory compliance.
• Collaborate with QA teams to log defects, track resolutions, and verify fixes.
• Develop, validate, and maintain Power BI dashboards to monitor data migration progress, data quality metrics, and SIT results.
• Ensure dashboards provide clear, actionable insights for project stakeholders.
• Work closely with business analysts, data architects, and developers to validate data mappings and transformations.
• Participate in remediation discussions and provide data‑driven recommendations.

Key Requirements

• Bachelor's degree in any field
• Minimum 10 years of experience in data analysis roles, preferably supporting data migration initiatives.
• Strong experience in banking or financial services projects.
• Proven expertise in data profiling, data quality assessment, and data remediation.
• Proficiency in SQL for data validation, reconciliation, and analysis.
• Hands‑on experience with Power BI for dashboard development and reporting.
• Knowledge of test case design, test data preparation, and SIT validation processes.
• Familiarity with data migration methodologies and KYC / CLM regulatory requirements.
• Strong documentation, communication, and collaboration skills.
• Experience with ETL tools such as Informatica, Talend, or SSIS is a plus.
• Exposure to data modeling, metadata management, or automation scripting for data validation is advantageous.

Technical Skills

Must‑Have:

• Strong expertise in data profiling, data quality assessment, and data remediation.
• Proficiency in SQL for data validation and reconciliation.
• Experience with Power BI for dashboard development and reporting.
• Knowledge of test case design, test data creation, and SIT validation.

Please forward your resume in MS Word format to [e-mail]