In short
Senior data warehouse modeling engineer serving a bank: designs the 3NF foundational layer and Kimball dimensional (fact/dimension) models, defines modeling standards and unified metric calibers, documents ETL mappings, and optimizes model performance and costs. Core stack is SQL plus dimensional/3NF modeling and data governance; banking/finance experience preferred. RM 15,000–20,000/month, on-sit
About the role
Salary: RM 15,000 – RM 20,000 per month
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.
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.
数据仓库建模工程师(高级)
工作职责
负责数据仓库模型设计,包括基础模型层、公共汇总层的表结构规划、字段定义及加工逻辑映射,保障模型架构的合理性与扩展性。
梳理各业务系统的业务逻辑与数据血缘,基于3NF完成基础层主题域建模,支撑全行跨域数据整合与统一归口管理。
基于Kimball维度建模方法论(星型/雪花模型)完成事实表与维度表设计,将报表、看板、BI、专题分析等场景的共性需求沉淀为可复用公共汇总模型,统一指标口径与加工逻辑,消除跨团队、跨应用的口径冲突,大幅降低重复开发成本。
制定并落地建模规范,涵盖表与字段命名、编码规则、分区策略、主外键约束、元数据标准,保障全库模型的一致性、规范性与可维护性。
编写并维护模型设计文档、数据字典、ETL映射逻辑文档,沉淀模型资产,提升团队协作与后续运维效率。
负责模型日常迭代优化,针对性解决模型冗余、查询性能、存储与计算成本过高、响应速度慢等核心问题。
任职要求
本科及以上学历,计算机、软件工程、数据科学、数学等相关专业;3年以上数据仓库建模经验,有银行、金融、电信等行业项目经验者优先。
熟练掌握数据仓库分层理论、3NF建模、维度建模及缓慢变化维度处理策略。
具备指标体系设计经验,能清晰定义指标口径及原子指标/派生指标关系;有指标平台或指标管理落地经验者优先。
熟悉主数据、数据标准化及数据质量等数据治理体系,具备较强的数据质量意识,可独立完成数据问题的定位与排查。
熟练使用SQL完成数据探查与校验,能独立完成源系统级数据调研,精准识别数据特征与业务规则。
具备良好的逻辑思维与沟通能力,能将源系统业务逻辑转化为规范模型,将业务分析诉求转化为指标体系,注重口径统一与准确性,具备团队协作经验。
优先条件
有银行或金融行业数据仓库/数据平台模型设计经验。
熟悉IBM FSDM或TD FSDM行业数据模型理论与实践方法。
有客户主数据项目实施经验。