Enterprise Data Modeler | Star & Snowflake Schema Architect

Systems Limited; Islamabad; On-site; PKR 2,500,000 - 4,500,000; Full time

Job summary

Systems Limited is seeking an experienced Data Modeler to design, develop, and maintain scalable data models for enterprise data platforms, data warehouses and analytics solutions. The role requires strong expertise in conceptual, logical and physical data modeling, database design and data architecture principles.

You will design dimensional models including Star Schema and Snowflake Schema, define keys and constraints, and collaborate with Data Architects, Data Engineers and business

Qualifications

• 8-15 years of experience as a Data Modeler or similar role.
• Strong SQL and relational database concepts.
• Experience with Data Warehouses, Data Lakes and Enterprise Data Platforms.
• Familiarity with Data Governance, Data Quality and Metadata Management.

Responsibilities

• Design and develop conceptual, logical and physical data models for enterprise data platforms.
• Translate business requirements into scalable, efficient data models.
• Develop and maintain data models for data warehouses, data lakes, and analytical platforms.
• Define entities, attributes, relationships, keys, constraints and business rules.
• Work with Data Architects, Data Engineers, Business Analysts and application teams.

Skills

Data modeling

SQL proficiency

Data architecture

Stakeholder communication

Tools

ERwin

ER/Studio

SAP PowerDesigner

Job description

Systems Limited is seeking an experienced Data Modeler to design, develop, and maintain scalable data models for enterprise data platforms, data warehouses and analytics solutions. The role requires strong expertise in conceptual, logical and physical data modeling, database design and data architecture principles.

You will design dimensional models including Star Schema and Snowflake Schema, define keys and constraints, and collaborate with Data Architects, Data Engineers and business