Analyzes and profiles customer, KYC, onboarding, and reference data for migration initiatives. Develops source-to-target mappings, transformation rules, validation criteria, and technical documentation. Validates ETL pipelines, executes testing and reconciliation, identifies anomalies, and supports data cleansing and issue resolution. Collaborates with business, compliance, governance, operations, and technology stakeholders to deliver data quality and transformation projects.
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.
Key Responsibilities:Data Analysis & Data Profiling
- 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.
Requirements:
- 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.
Why Join Us
At ABeam Consulting, we place a strong emphasis on collaboration, and helping our employees grow and develop their skills, offering a supportive and empowering work environment. With a presence in multiple countries and a diverse range of clients, ABeam Consulting offers an exciting and dynamic workplace for individuals looking to build a career in consulting. ABeam Consulting has also recently joined SAP’s regional strategic partner initiative as their first regional partner in the region and has also been recognized by UiPath as a Diamond Partner in providing RPA solutions. With such accolades, we aim to continue driving enterprise and digital transformation initiatives in order to transform the way people work and communicate in the digital age. In addition, our industry team is working tirelessly in order to bring more solutions to the banking and finance sector.
We regret only shortlisted candidates will be notified.
ABeam Consulting Southeast Asia (SEA) Singapore, Singapore, SGP Office
Singapore, Singapore
Similar Jobs
Business Intelligence • Consulting
Leads data migration and analysis projects for KYC and CLM platforms. Gathers requirements, documents business rules and data mappings, analyzes data quality and lineage, defines cleansing and transformation rules, and validates migration results through SIT. Coordinates business, technical, QA, and architecture stakeholders; tracks defects, remediation, risks, and project progress. Supports project planning, client presentations, stakeholder management, and business development.
Top Skills:
ETLInformaticaPower BISQLSsisTableauTalend
Business Intelligence • Consulting
Lead data migration analysis projects involving source and target data profiling, remediation, quality checks, SQL validation, test case design, SIT and UAT validation, and Power BI dashboard development. Collaborate with business analysts, architects, developers, and QA teams to validate mappings, transformations, defects, and regulatory compliance for KYC and CLM initiatives. Coordinate project teams, maintain documentation, provide recommendations, and support client proposals and business development.
Top Skills:
InformaticaPower BISQLSsisTalend
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Design and implement cross-platform APIs and test automation for Enterprise SSD validation. Integrate test equipment, define and execute automation strategies, collaborate with cross-functional teams, troubleshoot SSD/software integration, improve validation coverage, and maintain documentation of methodologies and results.
Top Skills:
Device DriversFirmwareLinux KernelOperating System ApisPciePythonSsdTest AutomationUmlWindows Driver
What you need to know about the Singapore Tech Scene
The digital revolution has driven a constant demand for tech professionals across industries like software development, data analytics and cybersecurity. In Singapore, one of the largest cities in Southeast Asia, the demand for tech talent is so high that the government continues to invest millions into programs designed to develop a talent pipeline directly from universities while also scaling efforts in pre-employment training and mid-career upskilling to expand and elevate its workforce.
