Required Experience
- 7+ years of experience in Data Modelling, Data Warehousing, or Data Architecture.
- Minimum 4+ years of experience within Banking or Financial Services.
- Proven experience designing enterprise-scale dimensional data models and analytical data marts.
- Strong experience supporting Data Analytics, Business Intelligence, and AI/ML platforms.
- Experience working on cloud-based data platforms, preferably AWS.
Required Technical Skills
- Data Modelling
- Kimball Dimensional Modelling
- Star Schema
- Snowflake Schema
- Data Vault Modelling
- Fact & Dimension Modelling
- SCD Type 1, 2 & 3
- Data Mart Architecture
- Enterprise Data Warehouse Design
- Metadata Management
- Data Lineage & Governance
- Database Technologies
- MS SQL Server
- T-SQL
- SQL Performance Tuning
- Stored Procedures
- Amazon Redshift
- Database Design & Optimization
- Cloud Technologies
- AWS S3
- Amazon Redshift
- AWS Glue
- AWS Lambda
- CloudWatch
- IAM Fundamentals
- Data Governance
- Data Quality Frameworks
- Metadata Management
- Business Glossary
- Data Classification
- Data Privacy & Compliance
- Banking Domain Expertise
Strong Experience In
- Retail Banking (CASA, Deposits, Cards, Loans, Mortgages)
- Corporate Banking (Trade Finance, Lending, Cash Management)
- SME Banking (Business Accounts, Working Capital, Merchant Data)
- Core Banking Data Structures
- Customer & Account Hierarchies
- Risk Metrics (PD, LGD, EAD, IFRS9)
- Regulatory Reporting and MIS Reporting
Education
- Bachelor's Degree in Computer Science, Information Systems, Engineering, Statistics, Mathematics, or related field.
- Master's Degree in Data Science, Analytics, or related discipline preferred
Skills: snowflake,aws,data structures,sql,data modeling