Principal Data Engineer – AWS Redshift & Data Platforms

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 (Must-Have First)

• 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