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

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

Islamabad, Federal Capital, Pakistan

Full Time

Manager/Supervisor

Share

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

• Share

• Apply

• Apply for this position

• Required*

• First Name*

• Last Name*

• Email Address*

• Phone*

• Address

• Resume*

• We've received your resume. Click here to update it.

• Attach resume

• or

• Paste resume

• Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or

• Paste resume

• Paste your resume here or

• Paste your resume file

• How many years of hands-on experience do you have working with AWS data services, particularly Amazon Redshift?*

• -- No answer --1 Year2 Years3 YearsLess than One YearNot Yet

• How much experience do you have with Oracle PL/SQL and PostgreSQL (PL/PgSQL)? Which one have you worked on more extensively?*

• -- No answer --1 Year2 Year3 YearLess Than One YearNot Yet

• How many years of experience do you have in building and managing ETL pipelines and performing query optimization?*

• -- No answer --1 Year2 Year3 YearLess Than One YearNot Yet

• What is your current notice period, and are you open to early joining if required?*

• -- No answer --I can join early15 Days30 Days60 Days

• What is your current monthly salary package?*

• What are your salary expectations for this role?*

• Human Check*

• Submit Application