Lead Data Engineer (AWS / PLSQL / PL/PGSQL)

Employment Type

Full-Time | Permanent

Location

Pakistan (Lahore / Karachi / Islamabad) – Hybrid

Role Overview

We are looking for a

Lead Data Engineer

• with strong expertise in
• AWS and database technologies (Oracle PL/SQL, PostgreSQL PL/pgSQL, Amazon Redshift)
• . The ideal candidate will lead the design, development, and optimization of scalable data platforms and drive enterprise-level data engineering initiatives.

Experience

10+ years of experience in Data Engineering, Data Warehousing, and Database Development

Primary Skills

AWS Data Engineering, Data Architecture, Data Warehousing, SQL Development

Technologies

Must Have: Redshift, Oracle PL/SQL, PostgreSQL PL/pgSQL

Nice to Have: AWS (S3, Lambda), SQL, ETL/ELT, Data Modeling, Query Optimization, Performance Tuning, Linux/Unix, Git, CI/CD

Key Responsibilities

• Lead the architecture and implementation of
• data pipelines and data warehouse solutions on AWS
• Design and optimize
• Amazon Redshift-based analytics platforms
• Develop and review complex
• PL/SQL and PL/pgSQL procedures, functions, and scripts

Drive

• data migration and transformation
• across Oracle, PostgreSQL, and Redshift environments

Implement

• performance tuning strategies
• including indexing, partitioning, and query optimization
• Establish best practices for
• data governance, security, and quality
• Collaborate with cross-functional teams to define and deliver data solutions
• Mentor engineers, conduct code reviews, and provide technical leadership

Key Requirements

• Strong hands-on experience with
• AWS data ecosystem (Redshift, Glue, S3, Lambda)
• Advanced expertise in

Oracle PL/SQL and PostgreSQL (PL/pgSQL)

• Proven experience in
• enterprise-scale data warehouse architecture
• Strong understanding of
• ETL/ELT frameworks and pipeline design

Expertise in

• performance tuning and large-scale data processing
• Prior experience in
• technical leadership or mentoring roles