Lead Data Modeler & Enterprise Architect

Systems Limited; Islamabad; On-site; PKR 2,400,000 - 4,200,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. You will translate business requirements into robust data structures and collaborate with data architects and engineers.

The role emphasizes dimensional modeling (Star/Snowflake), normalization, indexing, and ensuring governance, quality, and performance across platforms such as Oracle, SQL Server, PostgreSQL,

Qualifications

• 8–15 years of experience in Data Modeling, Data Architect roles, or similar.
• Strong understanding of conceptual, logical and physical modeling.
• Experience with dimensional modeling, star/snowflake schemas, and ER design.
• Fluent in SQL and relational database concepts.

Responsibilities

• Design and develop conceptual, logical and physical data models for enterprise platforms.
• Translate business requirements into scalable and efficient data models.
• Develop models for data warehouses, data lakes, and analytics platforms.
• Define entities, attributes, relationships, keys and constraints.
• Collaborate with Data Architects, Engineers, Business Analysts and teams.
• Develop dimensional models including Star and Snowflake schemas.
• Ensure models follow governance, quality and security standards.
• Analyze databases and recommend improvements for performance.
• Support ETL/ELT, data integration, and reporting requirements.
• Maintain data model documentation and metadata.

Skills

Data modeling

SQL

Data warehousing

Data architecture

Stakeholder communication

Tools

ERwin

ER/Studio

SAP PowerDesigner

Snowflake

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. You will translate business requirements into robust data structures and collaborate with data architects and engineers.

The role emphasizes dimensional modeling (Star/Snowflake), normalization, indexing, and ensuring governance, quality, and performance across platforms such as Oracle, SQL Server, PostgreSQL,