Skip to content

NorthBay Solutions

NewBe an early applicant

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

Posted

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

Skills

What Lead Data Engineering jobs ask for — and how much of it you have →
Apply

Apply to Lead Data Engineer (AWS / PLSQL / PL/PGSQL) at NorthBay Solutions

Create a free account first, or go straight to the employer.

Free RoleWatch account

  • Get an email when new jobs match your search
  • Save jobs and track every application
  • See how well your CV matches each job

Already have one?

No account needed. Opens the employer's own site in a new tab.

See also

Data Engineering jobs by country — openings, pay and top skills →