Pay: Salary not listed in the saved posting
Work setup: Hybrid stated — work setup source
Employment Type: Full-Time | Permanent Location: Pakistan (Lahore / Karachi / Islamabad) – Hybrid Role Overview
Read the full posting
Employment: Full-time — employment source
Employment Type: Full-Time | Permanent Location: Pakistan (Lahore / Karachi / Islamabad) – Hybrid
Read the full posting

What you’ll work on

We are looking for a Lead Data Engineer with strong expertise in AWS and database technologies (Oracle PL/SQL, PostgreSQL PL/pgSQL, Amazon Redshift).

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

From the employer’s posting

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.

Key Responsibilities Lead the architecture and implementation of data pipelines and data warehouse solutions on AWS Design and optimize Amazon Redshift-based analytics platforms

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

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

What you’ll bring

All qualifications

Core experience

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

Qualification wording

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

Tools in this posting

SQL
AWS
Oracle
PostgreSQL
Redshift
S3

Source

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

Primary Skills AWS Data Engineering, Data Architecture, Data Warehousing, SQL Development Technologies

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

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

- 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

- 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

Key Responsibilities - Lead the architecture and implementation of data pipelines and data warehouse solutions on AWS - Design and optimize Amazon Redshift-based analytics platforms

Key Requirements - Strong hands-on experience with AWS data ecosystem (Redshift, Glue, S3, Lambda) - Advanced expertise in Oracle PL/SQL and PostgreSQL (PL/pgSQL)

- 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

- 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

Job description

View original posting ↗

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

Your next step

Have your CV and examples of relevant work ready.
Check the listed location, eligibility and core experience before starting.
Ask the employer about the salary range before committing time to the process.

Complete your application on northbay.applytojob.com. The employer’s form will show what is required.

Already applied? Track this application

Source & posting history

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay: No pay amount identified in the saved description.
Location & working pattern: Lahore, Punjab, Pakistan
Employment Type: Full-Time | Permanent Location: Pakistan (Lahore / Karachi / Islamabad) – Hybrid Role Overview
Work authorization: No clear work-authorization passage found. Eligibility is unconfirmed.

Open source at northbay.applytojob.com ↗Read the full description ↓

Status in our records: Active
First seen by us: Jun 3, 2026
Recorded sightings: 140
Last seen by us: Sep 30, 2026

These dates show when we found the listing. Check the employer’s website to confirm it is still accepting applications.

Report an error

See how this role fits your experience

Add your resume to compare the role’s scope, tools and requirements with your experience.

Upload resume Add LinkedIn

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