JOB DESCRIPTION
- 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)
- 2–5 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: [email protected]
*By submitting your application to [email protected], you acknowledge that you have read, understood, and agreed to CMC Global’s REGULATIONS ON THE PROTECTION OF CANDIDATES’ PERSONAL INFORMATION.
-
Years of Experience Required
2+ years of experience
-
Required Education Level
Bachelor’s Degree
-
Job Level
Middle/Senior
-
Work Form
Full-time
-
Email: [email protected]