Data Modeler

Avensys Consulting; Jeddah; On-site; SAR 80,000 - 100,000; Full time

Job summary

A global IT professional services company in Jeddah is seeking an experienced Data Modeler for a 1-year renewable contract. The role involves designing and maintaining data models, collaborating with teams to ensure data integration, and using tools like ERwin and PowerDesigner. Applicants should have 5-10 years of experience and strong SQL skills. Attractive salary and benefits offered.

Benefits

Excellent base salary

Attractive company benefits

Collaborative work environment

Career progression opportunities

Qualifications

• 5–10 years of experience in data modeling and database design.
• Strong understanding of data warehouse, data lake, and data lakehouse concepts.
• Excellent communication and analytical skills.

Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Analyze existing data sources and schemas to identify relationships and optimization opportunities.
• Validate data flow and model integration with ETL/ELT developers.

Skills

Data modeling

Database design

SQL

ETL/ELT processes

Tools

ERwin

PowerDesigner

Teradata

Cloudera

Informatica

Denodo

Job description

Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. Given our decade of success we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail and supply chain.

We are seeking for Data Modeler Position

Position Details

Job Type: 1 year renewable contract with client (payroll Avensys)

Location: Jeddah, Saudi Arabia

Timings: Regular working hours (Saudi Arabia Time Zone)

Yrs of Exp: Min 5+ years of relevant experience

Job Description

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models for enterprise and analytical data platforms.
• Analyze existing data sources and schemas to identify relationships, redundancies, and optimization opportunities.
• Ensure data model alignment across Bronze, Silver, and Gold layers in the Data Lakehouse environment.
• Work with ETL/ELT developers (Informatica, Datastage, or equivalent) to validate data flow and model integration.
• Collaborate with data governance and architecture teams to maintain data lineage, metadata, and standards.
• Support performance tuning, normalization/denormalization, and indexing strategies.
• Document data definitions, business keys, and transformation rules clearly and accurately.
• Participate in model reviews and sign-off sessions with stakeholders and architects.

Required Skills and Qualifications

• 5–10 years of experience in data modeling and database design.
• Proficiency with data modeling tools (ERwin, PowerDesigner, or equivalent).
• Strong SQL skills and understanding of data warehouse / data lake / data lakehouse concepts.
• Understanding of Teradata FSLDM & FSAS models.
• Hands‑on experience with Teradata, Cloudera, Informatica, or Denodo preferred.
• Solid understanding of ETL/ELT processes, data governance, and metadata management.
• Excellent communication and analytical skills; ability to work across business and technical teams.

What’s On Offer

You will be remunerated with an excellent base salary and entitled to attractive company benefits. Additionally, you will get the opportunity to enjoy a fun and collaborative work environment, alongside a strong career progression.

To submit your application, please apply online or email your UPDATED CV in Microsoft Word format to [e-mail]. Your interest will be treated with strict confidentiality.

Consultant Details

Consultant Name : Uma

AvensysConsultingPteLtd

Privacy Statement: Data collected will be used for recruitment purposes only. Personal data provided will be used strictly in accordance with the relevant data protection law and Avensys' privacy policy.