Senior Consultant, Data Analyst (CLM)

Location: Singapore, Singapore

About Us

Abeam Consulting is a global professional services company that specializes in delivering business transformation and technology solutions to clients across a wide range of industries. With a global presence and over 9000 employees worldwide we aim to be the transformation partner of choice for all of our clients.

• Perform data analysis and profiling of source and target systems.
• Analyze customer, KYC, onboarding, and reference data to identify data quality issues and migration risks.
• Conduct data discovery to understand data structures, relationships, and dependencies.
• Define data quality metrics and baseline assessments.

• Develop source-to-target data mapping specifications.
• Translate business requirements into functional and technical specifications.
• Define migration rules, transformation logic, and validation criteria.
• Work with stakeholders to resolve data mapping issues and gaps.

• Prepare and maintain functional and technical documents, data mappings, validation documents, test plans, and test cases.
• Ensure documentation complies with governance and audit requirements.

• Identify anomalies, duplicates, missing records, and data inconsistencies.
• Investigate root causes and recommend remediation actions.
• Execute data quality controls and support data cleansing activities.

• Validate ETL processes, migration pipelines, and transformation logic.
• Review data processing workflows and business rule implementation.
• Troubleshoot migration issues, exceptions, and data discrepancies.

• Execute UAT, mock migrations, and production migration validation.
• Perform source-to-target reconciliation and data verification.
• Validate data accuracy, completeness, and record counts.

• Partner with Business, Compliance, Operations, Data Governance, and Technology teams.
• Facilitate requirements workshops and data discussions.
• Communicate findings, risks, and recommendations to stakeholders.
• Support project governance, reporting, and issue resolution.

• Bachelor's Degree in Computer Science, Information Technology, Data Analytics, Engineering, or a related discipline.
• Minimum 10 years of experience in Data Analysis, Data Migration, Data Management, or related data-focused roles.
• Strong hands-on experience with Microsoft SQL Server and advanced SQL development.
• Proficient in complex SQL queries, including joins, stored procedures, functions, views, CTEs, performance tuning, and data validation.
• Strong understanding of relational databases, data modelling, data warehousing concepts, and data migration methodologies.
• Experience working with ETL processes, data integration, and migration pipelines.
• Proven expertise in data profiling, data mapping, data reconciliation, data quality assessment, and root cause analysis.
• Experience analyzing large and complex datasets to support data migration and transformation initiatives.
• Experience with data migration tools, frameworks, and best practices.
• Knowledge of data governance, data quality frameworks, and data management principles.
• Familiarity with Power BI or other reporting and analytics tools.
• Experience working in multinational banking or financial services environments is preferred.
• Proven experience delivering banking data transformation or migration projects is highly desirable.
• Strong analytical, problem-solving, and critical thinking skills.
• Excellent communication and stakeholder management capabilities, with the ability to collaborate effectively across business and technology teams.
• Demonstrated ability to identify data anomalies, perform root cause analysis, and drive issue resolution.
• Meticulous attention to detail with a strong commitment to data quality, accuracy, and governance.
• Self-motivated with the ability to work independently in a fast-paced, project-driven environment.