Lead Data Engineer (AWS / PLSQL / PL/PGSQL)
At a glance
Senior Data Engineering role at NorthBay Solutions. Lahore · full-time.
Pay not stated Lead Data Engineer salary
dataroles summary, based on the employer's posting.
What you'll do
- Lead the design and build of AWS data pipelines and warehouse solutions
- Shape Redshift analytics platforms, improving their design and performance
- Write and review complex Oracle PL/SQL and PostgreSQL PL/pgSQL procedures, functions and scripts
- Move and transform data between Oracle, PostgreSQL and Redshift, tuning queries with indexing and partitioning
- Set data governance, security and quality practices, while mentoring engineers and reviewing code
What you bring
- At least ten years working across data engineering, warehousing and database development
- Hands-on experience with AWS data services, including Redshift, Glue, S3 and Lambda
- Advanced command of Oracle PL/SQL and PostgreSQL PL/pgSQL
- Background designing enterprise-scale warehouses and ETL/ELT pipelines, with large-scale performance tuning
- Previous technical leadership or experience mentoring engineers
Who this fits
This senior lead role suits someone who can guide architecture and delivery while staying hands-on with database development and performance work. It is a full-time, permanent hybrid position in Lahore, Karachi or Islamabad, Pakistan.
From the employer
Employment Type: Full-Time | Permanent
Location: Pakistan (Lahore / Karachi / Islamabad) – Hybrid
Role Overview
We 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.
Experience
10+ years of experience in Data Engineering, Data Warehousing, and Database Development
Primary Skills
AWS Data Engineering, Data Architecture, Data Warehousing, SQL Development
Technologies
Must Have: Redshift, Oracle PL/SQL, PostgreSQL PL/pgSQL
Nice to Have: AWS (S3, Lambda), SQL, ETL/ELT, Data Modeling, Query Optimization, Performance Tuning, Linux/Unix, Git, CI/CD
Key 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
Key Requirements
- Strong 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 architecture
- Strong understanding of ETL/ELT frameworks and pipeline design
- Expertise in performance tuning and large-scale data processing
Prior experience in technical leadership or mentoring roles
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.