Senior Data Engineer - Risk Data- Ho Chi Minh
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