Senior Data Engineer (AWS / PLSQL / Oracle)
At a glance
Senior Data Engineering role at NorthBay Solutions. Lahore · full-time.
Pay not stated Data Engineer salary
dataroles summary, based on the employer's posting.
What you'll do
- Build and look after AWS data pipelines and ETL workflows
- Write SQL queries and create stored procedures using Oracle PL/SQL and PostgreSQL PL/pgSQL
- Use Amazon Redshift to process data and support analytics
- Tune query performance, resolve database and pipeline faults, and support data integration and transformation
- Coordinate with lead engineers on platform architecture and improvements
What you bring
- Four to seven years working in data engineering or database development
- Practical experience with Amazon Redshift and AWS services
- Strong Oracle PL/SQL skills and solid PostgreSQL PL/pgSQL experience
- Understanding of data warehousing, ETL, and query performance tuning
Who this fits
This senior role suits someone focused on data engineering or database development. It is a full-time, permanent hybrid position based in Lahore, Karachi, or Islamabad, Pakistan.
From the employer
Employment Type: Full-Time | Permanent
Location: Pakistan (Lahore / Karachi / Islamabad) – Hybrid
Role Overview
We are hiring Senior Data Engineers with solid experience in AWS, Amazon Redshift, Oracle PL/SQL, and PostgreSQL (PL/pgSQL). The role involves building and maintaining data pipelines, optimizing queries, and supporting scalable data platforms.
Experience
4–7 years of experience in Data Engineering or Database Development
Primary Skills
AWS Data Services, SQL Development, Data Processing, ETL Pipelines
Technologies
Must Have: Redshift, Oracle PL/SQL, PostgreSQL PL/pgSQL
Nice to Have: AWS (S3, Lambda), SQL, ETL Processes, Data Modeling, Linux/Unix, Git
Key Responsibilities
- Develop and maintain data pipelines and ETL workflows on AWS
- Write efficient SQL queries and build stored procedures in PL/SQL and PL/pgSQL
- Work with Amazon Redshift for analytics and data processing
- Perform query optimization and performance tuning
- Support data integration and transformation activities
- Troubleshoot database and data pipeline issues
- Collaborate with lead engineers on architecture and enhancements
Key Requirements
- Hands-on experience with Amazon Redshift and AWS ecosystem
- Strong expertise in Oracle PL/SQL development
- Good experience with PostgreSQL and PL/pgSQL
- Understanding of data warehousing concepts and ETL processes
- Exposure to query optimization and performance tuning
- Good communication and teamwork skills.