Lead Data Engineer (AWS / PLSQL / PL/PGSQL)
Hybrid · Islamabad, Islamabad, Pakistan or Lahore, Punjab, Pakistan
Job Summary
Lead the architecture and implementation of data pipelines and data warehousing 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.
Required 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
- Expertise in performance tuning and large-scale data processing
- Prior experience in technical leadership or mentoring roles
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.