全职 Technical Data Analyst 工作, 薪水 up to SGD 8,000, VINE INFOTECH PRIVATE LIMITED Central Region (Singapore) 公司招聘中 - Ricebowl

*Responsibilities:*

*Data Analysis & Data Profiling*

·      Perform detailed analysis and profiling ofsource and target system data to assess data quality, identify inconsistencies,and mitigate migration risks.

·      Analyze customer, KYC, onboarding, and referencedata to identify data quality issues, anomalies, and business impacts.

·      Conduct data discovery and assessment exercisesto understand data structures, relationships, and dependencies.

·      Define and monitor data quality metrics,baseline assessments, and governance controls throughout the migrationlifecycle.

*Data Mapping & Migration Design*

·      Develop comprehensive source-to-target datamapping specifications.

·      Translate business requirements into detailedfunctional and technical specifications.

·      Define migration rules, transformation logic,enrichment requirements, validation criteria, and reconciliation processes.

·      Collaborate with business stakeholders toresolve data ambiguities, mapping gaps, and data-related issues.

*Data Quality & Anomaly Detection*

·      Analyze data to identify anomalies, duplicates,missing records, and data inconsistencies.

·      Investigate root causes of data quality issuesand recommend remediation strategies.

·      Define and execute data quality controls toensure data integrity throughout the migration lifecycle.

·      Support data cleansing, enrichment, andremediation initiatives.

*ETL & Migration Pipeline Validation*

·      Partner with ETL developers and technical teamsto validate migration pipelines and data transformation processes.

·      Review ETL designs, transformation logic, anddata processing workflows to ensure alignment with business rules.

·      Troubleshoot migration failures, exceptions,reconciliation discrepancies, and performance issues.

·      Validate data transformations and migrationoutcomes against agreed business requirements.

*Testing & Reconciliation*

·      Design and execute migration testing activities,including User Acceptance Testing (UAT), mock migrations, dry runs, andproduction validation.

·      Perform detailed source-to-target reconciliationto ensure data completeness, accuracy, and consistency.

·      Validate record counts, data integrity,transformation results, and migration success criteria.

·      Support defect tracking, issue resolution, andtest result reporting.

*Requirements:*

·      Proven experience working within Banking orFinancial Services environments.

·      Strong understanding of KYC/eKYC processes,customer onboarding, Customer Due Diligence (CDD), and regulatory compliancedata requirements.

·      Experience delivering large-scale datamigration, transformation, or modernization programs.

·      Strong hands-on experience with Microsoft SQLServer.

·      Advanced SQL development and querying skills,including complex joins, stored procedures, functions, views, Common TableExpressions (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, dataintegration processes, and data transformation workflows.

·      Demonstrated expertise in data profiling, datamapping, data reconciliation, data quality assessment, and root cause analysis.

·      Ability to analyze, interpret, and validatelarge and complex datasets.

·      Experience with source-to-target mapping,migration rule definition, and data validation activities.

·      Strong analytical, troubleshooting, andproblem-solving skills with the ability to identify data anomalies and driveresolution.

·      Experience in banking data transformation,migration, or regulatory data programs is highly preferred.

·      Knowledge of data governance principles and dataquality frameworks is advantageous.

·      Experience with data migration tools,frameworks, and automation solutions is preferred.

·      Knowledge of Power BI or other reporting andanalytics platforms is an added advantage.

·      Experience working in multinational or regionalbanking environments is preferred.