Senior Data Engineer Architect (Onsite – Karachi/Islamabad)

About the role

We are seeking a Senior Data Engineer Architect to design and maintain high‑performance data models that enable analytics, reporting, and AI/ML initiatives across the enterprise. The role is onsite in Pakistan and works closely with data engineers, business analysts, and subject‑matter experts.

Key responsibilities

• Design scalable relational, dimensional, and Data Vault models to support BI and real‑time analytics.
• Establish and enforce data‑modeling standards, naming conventions, and metadata management practices.
• Continuously improve existing models for integrity, performance, and query efficiency.
• Collaborate with data engineers and business teams to translate requirements into efficient data structures.
• Maintain a centralized metadata repository and version‑control data models.
• Support AI/ML model inputs by building robust data pipelines and pre‑aggregated datasets.

Required profile

• Bachelor's or Master's degree in Computer Science, Software Engineering, or a related field.
• Proven experience designing enterprise‑wide data models and implementing best practices.
• Strong analytical, problem‑solving, and troubleshooting abilities.
• Ability to manage multiple priorities independently or within a team.

Required skills

• SQL and experience with RDBMS such as Oracle, Redshift, BigQuery, Teradata, SQL Server, MySQL.
• Data modeling tools: ERwin, IBM InfoSphere Data Architect.
• Data profiling, validation, cleansing, and model optimization.
• Knowledge of MDM, dimensional modeling, and Data Vault techniques.