Data Modeler

Systems Limited; Punjab; On-site; PKR 2,000,000 - 2,750,000; Full time

Job summary

A leading technology firm in Punjab is seeking a Data Modeler to design efficient data structures and support analytics needs. The ideal candidate has 8–10 years of experience in data modelling, strong SQL knowledge, and practical experience with Power BI and Azure. The role involves optimizing data relationships, collaborating with BI developers, and contributing to enterprise data architecture discussions.

Qualifications

• 8–10 years of experience in data modelling.
• Strong knowledge of data warehouse design and fact/dimension modeling.
• Practical understanding of Power BI’s modeling layer.

Responsibilities

• Design and optimize data structures for scalable data solutions.
• Develop and optimize fact and dimension tables.
• Collaborate with BI developers on data modelling.

Skills

Data modelling

SQL

Power BI

Azure Data Services

Spark architecture

Job description

We are looking for a Data Modeler who can design and optimize data structures to ensure accurate, efficient, and scalable data solutions. They can translate business requirements into robust data models supporting analytics and reporting needs.

Responsibilities:

• Apply Kimball dimensional modelling principles and assess trade-offs with Inmon architecture where applicable.
• Develop and optimize fact and dimension tables, ensuring data consistency and integrity across complex data relationships.
• Collaborate with BI developers to align the Power BI data modelling layer with backend data models
• Work closely with data engineers to ensure Spark-based data processing aligns with physical data model design.
• Contribute to enterprise-level data architecture discussions, ensuring models meet both functional and non-functional requirements.
• Support documentation, version control, and governance for all data models and related metadata.
• Leverage understanding of Azure architecture for seamless integration and deployment within cloud environments.

Requirements:

• 8–10 years of experience in data modelling
• Strong knowledge of data warehouse design, fact/dimension modeling, and advanced SQL concepts.
• Practical understanding of Power BI’s modeling layer and its integration with backend systems.
• Exposure to Spark architecture and distributed data processing frameworks.
• 3–4 years of experience in enterprise-level data implementations.
• Basic knowledge of Azure Data Services (e.g., Data Lake, Synapse, Data Factory) is an advantage.

Location: Lahore, Islamabad & Karachi