Assistant Manager, Data Analytics

Sumitomo Mitsui Banking Corporation; Kuala Lumpur; On-site; MYR 100,000 - 150,000; Full time

Job summary

A multinational banking corporation in Kuala Lumpur seeks a skilled data management professional with over 5 years of experience. The ideal candidate will have expertise in advanced SQL, data analysis tools, and Power BI. Responsibilities include data migration, ensuring data quality through comprehensive auditing, and developing strategies for Master Data Management. This role requires effective communication and problem-solving skills, making it essential for maintaining high data quality standards.

Qualifications

• 5+ years of experience in data science or data analytics.
• Expert-level proficiency in writing complex SQL queries.
• Experience in building reports in Power BI.

Responsibilities

• Analyze source systems to define data structures for mapping documentation.
• Define business rules and transformation logic for data migration.
• Conduct audit checks to ensure zero data loss during migrations.
• Develop and enforce rules for Master Data Management.
• Build dashboards to monitor data health and migration progress.

Skills

Advanced SQL

Data Analysis Tools

Data Visualization

Data Profiling

Data Quality Monitoring

Education

Bachelor's degree in relevant field

Tools

Power BI

Excel

Job description

Responsibilities

• Source-to-Target Mapping: Analyze source systems to define data structures and create comprehensive mapping documentation for target systems.
• Migration Logic: Define the business rules and transformation logic required to move data while maintaining referential integrity.
• Validation & Reconciliation: Perform audit checks (row counts, hash totals, and logic testing) to ensure zero data loss during migrations.
• Legacy Decommissioning: Validate that data is successfully transitioned before legacy databases are archived or sunset.
• Master Data Management (MDM) & Governance — MDM Strategy: Develop and enforce rules for creating "Golder Records" (e.g., merging duplicate customer or product entries).
• Data Profiling: Conduct deep-dive analysis using SQL to identify anomalies, duplicates, and quality gaps in large datasets.
• Documentation: Maintain the enterprise data dictionary, metadata repositories, and data lineage maps.
• Standardization: Establish naming conventions and data standards across the organization.
• Quality & Monitoring — Data Cleaning: Identify "dirty" data and define the logic for normalization and enrichment.
• Health Reporting: Build dashboards (e.g., in Power BI or Excel) to monitor data health and track migration progress.

Qualifications

• Working Experience (Years / Type): Bachelor\'s degree with 5+ years of experience in data science or data analytics.
• Advanced SQL: Expert-level proficiency in writing complex queries to audit, join, and profile data.
• Proficient in Data Analysis Tools: Advanced Excel (Pivot Tables, VLOOKUPs, Data Modeling) for reconciliations.
• Visualization: Experience building reports in Power BI or similar tools.
• Data Expertise: Strong understanding of relational database design and Master Data Management (MDM) principles.
• Experience in conducting data discovery, performing root cause analysis and making recommendations for data quality issues resolution.
• Experience in managing metadata and master data management.
• Effective communication, presentation and influencing skills.