Data Modeler

BBI; Riyadh; On-site; SAR 120,000 - 150,000; Full time

Job summary

A leading data services provider in the Riyadh region is seeking a skilled Data Modeler. The role involves developing complex SQL queries and ensuring data quality across various KPIs. Candidates should have 5-7 years of experience in data modeling, particularly in banking environments, along with strong SQL skills. Proficiency in Informatica and experience supporting BI tools are essential. This is an opportunity to contribute to critical data initiatives in an innovative environment.

Qualifications

• 5-7 years of experience in data modeling.
• Strong expertise in logical and physical data modeling for enterprise data warehouses.
• Ability to translate banking and KPI requirements into structured data entities.

Responsibilities

• Develop complex SQL queries to satisfy complex KPIs.
• Implement KPI calculation logic in collaboration with business stakeholders.
• Ensure data quality and consistency across KPIs.

Skills

Data modeling experience

SQL proficiency

Experience in banking environments

Data quality assurance

Tools

Informatica

BI tools

Job description

Key Responsibilities

• Develop complex SQL queries to satisfy complex KPIs
• Implement KPI calculation logic in collaboration with business stakeholders
• Build curated data models optimized for BI dashboards and analytics
• Ensure data quality, reconciliation, and consistency across KPIs
• Support performance tuning and scalability of KPI datasets

Key Skills

• 5-7 years of experience in data modeling:
• Strong expertise in logical and physical data modeling for enterprise data warehouses in banking environments.
• Ability to design and maintain data models across different domains.
• Proficient in translating banking and KPI requirements into well-structured entities, attributes, keys, and relationships.
• Strong SQL skills to profile data, validate relationships, and ensure data consistency within the warehouse.
• Ability to align data models with ETL/ELT processes and transformation logic implemented using Informatica.
• Experience supporting BI tools