Data Warehouse (DWH) Modeler (Banking)
USD 111K-155K (estimate) Senior-level Full Time
Tasks
- Architect unstructured data catalog and metadata models
- Build data vault 20 hubs links satellites
- Create dimensional models star schema
- Design data warehouse models
- Design semi structured schema on read for JSON XML and Parquet
- Develop history loading and as of auditability
- Implement bi temporal modeling and slowly changing dimensions
- Model banking processes for reporting and AI ML
- Model relational 3NF schemas
- Optimize storage and retrieval for massive datasets
Perks/Benefits
- N/A
Skills/Tech-stack
Bi temporal Modeling | Bridge tables | CDC | Change Data Capture | Data Capture | Data Catalog | Data Lake | Data Vault | Data Vault 2.0 | Dimensional Modeling | ETL | JSON | Metadata Management | Microsoft SQL | Microsoft SQL Server | Oracle Database | Parquet | Point In Time | SQL Server | Slowly Changing Dimensions | Snowflake Schema | Star Schema | Temporal modeling | Third Normal Form | Type 2) | Type 4 | Type 6 | XML
Education
Roles
Architect | Data Architect | Data Warehouse Modeler | Modeler
Related jobs
-
Data Analytics Architect USD 112K-196KAccess Control | Cloud Computing | Containerization | Cybersecurity | Data GovernanceFlexible schedule | TDY opportunities | Travel opportunitiesSenior-level Full TimeUSA VA Alexandria (5825 Barclay Drive), …2d ago
-
Senior-level Full TimeCairo, Cairo10d ago
-
Senior-level Full TimeCairo18d ago
-
Senior-level Full TimeCairo - ETIC, Egypt23d ago
-
Data Architect USD 127K-179KData Architecture | Data Governance | Data Lineage | Data Modeling | Data QualitySenior-level Full TimeCairo, Egypt24d ago
-
AWS | Amazon SageMaker | Apache Spark | Azure Machine Learning | Cloud platformCompany laptop | Continuous learning | Exposure to international clients | Hybrid work model | Professional developmentSenior-level Full TimeCairo, Egypt29d ago
-
AI/ML | Azure Data | Azure Data Factory | Azure Machine Learning | Azure SynapseSenior-level Full TimeCairo, Cairo Governorate, Egypt1mo ago
-
ETIC, AI Solution Architect- Senior Manager USD 77K-212KAWS | Artificial Intelligence | Azure | C++ | Data WarehousingSenior-level Full TimeCairo - ETIC, Egypt1mo ago