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

NorthBay Solutions LLC; Islamabad; On-site; PKR 2,232,000 - 3,348,000; Full time

Job summary

A leading tech company in Islamabad seeks a Lead Data Engineer with over 10 years of experience. The candidate will architect and optimize data solutions, focusing on AWS technologies and database development. Responsibilities include leading data pipeline implementations and mentoring engineers. Strong expertise in Oracle PL/SQL, PostgreSQL, and data warehousing is essential. This is a full-time hybrid position.

Qualifications

• 10+ years of experience in Data Engineering, Data Warehousing, and Database Development.
• Strong hands-on experience with AWS data ecosystem (Redshift, Glue, S3, Lambda).
• Advanced expertise in Oracle PL/SQL and PostgreSQL.

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.

Skills

AWS Data Engineering

Data Architecture

Data Warehousing

SQL Development

Tools

Amazon Redshift

Oracle PL/SQL

PostgreSQL PL/pgSQL

Job description

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