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

Employment Type: Full-Time | PermanentLocation: Pakistan (Lahore / Karachi / Islamabad) – HybridRole OverviewWe 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.Experience10+ years of experience in Data Engineering, Data Warehousing, and Database DevelopmentPrimary SkillsAWS Data Engineering, Data Architecture, Data Warehousing, SQL DevelopmentTechnologiesMust Have: Redshift, Oracle PL/SQL, PostgreSQL PL/pgSQLNice to Have: AWS (S3, Lambda), SQL, ETL/ELT, Data Modeling, Query Optimization, Performance Tuning, Linux/Unix, Git, CI/CDKey ResponsibilitiesLead the architecture and implementation of data pipelines and data warehouse solutions on AWSDesign and optimize Amazon Redshift-based analytics platformsDevelop and review complex PL/SQL and PL/pgSQL procedures, functions, and scriptsDrive data migration and transformation across Oracle, PostgreSQL, and Redshift environmentsImplement performance tuning strategies including indexing, partitioning, and query optimizationEstablish best practices for data governance, security, and qualityCollaborate with cross-functional teams to define and deliver data solutionsMentor engineers, conduct code reviews, and provide technical leadershipKey RequirementsStrong 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 architectureStrong understanding of ETL/ELT frameworks and pipeline designExpertise in performance tuning and large-scale data processingPrior experience in technical leadership or mentoring roles