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