Data Warehouse Modeling Engineer (Senior) - Mandarin Speaker

Key Responsibilities

1. Take charge of data warehouse model design, including table structure planning, field definition and processing logic mapping for the foundational model layer and common summary layer, to ensure the rationality and scalability of the model architecture.
2. Sort out business logic and data lineage of various business systems, and conduct foundational-layer subject domain modeling based on 3NF to support cross-domain data integration and unified centralized management across the bank.
3. Design fact tables and dimension tables following the Kimball dimensional modeling methodology (star schema / snowflake schema). Settle common requirements for reports, dashboards, BI and special analysis into reusable common summary models, unify metric calibers and processing logic, eliminate caliber conflicts across teams and applications, and significantly reduce redundant development costs.
4. Formulate and implement modeling specifications, covering table and field naming, coding rules, partitioning strategies, primary and foreign key constraints, and metadata standards, to guarantee the consistency, standardization and maintainability of models in the entire warehouse.
5. Compile and maintain model design documents, data dictionaries and ETL mapping logic documents, accumulate model assets, and improve team collaboration and subsequent O&M efficiency.
6. Be responsible for daily iteration and optimization of models, and targetedly resolve core issues such as model redundancy, query performance bottlenecks, excessive storage and computing costs, and slow response.

Requirements

1. Bachelor's degree or above, majoring in Computer Science, Software Engineering, Data Science, Mathematics or related disciplines; at least 3 years of data warehouse modeling experience. Prior experience in banking, finance, telecommunications or other relevant industries is preferred.
2. Proficient in data warehouse layering theory, 3NF modeling, dimensional modeling, and handling strategies for slowly changing dimensions.
3. Hands-on experience in metric system design, capable of clearly defining metric calibers and the relationship between atomic metrics and derived metrics; experience in implementing metric platforms or metric management is preferred.
4. Familiar with master data, data standardization, data quality and other data governance frameworks, with strong awareness of data quality, and capable of independently identifying and troubleshooting data issues.
5. Proficient in SQL for data exploration and validation, able to independently conduct data research on source systems, and accurately identify data characteristics and business rules.
6. Possess sound logical thinking and communication skills. Able to translate business logic of source systems into standardized models and business analysis demands into metric systems, with emphasis on caliber unification and accuracy, and experience in team collaboration.
7. Mandarin is a MUST

Nice to Have

1. Practical experience in data warehouse / data platform model design within banking or financial industries.
2. Familiar with the theories and implementation practices of IBM FSDM or TD FSDM industry data models.
3. Experience in customer master data project delivery.