Senior Data Modeler

Summary

The Senior Data Modeler plays a crucial role in designing and implementing enterprise data models that support business and analytics objectives. This position is essential for ensuring that data architecture aligns with organizational goals and provides high-quality data for analysis.

Responsibilities:

• Lead the design and implementation of enterprise data models (conceptual, logical, and physical) aligned to business and analytics requirements.

• Develop and maintain data models supporting data warehouses, data lakes, and real-time analytics platforms.

• Work extensively with Google BigQuery to design optimized schemas and support high-performance analytical workloads.

• Utilize Informatica IDMC for data integration, data quality, metadata management, and data governance enablement.

• Develop advanced SQL scripts for data transformation, validation, and performance optimization.

• Use Python for data profiling, data quality automation, and metadata-driven data engineering activities.

• Define and enforce data modelling standards, naming conventions, and best practices across the organization.

• Collaborate with data architects, data engineers, BI teams, and business stakeholders to ensure alignment between business requirements and data structures.

• Support ETL and ELT design by defining source-to-target mappings and transformation logic.

Key Requirements:

• 8–10 years of experience in Data Modelling, Data Architecture, or Data Engineering.

• Strong hands-on experience with BigQuery and cloud-based data modelling practices.

• Proven experience with Informatica IDMC (Data Integration, Data Quality, or related modules).

• Advanced SQL skills including performance tuning and complex transformations.

• Proficiency in Python for data analysis, profiling, and automation.

• Strong experience designing models for ETL and ELT pipelines.

• Strong understanding of dimensional modelling, normalization, and data vault or similar modelling methodologies.

Nice to Have:

• Experience in the insurance industry.

• Current residence in KSA with transferable iqama.

• Immediate availability to join.

Other Details:

• Location: Jeddah, KSA

• Work Type: Onsite full-time