Senior Data Warehouse Modeling Architect
Posted Updated
Description
Click Global Talent is seeking a Senior Data Warehouse Modeling Engineer to lead the design of data warehouse models, including table structures, field definitions, and processing logic for foundational and common summary layers, ensuring scalability and consistency.
You will define 3NF foundational models, establish star/snowflake schemas, document metadata and ETL mappings, and optimize for performance and cost while collaborating with cross‑functional teams in a banking context.
Lead data warehouse model design including table structure, field definitions and processing logic for foundational and common summary layers. Define business logic and data lineage across multiple systems to support cross‑domain integration. Design fact and dimension tables using Kimball methodologies (star/snowflake) and unify metrics. Formulate modeling specifications: naming, partitioning, constraints and metadata standards. Create and maintain model design docs, data dictionaries and ETL mappings to improve collaboration and O&M efficiency. Iterate daily to optimize models, address redundancy, performance bottlenecks and storage/cost issues. Bachelor’s degree or above in Computer Science, Software Engineering, Data Science, Mathematics or related disciplines; at least 3 years of data warehouse modeling experience. Proficient in data warehouse layering theory, 3NF modeling, dimensional modeling, and SCD handling. Hands-on experience in metric system design and defining metric calibers and relationships. Familiar with master data, data quality and governance frameworks; strong data quality awareness. Able to translate business logic into standardized models and metrics; strong communication. Banking/Financial industry experience FSDM/TD-FSDM data model familiaritySkills
Sign in to read and join the discussion.