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 ProfilingPerform 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 DesignDevelop 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 DocumentationCreate 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 DetectionAnalyze 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 ValidationPartner 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 & ReconciliationDesign 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 ManagementCollaborate 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.Demonstrated expertise in data profiling, data mapping, data reconciliation, data quality assessment, and root cause analysis.Ability to analyze, interpret, and validate large and complex datasets.Experience with source-to-target mapping, migration rule definition, and data validation activities.Strong analytical, troubleshooting, and problem-solving skills with the ability to identify data anomalies and drive resolution.Excellent communication and stakeholder management skills, with the ability to collaborate effectively across business and technology teams.Strong attention to detail and commitment to maintaining high data quality standards.Ability to work independently and manage multiple priorities in a fast-paced project environment.Experience in banking data transformation, migration, or regulatory data programs is highly preferred.Knowledge of data governance principles and data quality frameworks is advantageous.Experience with data migration tools, frameworks, and automation solutions is preferred.Knowledge of Power BI or other reporting and analytics platforms is an added advantage.Experience working in multinational or regional banking environments is preferred.Why Join UsAt 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.