Back to jobs

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

Pay
Pay not listed
Work setting
Hybrid — work setting 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

Full 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).

  • Lead architecture and build of data pipelines and warehouse solutions on AWS

  • Design and optimize Amazon Redshift analytics platforms

  • Develop and review PL/SQL and PL/pgSQL procedures, functions and scripts

  • Drive data migration across Oracle, PostgreSQL and Redshift

  • Tune performance through indexing, partitioning and query optimization

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.
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

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
Apply at NorthBay Solutions

Posting record

Report an error

Open 5 monthsWe first saw this posting 171 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jun 3, 2026171 days ago
Recorded sightings
233
Last seen by us
Nov 21, 2026

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

How this job compares

Time since we first saw it

Day 171

Up longer than most. Similar jobs usually come down between day 6 and day 56.

At NorthBay Solutions, jobs usually come down by about day 111.

From 14,771 similar postings that came down, and 11 of NorthBay Solutions’s. Coming down is not always a hire.

NorthBay Solutions is hiring

39 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring has slowed
  • Its jobs tend to stay up a long time
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • PL/SQL
  • SQL
  • AWS
  • Oracle
  • PostgreSQL
  • Redshift
  • S3
Where the posting names them
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
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
- 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
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
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

Your next step

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

Applying through JazzHR

  • No account needed: one application form on the employer’s applytojob.com page.

Already applied? Track this application

Has NorthBay Solutions posted this job before?

Yes. We’ve followed 2 other Lead Data Engineer (AWS / PLSQL / PL/PGSQL) jobs there since June 2026. All 2 are still up.

  1. KarachiStill up after 172 days, first seen Jun 3
  2. IslamabadStill up after 172 days, first seen Jun 3
  3. This jobUp 172 days so far, first seen Jun 3

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

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

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.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.