Principal Data Engineer – AWS Redshift & Data Platforms

HireOn; Karachi Division; Hybrid; PKR 1,674,000 - 2,790,000; Full time

Benefits offered by this job

Hybrid work flexibility

Exposure to modern technologies

Career growth opportunities

Job summary

HireOn is seeking a Principal Data Engineer in Pakistan to architect and scale cloud data platforms. The role demands 6-8+ years in data engineering with expertise in Amazon Redshift and Apache Airflow. You will design data workflows and optimize performance. The position allows hybrid work flexibility across major cities in Pakistan and offers growth into data architecture and leadership roles.

Qualifications

• 6 to 8+ years of experience in data engineering or data warehousing.
• Advanced expertise in Amazon Redshift with performance tuning skills.
• Strong hands-on experience with Apache Airflow for workflows.

Responsibilities

• Design and deliver high-performance data pipelines on Amazon Redshift.
• Collaborate with teams to drive data-driven outcomes.
• Optimize processing performance and implement orchestration.

Skills

Amazon Redshift

Apache Airflow

Python

SQL

Tools

AWS

Git

Linux/Unix

Job description

Overview

Employment Type: Full-Time | Permanent

Location: Pakistan (Lahore / Karachi / Islamabad) – Hybrid

About The Opportunity

HireOn is hiring on behalf of a reputed international client seeking a Principal Data Engineer to play a pivotal role in building and scaling a next-generation cloud data platform.

This position focuses on designing and delivering high-performance data pipelines and warehouse solutions on Amazon Redshift, enabling faster analytics, improved reliability, and scalable data operations.

You will take ownership of architecting data workflows, optimizing processing performance, and implementing production-grade orchestration, while collaborating with cross-functional teams to drive data-driven outcomes.

Key Requirements

• 6 to 8+ years of experience in data engineering, data platforms, or data warehousing
• Advanced expertise in Amazon Redshift, including performance tuning, workload optimization, and MPP architecture
• Strong hands-on experience with Apache Airflow (MWAA preferred) for workflow orchestration
• Proficiency in SQL and Python for building scalable data pipelines
• Solid experience with cloud-based data ecosystems on AWS (S3, Lambda, CloudWatch, DMS)
• Deep understanding of data modeling, ETL/ELT frameworks, and large-scale data processing
• Proven ability to design high-performance, distributed data pipelines
• Experience leading engineering efforts, including code reviews, mentoring, and technical decision-making
• Strong knowledge of query optimization, parallel processing, and data pipeline efficiency

Core Technical Skills

Essential

• Amazon Redshift (Provisioned / Serverless)
• MPP data processing concepts
• Apache Airflow (MWAA)
• Advanced SQL & performance tuning
• Python for data engineering
• Data modeling & warehousing concepts

Preferred

• AWS services (S3, Lambda, DMS, Aurora PostgreSQL)
• CI/CD pipelines & Git-based workflows
• Linux/Unix environments
• Experience with large-scale, distributed data systems

What Success Looks Like

• Highly optimized and scalable data pipelines running on Redshift
• Reliable orchestration with minimal downtime and strong observability
• Efficient handling of large datasets with improved query performance
• Well-architected data platform aligned with modern engineering standards

Why Join Through HireOn

• Opportunity to work with a globally recognized client on high-impact data initiatives
• Exposure to modern cloud data technologies and large-scale systems
• Hybrid work flexibility within Pakistan
• Career growth into data architecture and platform leadership roles

Skills: apache airflow, python, plsql, aws, amazon redshift