Lead Data Engineer - AWS, Redshift & Oracle/PostgreSQL

NorthBay Solutions LLC; Karachi Division; Hybrid; PKR 19,547,612 - 27,925,161; Full time

Job summary

A technology solutions company is seeking a Lead Data Engineer based in Pakistan (Lahore/Karachi/Islamabad) with over 10 years of experience in Data Engineering and Data Warehousing. The role involves leading the design and optimization of data platforms, mentoring engineers, and overseeing data migration and transformation projects. This hybrid position requires strong expertise in AWS, Oracle PL/SQL, and PostgreSQL. Ideal candidates will have a proven track record in performance tuning and technical leadership.

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).

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.

Skills

AWS Data Engineering

Data Architecture

Data Warehousing

SQL Development

Performance Tuning

Tools

Redshift

Oracle PL/SQL

PostgreSQL PL/pgSQL

AWS (S3, Lambda)

Linux/Unix

Git

CI/CD

Job description

A technology solutions company is seeking a Lead Data Engineer based in Pakistan (Lahore/Karachi/Islamabad) with over 10 years of experience in Data Engineering and Data Warehousing. The role involves leading the design and optimization of data platforms, mentoring engineers, and overseeing data migration and transformation projects. This hybrid position requires strong expertise in AWS, Oracle PL/SQL, and PostgreSQL. Ideal candidates will have a proven track record in performance tuning and technical leadership.