Analyze business requirements and translate them into data requirements and data models across the data warehouse lifecycle.
Work with data from source systems through staging (RAW/STG), data model layers, and Data Marts, aligned with departmental reporting and analytics needs.
Design and define database tables (DDL), data structures, and relationships to support reporting and analytics use cases.
Perform data analysis using advanced SQL to validate business logic, ensure data accuracy, and support decision-making.
Collaborate closely with Data Engineers, stakeholders, and business users to clarify requirements and ensure correct data implementation.
Participate in data mapping, data modeling, and integration activities across systems.
Identify, analyze, and resolve data-related and business logic issues throughout the data pipeline.
Prepare and maintain business and system documentation such as BRD, SRS, and data specifications.
Continuously learn and adapt to new data domains, systems, and business processes within Banking projects.
Requirements
Core Skills (Must-have)
25 years of experience as a Data Business Analyst / Data Analyst / Software BA working with data platforms.
Very strong SQL skills, including:
Query optimization (indexes, partitions, CTEs)
Understanding of physical data storage formats (row-based vs. column-based).
Solid experience working with Data Warehouse concepts, including:
CDC (Change Data Capture)
SCD (especially Type 2; Type 4 is a plus)
Star and Snowflake schemas
Hands-on experience working across multiple data layers:
Source / RAW / STG
Data Model layers
Data Mart (based on business or department requirements).
Ability to design data tables and schemas (DDL) with a clear, logical structure.
Strong logical thinking and problem-solving skills for data and business scenarios.
Experience analyzing business problems and configuring data solutions to meet business needs.
Ability to troubleshoot data issues and resolve business-related data inconsistencies.
Good documentation skills: capable of writing BRD, SRS, and data-related specifications.
Nice to Have
Knowledge or experience with System of Record (SOR) modeling.
Experience in Banking / Financial Services projects.
Exposure to integration projects involving data mapping and data modeling.
Deeper understanding of banking and financial business processes is a plus.
English: Not required (English proficiency is a plus).
Benefits
Attractive compensation package: 14-month salary scheme plus annual bonus and additional allowances
Annual bonus package tailored based on performance and contribution
Young, open, and dynamic working environment that promotes innovation and creativity
Ongoing learning and development with regular professional training and opportunities to enhance both technical and soft skills
Exposure to cutting-edge technologies and diverse real-world enterprise projects
Vibrant company culture with regular team-building activities, sports tournaments, arts events, Family Day, and more
Full compliance with Vietnamese labor laws, plus additional internal perks such as annual company trips, special holidays, and other corporate benefits
How To Apply
Please send your application via email: [Confidential Information]
2+ years of experience
By submitting your application to [HIDDEN TEXT], you acknowledge that you have read, understood, and agreed to CMC Global's REGULATIONS ON THE PROTECTION OF CANDIDATES PERSONAL INFORMATION.
