Data Modeler
Location:
Abu Dhabi, UAE (On-site)
Employment Type:
Full-time
Experience
Required:
6+ years in Data Modelling or related Data Management disciplines
We are seeking an experienced Data Modeler to design, develop and maintain enterprise data models that support data warehousing, analytics, business intelligence and data management initiatives.
The successful candidate will be responsible for translating business requirements into conceptual, logical and physical data models, ensuring data is structured, consistent, accurate and optimised for business and technical requirements.
The role requires strong expertise in data modelling methodologies, database design, SQL and data warehousing concepts, with experience working alongside data architects, data engineers, business analysts and data governance teams.
The ideal candidate will have a proven track record of developing scalable data models for complex enterprise data environments.
Key Responsibilities- Data Modelling:
Design, develop and maintain conceptual, logical and physical data models to support enterprise data platforms, databases and analytical systems. - Dimensional Modelling:
Develop dimensional data models, including star schemas, snowflake schemas, fact tables and dimension tables for data warehouses and reporting environments. - Database Design:
Apply relational database design principles, normalisation, primary and foreign keys, relationships and referential integrity. - Data Warehouse Modelling:
Design and maintain data models for data warehouses, data marts, data lakes and lakehouse environments. - Business Requirements Analysis:
Collaborate with business analysts and stakeholders to translate business requirements into data entities, attributes, relationships and data structures. - Source-to-Target Mapping:
Develop and maintain source-to-target mappings, transformation rules and data definitions to support data integration and ETL/ELT processes. - Data Modelling Standards:
Establish and apply data modelling standards, naming conventions, data definitions and documentation practices. - SQL Development:
Use SQL to analyse data structures, validate models, investigate data relationships and support data transformation requirements. - Data Governance:
Work with data governance teams to ensure data models align with data quality, metadata management, master data management and business glossary requirements. - Model Optimisation:
Review and optimise data models to improve database performance, scalability, consistency and maintainability. - Model Documentation:
Maintain entity relationship diagrams (ERDs), data dictionaries, data models and technical design documentation. - Data Model Maintenance:
Manage changes to data models, assess impacts on downstream systems and maintain version control. - Technical
Collaboration:
Work closely with data architects, data engineers, database administrators and analytics teams to support implementation and ongoing development.
Experience:
- Bachelor's degree in Computer Science, Information Technology, Data Engineering, Information Systems or a related discipline.
- 6+ years of experience in data modelling, database design, data warehousing or related data management roles.
- Proven hands-on experience developing
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).