Technical Data Analyst (Banking Industry)

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. Responsibilities: Data Analysis & Data Profiling Perform detailed analysis and profiling of source and target system data to assess data quality, identify inconsistencies, and mitigate migration risks. Analyze customer, KYC, onboarding, and reference data to identify data quality issues, anomalies, and business impacts. Conduct data discovery and assessment exercises to understand data structures, relationships, and dependencies. Define and monitor data quality metrics, baseline assessments, and governance controls throughout the migration lifecycle. Data Mapping & Migration Design Develop comprehensive source-to-target data mapping specifications. Translate business requirements into detailed functional and technical specifications. Define migration rules, transformation logic, enrichment requirements, validation criteria, and reconciliation processes. Collaborate with business stakeholders to resolve data ambiguities, mapping gaps, and data-related issues. Technical & Functional Documentation Create and maintain Functional Specifications, Technical Documents, Data Mapping Documents, Validation & Reconciliation Reports, Test Plans, and Test Cases. Ensure all documentation complies with project governance, regulatory, and audit requirements. Maintain accurate and up-to-date project artifacts to support migration execution and knowledge transfer. Data Quality & Anomaly Detection Analyze data to identify anomalies, duplicates, missing records, and data inconsistencies. Investigate root causes of data quality issues and recommend remediation strategies. Define and execute data quality controls to ensure data integrity throughout the migration lifecycle. Support data cleansing, enrichment, and remediation initiatives. ETL & Migration Pipeline Validation Partner with ETL developers and technical teams to validate migration pipelines and data transformation processes. Review ETL designs, transformation logic, and data processing workflows to ensure alignment with business rules. Troubleshoot migration failures, exceptions, reconciliation discrepancies, and performance issues. Validate data transformations and migration outcomes against agreed business requirements. Testing & Reconciliation Design and execute migration testing activities, including User Acceptance Testing (UAT), mock migrations, dry runs, and production validation. Perform detailed source-to-target reconciliation to ensure data completeness, accuracy, and consistency. Validate record counts, data integrity, transformation results, and migration success criteria. Support defect tracking, issue resolution, and test result reporting. Stakeholder Management Collaborate with Business Users, Compliance, Operations, Data Governance, and Technology teams to gather requirements and address data challenges. Facilitate workshops and stakeholder discussions to clarify requirements, resolve issues, and drive decision-making. Communicate analysis findings, project risks, recommendations, and status updates to project stakeholders. Support project governance activities, status reporting, and issue management to ensure successful project delivery. 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 disciplines. Proven experience working within Banking or Financial Services environments. Strong understanding of KYC/eKYC processes, customer onboarding, Customer Due Diligence (CDD), and regulatory compliance data requirements. Experience delivering large-scale data migration, transformation, or modernization programs. Strong hands-on experience with Microsoft SQL Server. Advanced SQL development and querying skills, including complex joins, stored procedures, functions, views, Common Table Expressions (CTEs), performance optimization, and data validation queries. Strong understanding of relational databases, data modelling, data warehousing concepts, and data migration methodologies. Experience working with ETL pipelines, data integration processes, and data transformation workflows. …