9 days ago
Senior Data Modeler
Emagine
On Site
Full Time
SAR 200,000
Jiddah, Makkah, Saudi Arabia
Job Overview
Job TitleSenior Data Modeler
Job TypeFull Time
CategoryCommerce
Experience5 Years
DegreeMaster
Offered SalarySAR 200,000
LocationJiddah, Makkah, Saudi Arabia
Who's the hiring manager?
Sign up to PitchMeAI to discover the hiring manager's details for this job. We will also write them an intro email for you.
Job Description
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
Key skills/competency
- Data Modeling
- Data Architecture
- BigQuery
- Informatica IDMC
- SQL
- Python
- ETL/ELT
- Dimensional Modeling
- Data Governance
- Data Quality
How to Get Hired at Emagine
- Research emagine's culture: Study their mission, values, recent news, and employee testimonials on LinkedIn and Glassdoor to understand their data-driven environment.
- Tailor your Senior Data Modeler resume: Customize your application to highlight extensive experience in enterprise data modeling, BigQuery, and Informatica IDMC, emphasizing quantifiable achievements in data architecture.
- Showcase technical expertise: Prepare to demonstrate advanced SQL proficiency for complex transformations and performance optimization, alongside Python skills for data profiling and automation relevant to emagine's needs.
- Prepare for data architecture discussions: Be ready to discuss your experience with dimensional modeling, normalization, and data vault methodologies, as well as ETL/ELT pipeline design in detail with emagine's hiring team.
- Highlight collaboration and communication: Emphasize your ability to collaborate with data architects, engineers, BI teams, and business stakeholders to ensure data solutions align with organizational objectives at emagine.
Frequently Asked Questions
Find answers to common questions about this job opportunity
01What is the primary technical focus for a Senior Data Modeler at emagine?
02How does emagine utilize Google BigQuery in its data architecture for this role?
03What is emagine's approach to data governance and quality using Informatica IDMC?
04What data modeling methodologies are essential for the Senior Data Modeler position at emagine?
05What are the expectations regarding Python proficiency for this Senior Data Modeler role at emagine?
06Does emagine provide opportunities for growth and development in data architecture?
07What is the team collaboration like for a Senior Data Modeler at emagine?
08Is previous experience in the insurance industry a mandatory requirement for this role at emagine?
Explore similar opportunities that match your background