• Design and implement robust, scalable, and performant data models within AWS services like Redshift, RDS, and S3 to support diverse analytical and operational needs.
• Translate complex business requirements into logical and physical data models, ensuring data integrity, consistency, and optimal query performance.
• Develop and maintain data dictionaries, business glossaries, and metadata repositories to ensure clear understanding and governance of data assets.
• Collaborate with data engineers, analysts, and business stakeholders to understand data sources, transformations, and consumption patterns.
• Years of Experience *
Minimum 5 yrs
Required Skills *
· Strong hands-on experience in enterprise data modelling .
· Demonstrable experience developing:
• Conceptual data models
• Logical data models
• Physical data models
· Strong knowledge of dimensional modelling , including:
• Facts and dimensions
• Star schemas
• Snowflake schemas
• Slowly Changing Dimensions
· Strong understanding of relational data modelling and database design principles.
· Strong SQL skills and the ability to analyse complex source data and existing database structures.
· Experience developing source-to-target mappings and transformation rules .
· Strong understanding of:
• Data warehousing
• Data lakes / lakehouses
• Metadata management
• Data lineage
• Data quality
• Reference and master data concepts
· Experience modelling data for analytical, reporting and downstream consumption requirements.
· Good understanding of modern cloud data technologies, preferably:
• Amazon S3
• Amazon Redshift
• AWS Glue / Glue Catalog
• Amazon Athena
• Apache Iceberg
· Experience working with structured and semi-structured datasets.
· Strong analytical skills with the ability to understand complex business concepts and translate them into clear data structures.
· Ability to communicate data models and definitions effectively to both business and technical stakeholders.
Required Experience / Knowledge Areas *
· Strong experience in Data Modelling, Data Warehousing and Enterprise Data Platforms .
· Demonstrable experience developing enterprise-scale data models within complex organisations.
· Experience working alongside Data Architects, Data Engineers, Business Analysts and business stakeholders.
· Experience within Banking or Financial Services strongly preferred.
· Knowledge of banking data domains such as Customer, Account, Product, Transaction, Finance, Risk and Treasury would be advantageous.
· Good understanding of enterprise data governance and data-management principles.
· Experience supporting the full development lifecycle from requirements and source analysis through modelling, engineering implementation, validation and production delivery.
· Skills
data modelling
data warehousing
SQL
Is this role a fit for you?
Upload any CV — a short AI chat builds your profile, scores how well you fit roles like this across the Gulf, and tailors an ATS-ready CV to each. Free to start. No job promises — you always apply yourself.
Prohuman Technology · Dubai - United Arab Emirates
Listing aggregated from naukrigulf. Built for the Gulf. No job or interview promises — we make your search faster and your CV stronger.
UnfairJobs is an AI career assistant. Job listings here are a free index of public postings — we never charge employers or sell listings, and you always apply yourself, on the original posting.
