Lead Data Engineer: AWS, Redshift & Oracle/PostgreSQL

NorthBay - Pakistan; Karachi Division; Hybrid; PKR 1,800,000 - 3,000,000; Full time

Job summary

NorthBay - Pakistan is seeking a Lead Data Engineer with strong AWS and database tech, including Oracle PL/SQL, PostgreSQL PL/pgSQL, and Amazon Redshift. The ideal candidate will lead the design, development, and optimization of scalable data platforms and drive enterprise-level data engineering initiatives.

You will architect data pipelines and data warehouses on AWS, mentor engineers, conduct code reviews, and collaborate with cross-functional teams to deliver robust data solutions.

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 (PL/pgSQL).
• Proven experience in enterprise-scale data warehouse architecture.
• Strong understanding of ETL/ELT frameworks and pipeline design.
• Leadership or mentoring experience in engineering teams.

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.

Skills

Data Engineering

Data Warehousing

ETL/ELT

Leadership

Performance Tuning

Tools

Redshift

Oracle PL/SQL

PostgreSQL PL/pgSQL

AWS (S3, Lambda)

Glue

S3

Lambda

Job description

NorthBay - Pakistan is seeking a Lead Data Engineer with strong AWS and database tech, including Oracle PL/SQL, PostgreSQL PL/pgSQL, and Amazon Redshift. The ideal candidate will lead the design, development, and optimization of scalable data platforms and drive enterprise-level data engineering initiatives.

You will architect data pipelines and data warehouses on AWS, mentor engineers, conduct code reviews, and collaborate with cross-functional teams to deliver robust data solutions.