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

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