Thành thạo Kimball Data Modeling (fact, dimension, SCD Type 1/2)
Kinh nghiệm thực tế dbt, Apache Airflow, Apache NiFi, Snowflake
Hiểu Lakehouse, Delta Lake, Medallion Architecture; dùng Git, CI/CD
Trách nhiệm
Thiết kế mô hình dữ liệu theo phương pháp Kimball (fact, dimension, star/snowflake schema, SCD)
Phát triển, duy trì pipeline ETL/ELT tích hợp đa nguồn vào Data Warehouse
Giám sát chất lượng dữ liệu, xử lý sự cố, tối ưu hiệu năng SQL và pipeline
Quản lý workflow dbt, Airflow, NiFi; áp dụng CI/CD cho data pipeline
Có thì tốt
Apache Spark / PySpark xử lý dữ liệu lớn
AWS (S3, Glue, Redshift, IAM), Kafka/streaming
Kinh nghiệm ngân hàng / tài chính, Docker
Lương và phúc lợi
Dựa trên hiệu suất
Thưởng Tết, thưởng định kỳ theo quy định ngân hàng
Cho vay ưu đãi nhân viên theo chính sách ngân hàng
Nghỉ phép năm nâng cao theo cấp bậc + nghỉ hè tài trợ
Tóm tắt bằng AI từ JD gốc, đọc JD gốc trước khi ứng tuyển.
Key Responsibilities:
Data Modeling: Design and implement enterprise data models using the Kimball methodology.
ETL/ELT Development: Design, develop, and maintain robust ETL/ELT pipelines to integrate data from multiple sources into the Data Warehouse and analytical platforms.
Data Monitoring & Issue Resolution: Proactively monitor data quality and pipeline execution, investigate abnormal data patterns, troubleshoot data-related issues, and work closely with Data Analysts to identify root causes and implement corrective actions.
Data Engineering Tools: Develop and manage data transformation workflows using dbt, orchestration workflows using Apache Airflow, and data ingestion, integration using Apache NiFi.
Data Platform: Work with Redshift or other data warehouse technologies to build and optimize scalable data solutions.
Performance Optimization: Optimize SQL queries, data models, and ETL/ELT processes to improve performance, scalability, and resource utilization.
Data Quality: Implement data validation, reconciliation, testing, and monitoring mechanisms to ensure data accuracy and consistency.
CI/CD: Apply CI/CD practices to manage code versioning, testing, deployment, and release processes for data pipelines and transformation models.
Collaboration: Work with Data Analysts, Data Scientists, and business stakeholders to understand data requirements and translate them into effective technical solutions.
Documentation: Maintain technical documentation for data models, ETL processes, workflows, and data pipelines.
Requirements:
Must-have
Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field.
At least 4–5 years of experience in Data Engineering, Data Warehousing, or a related role.
Strong SQL skills, including query optimization, complex joins, window functions, and data transformation.
Solid understanding of Kimball Data Modeling, including:
Fact and Dimension Tables.
Star Schema and Snowflake Schema.
Defining the grain of fact tables.
Surrogate Keys and Natural Keys.
Slowly Changing Dimensions (SCD Type 1 and Type 2).
Good understanding of ETL/ELT architecture, data integration, and data warehouse concepts.
Hands-on experience with at least some of the following tools:
dbt: Data transformation, testing, documentation, and model management.
Apache Airflow: Workflow orchestration, DAG development, scheduling, and dependency management.
Apache NiFi: Data ingestion, integration, and flow-based data processing.
Snowflake: Data warehousing, SQL development, and performance optimization.
Experience using Git for source code management.
Understanding of CI/CD concepts and software development practices.
Understanding of Lakehouse architecture, Delta Lake, and Medallion Architecture (Bronze, Silver, Gold).
Nice to have
Hands-on experience with Apache Spark and PySpark for large-scale data processing.
Experience with cloud platforms, particularly AWS (S3, Glue, Redshift, IAM).
Experience with Kafka or other streaming technologies.
Experience in the banking or financial services industry.
Familiarity with Docker and containerization.
Benefits:
Competitive and performance-based compensation package
Holiday and Lunar New Year bonuses, subject to the Bank’s prevailing policies
Preferential staff loan programs, in accordance with bank policies
Enhanced annual leave entitlement based on job level, plus company-sponsored summer vacation
Full statutory insurance coverage as required by labor law, plus VPBank Care insurance depending on job grade and tenure
Access to comprehensive training programs, aligned with the competency framework for each position
Working schedule: Monday to Friday, and Saturday morning
Dynamic, collaborative, and growth-oriented workplace, with abundant opportunities for learning and career development
Participation in diverse employee engagement activities, including sports tournaments, talent contests, and team-building events