Lead Data Engineer - AWS Redshift & PL/SQL Expert

NorthBay Solutions; Islamabad Capital Territory; On-site; PKR 4,200,000 - 6,400,000; Full time

Job summary

NorthBay Solutions in Islamabad is seeking a Lead Data Engineer to drive the design, development, and optimization of scalable data platforms using AWS and database technologies including Oracle PL/SQL, PostgreSQL PL/pgSQL, and Redshift. You will lead enterprise-level data engineering initiatives and mentor the team.

The role focuses on architecture, performance tuning, data governance, and collaboration with cross-functional teams to deliver robust data solutions in a fast-paced environment.

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

Skills

AWS Data Engineering

Data Architecture

Data Warehousing

SQL Development

Tools

Redshift

Oracle PL/SQL

PostgreSQL PL/pgSQL

Job description

NorthBay Solutions in Islamabad is seeking a Lead Data Engineer to drive the design, development, and optimization of scalable data platforms using AWS and database technologies including Oracle PL/SQL, PostgreSQL PL/pgSQL, and Redshift. You will lead enterprise-level data engineering initiatives and mentor the team.

The role focuses on architecture, performance tuning, data governance, and collaboration with cross-functional teams to deliver robust data solutions in a fast-paced environment.