Job Position – Data Modeler
Company Name – Mindpool Tech
Location : Abu Dhabi
Professionals who can join us in short notice or max 30 days
Hiring an experienced with strong Financial & Banking domain expertise to design, develop, and maintain enterprise wide data models that support regulatory reporting, risk management, finance, and analytics initiatives.
The role requires deep understanding of banking data structures, regulatory frameworks, and best practices in conceptual, logical, and physical data modeling within large scale Oracle / DWH ecosystems.
Key Responsibilities
Data Modeling & Architecture
Design and maintain Conceptual, Logical, and Physical Data Models for banking and financial systems
Develop enterprise and subject?area models covering:
Core Banking (Loans, Deposits, GL)
Risk (Credit Risk, Market Risk, Liquidity Risk)
Finance (IFRS, P&L, Balance Sheet)
Regulatory Reporting (Basel, IFRS, Central Bank reports)
Model fact and dimension tables for reporting and analytics (Star / Snowflake schemas)
Ensure data models support historical tracking, SCDs, time?variant data, and auditability
Banking & Financial Domain Expertise
Translate banking business requirements into robust data models, including:
Customer, Account, Product, Exposure, Collateral
Transactions, Cashflows, Maturity Buckets, NPLs
Support regulatory and compliance reporting use cases
Understand end?to?end data flow from source systems ? staging ? DWH ? reporting
Ensure alignment with regulatory data standards and reporting granularity
Data Governance & Quality
Define and enforce data standards, naming conventions, and modeling best practices
Maintain data lineage, metadata, and impact analysis
Support data quality, reconciliation, and audit requirements
Collaborate on data governance and master data initiatives
Collaboration & Delivery
Work closely with:
Business Analysts
Regulatory Reporting Teams
Data Engineers / ETL Developers
DBAs and Architects
Review and validate data models with stakeholders
Support implementation teams during ETL and reporting development
Technical Skills Required
Strong expertise in Data Modeling techniques (ER Modeling, Dimensional Modeling)
Hands on experience with Oracle, SQL Server, or similar RDBMS
Experience with enterprise data modeling tools (e.g., Erwin, PowerDesigner, ER Studio)
Solid understanding of:
Data Warehousing concepts
OLTP vs DWH modeling
Performance and scalability considerations
Knowledge of SQL for data validation and analysis
Qualifications
Bachelor’s degree in Computer Science, Information Systems, Finance, or related field
6–10+ years experience as a Data Modeler, preferably in Banking / Financial Services