Lead Data Engineer - AWS, Redshift & Oracle/PostgreSQL

NorthBay Solutions LLC; Lahore; Hybrid; PKR 2,232,000 - 3,348,000; Full time

Job summary

A leading data solutions provider is seeking a Lead Data Engineer in Lahore. The ideal candidate will have over 10 years of experience in Data Engineering and expertise in AWS and database technologies. Responsibilities include leading the design and implementation of data pipelines and warehouse solutions, optimizing performance on AWS, and mentoring engineers. This role offers a hybrid work model combining remote and on-site work in Lahore.

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.

Responsibilities

• Lead the architecture and implementation of data pipelines and data warehouse solutions on AWS.
• Develop and review complex PL/SQL and PL/pgSQL procedures, functions, and scripts.
• Implement performance tuning strategies including indexing, partitioning, and query optimization.

Skills

AWS Data Engineering

Data Architecture

Data Warehousing

SQL Development

Tools

Redshift

Oracle PL/SQL

PostgreSQL PL/pgSQL

Job description

A leading data solutions provider is seeking a Lead Data Engineer in Lahore. The ideal candidate will have over 10 years of experience in Data Engineering and expertise in AWS and database technologies. Responsibilities include leading the design and implementation of data pipelines and warehouse solutions, optimizing performance on AWS, and mentoring engineers. This role offers a hybrid work model combining remote and on-site work in Lahore.