Lead Data Engineer (AWS / PLSQL / PL/PGSQL)
Hybrid · Islamabad, Islamabad, Pakistan or Lahore, Punjab, Pakistan
Job Summary
Lead 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.
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)
- Expertise in Oracle PL/SQL and PostgreSQL PL/pgSQL
- Experience with enterprise-scale data warehouse architecture
- Experience with ETL/ELT frameworks and pipeline design
- Strong understanding of data governance, security, and quality
- Leadership or mentoring experience
- Ability to design, develop, and optimize data pipelines and data warehouses on AWS
- Experience with performance tuning, indexing, partitioning, and query optimization
- Familiarity with CI/CD, Git, Linux/Unix
- Ability to collaborate with cross-functional teams and lead technical discussions
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.