Posted 1 week ago
Lead Data Engineer (AWS / PLSQL / PL/PGSQL)
- Work arrangement not specified
- Full Time
- AWS
- Data Engineering
- SQL
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
More jobs at NorthBay Solutions
Lead Data Engineer (AWS Data Platform)
NorthBay Solutions Lahore, Punjab, Pakistan🇵🇰
Other jobs in Pakistan
Infant and Young Child Feeding (IYCF) Counselor
International Rescue Committee Multiple locations🇵🇰
Head of Cash Management & Transaction Banking
Raqami Islamic Digital Bank Karachi, Sindh, Pakistan🇵🇰
Senior Manager MFC and Customer Experience
Metro/Makro Karachi, Sindh, Pakistan🇵🇰