Data Modeler - Leading UAE Bank

The data modeler designs, implements, and documents data design patterns and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise-wide data products implementation and enabling all forms of data dependent use-cases.

Key Responsibilities of Data Modeler:

1. Be responsible for Creating / Maintaining / Optimizing conceptual, logical, and physical data models, the implementation of operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL) using best practices to ensure high data quality and reduced redundancy.
2. Implement business and IT data requirements through new data strategy and designs across all data platforms (relational, dimensional, and NoSQL) and relevant data tools (reporting, visualization, analytics, and machine learning).
3. Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
4. Manage the enhancements/expansion of existing data models and the optimization of data query performance via best practices.
5. Work closely with Data Domain Specialists & Data Product Owners to understand Data Product level functional specifications, obtaining the business context and consumption patterns around the data.
6. Create Structure / Schema for Target Data as per business requirements (nature of data + consumption patterns) by leveraging business context & data product functional specifications.
7. Perform Data Profiling as may be required to arrive at future-proof data model design for Data Products.
8. Provide Technical Specifications to development team (Data Engineering & BI teams) as per final target schema for data (functional specifications are converted to fit into target structure).
9. Generate DDL (Create Table) Scripts using Data Modeling Tool, working with Technology Engineers to create the required database objects onto the respective database platform and maintaining the required enhancements.
10. Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
11. Work collaboratively with all involved teams and contribute to the advancement of data strategy operationalization.

Skills Required:

• Bachelor’s/Master’s degree in Information Management, Computer Science, Engineering, or equivalent experience.
• Preferred banking domain knowledge and multi-market experience.
• 5+ years of experience in relational/dimensional modeling and analytics with RDBMS, NoSQL technologies, and ETL protocols.
• Familiarity with design patterns such as Data Warehouse, Data Lake, and big data platforms.

Core Skills:

• Expertise in data modeling principles including conceptual, logical, and physical data models.
• Skills in creating optimal data models: Star & Snowflake Schemas, Data Vault, and normalization techniques.

Technical Skills:

• Proficient with data modeling tools (e.g., SAP Power Designer, ERWin).
• Knowledge of industry reference data models (IBM BFMDW, Teradata FSLDM).

Best Practice/Design Standards:

• Understanding of naming standards for schemas and data attributes.
• Ability to identify optimal data types and lengths at a physical data model level.
• Experience in leveraging Master & Reference Data and ensuring no redundancy in design.
• Design data objects for long-term stability.

Robust knowledge of data management, querying tools (SAS/SQL), and quick adaptability to new systems.

Preferred knowledge in Data Management areas, HADOOP, Oracle, PostgreSQL, SAP HANA, and Data Governance tools.

Collaborative team player with strong stakeholder management skills and a strategic mindset.