Senior Consultant Data Analytics

Job Description – Data Modeler

Position Title: Data Modeler
Location: Pakistan

Role Overview

We are looking for a skilled Data Modeler to design, implement, and optimize data models that enable efficient data storage, retrieval, and analysis across enterprise systems. The role requires close collaboration with business stakeholders, data engineers, architects, and analysts to ensure data structures align with business goals, reporting needs, and compliance standards.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models for enterprise and application databases.
• Analyze business requirements and translate them into efficient database structures.
• Work with data architects, engineers, and BI teams to optimize data flows and reporting solutions.
• Define and enforce data modeling standards, naming conventions, and metadata management.
• Develop and maintain ER diagrams, data dictionaries, and documentation.
• Collaborate with DBAs to ensure performance optimization, indexing, and partitioning strategies.
• Support data governance, quality, and compliance initiatives (GDPR, HIPAA, etc. if relevant).
• Participate in ETL/ELT design discussions with data engineering teams.
• Identify and resolve data integrity and redundancy issues.
• Stay updated on emerging technologies in data management, cloud, and analytics platforms.

Required Skills & Qualifications

• Bachelor’s/Master’s degree in Computer Science, Information Systems, Data Engineering, or related field.
• Proven experience as a Data Modeler, Data Analyst, or Database Designer (X+ years).
• Strong expertise in data modeling tools (Erwin, PowerDesigner, ER/Studio, SQL Developer Data Modeler, etc.).
• Hands-on experience with RDBMS and SQL (Oracle, SQL Server, PostgreSQL, MySQL, etc.).
• Knowledge of NoSQL databases (MongoDB, Cassandra, DynamoDB) is a plus.
• Familiarity with ETL processes, data integration, and BI/reporting platforms.
• Understanding of cloud data platforms (Azure Synapse, AWS Redshift, Google BigQuery, Snowflake).
• Strong knowledge of normalization, denormalization, star schema, snowflake schema, and data warehousing concepts.
• Excellent analytical, problem-solving, and communication skills.