Lead Data Engineer (AWS PLSQL PLPGSQL)
NorthBay Solutions • Lahore, Punjab, Pakistan
15 days ago
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
Required Experience:
Manager
Experience: years
Vacancy: 1