Senior Consultant

WEB SYNERGIES (S) PTE LTD; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

A leading consulting firm in Singapore is seeking an experienced Business Analyst to focus on data migration initiatives in banking or financial services. The ideal candidate should have at least 10 years of experience, strong SQL skills, and proficiency in data migration lifecycle processes. Responsibilities include gathering and analyzing requirements, documenting data mappings, and ensuring regulatory compliance. This role offers a dynamic work environment with opportunities for professional growth.

Qualifications

• Minimum 10 years of experience as a Business Analyst, preferably in data migration.
• Solid understanding of data migration lifecycle, data reconciliation, and validation.
• Excellent communication skills for stakeholder management.

Responsibilities

• Gather and analyze business requirements with stakeholders.
• Document business rules and data mappings.
• Execute test cases for data migration and validation.

Skills

SQL proficiency

Stakeholder management

Data migration lifecycle understanding

Documentation skills

ETL tools experience

Regulatory compliance knowledge

Education

Bachelor's degree

Tools

Informatica

Talend

SSIS

Power BI

Tableau

Job description

Responsibilities:

• Gather and analyze business requirements through discussions with business stakeholders, SMEs, and technical teams.
• Create and maintain ARD, BRD, data dictionaries, and reporting requirement documents.
• Document business rules, source-to-target data mappings, and data transformation logic.
• Analyze source system data structures, data quality, and data lineage to support migration activities.
• Define and maintain master data mappings and report mappings for CLM and eKYC platforms.
• Specify data cleansing, standardization, and enrichment rules to ensure data quality.
• Design, prepare, and execute test cases for data migration and reporting validation.
• Prepare test data and support multiple System Integration Testing (SIT) cycles.
• Perform SIT validation to ensure data accuracy, completeness, and regulatory compliance.
• Log defects, track resolution, and participate in remediation and root-cause discussions.
• Ensure traceability across requirements, data mappings, test cases, and SIT results.
• Collaborate closely with business users, data architects, developers, QA teams, and project stakeholders.
• Provide regular updates on project progress, risks, issues, and remediation plans.

Requirements:

• Bachelor's degree in any field
• Minimum 10 years of experience as a Business Analyst, preferably in data migration initiatives.
• Strong experience in banking or financial services projects.
• Solid understanding of data migration lifecycle, data reconciliation, and validation.
• Proficiency in SQL for data analysis, profiling, and reconciliation.
• Hands-on experience with ETL tools (e.g., Informatica, Talend, SSIS).
• Experience in test case design, execution, and SIT validation.
• Strong documentation skills (ARD, BRD, mappings, data dictionaries).
• Excellent stakeholder management and communication skills.
• Knowledge of KYC and CLM processes and regulatory compliance, exposure to BI tools (Power BI, Tableau), familiarity with data quality frameworks, metadata management, or automation for data validation and prior consulting firm experience and leadership exposure are a plus.