Job description

Valleysoft is an IT services and consulting company focused on helping organizations solve complex technology challenges through enterprise software, process improvement, and digital transformation.
We work with clients to build practical, scalable solutions that strengthen operations, improve decision-making, and support long-term business change.
As a Data Warehouse (DWH) Modeler focused on banking, you will play a key role in shaping the data foundations that support critical reporting, analytics, and advanced data use cases.
This role is centered on translating complex financial processes and regulatory needs into robust, scalable data models that enable reliable access to trusted information across the enterprise.
Responsibilities Multi-Paradigm Modeling: Design a hybrid architecture utilizing Data Vault 2.
0 for core integration, while maintaining Dimensional Modeling for presentation.
Multi-Modal Data Handling: Structured: Master traditional 3NF and Star Schemas for core banking systems (Oracle/SQL Server).
Semi-Structured: Design schemas that efficiently handle JSON, XML, and Parquet formats, ensuring "schema-on-read" capabilities and efficient flattening for analytical consumption.
Unstructured: Architect metadata models and "Data Catalog" strategies to index and relate unstructured assets (PDFs, images, voice) to structured customer profiles.
Design and maintain a sophisticated data architecture using a "right tool for the job" approach—leveraging relational DBMS Modeling, Data Vault 2.
0 (Hubs, Links, and Satellites) for our scalable integration layer and Dimensional Modeling (Star/Snowflake) for our presentation layers.
Advanced History & Temporal Integrity: Architect robust History Loading strategies using Bi-temporal Modeling and Slowly Changing Dimensions (Types 2, 4, 6) "As-Of" auditability.
Banking Domain Mapping: Translate complex banking processes into models that support both traditional reporting and advanced AI/ML use cases.
Performance Engineering: Optimize storage and retrieval strategies for massive datasets, balancing the trade-o?s between relational storage and object storage (Data Lake).
Technical Toolkit We require a specialist who is fluent in the language of data architecture and historical persistence: Category Must-Have Expertise Modeling Techniques Data Vault 2.
0, Star/Snowflake, 3NF, Bi-temporal Modeling History Handling SCD (Types 1-6), Point-in-Time (PIT) & Bridge Tables, Snapshotting Modeling Tools Erwin Databases Advanced knowledge of Oracle Database and Microsoft SQL Server Integration Concepts CDC (Change Data Capture), E?ective Dating, Metadata-driven ETL Degree in Information Systems.
5+ years of experience designing enterprise data warehouse models in banking environments.
The Architect’s Mind: You don't just model for today; you build for a decade of history.
You understand that in banking, losing history is equivalent to losing money.
Temporal Specialist: You are deeply familiar with the challenges of loading historical back-feeds and managing late-arriving data without compromising the timeline.
Detail Obsessed: You bring a high level of precision to every entity.
You understand that a missing historical record is not just a technical error—it's a compliance risk.
Eligible to work in Egypt.