We are looking for a Lead Data Engineer with strong expertise in AWS and database technologies (Oracle PL/SQL, PostgreSQL PL/pgSQL, Amazon Redshift).
Lead architecture and build of data pipelines and warehouse solutions on AWS
Design and optimize Amazon Redshift analytics platforms
Develop and review PL/SQL and PL/pgSQL procedures, functions and scripts
Drive data migration across Oracle, PostgreSQL and Redshift
Tune performance through indexing, partitioning and query optimization
From the employer’s posting
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.
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
Open 5 monthsWe first saw this posting 171 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
Status in our records
Live
First seen by us
Jun 3, 2026171 days ago
Recorded sightings
233
Last seen by us
Nov 21, 2026
Jun 3, 2026today
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
How this job compares
Time since we first saw it
Day 171
656
Up longer than most. Similar jobs usually come down between day 6 and day 56.
At NorthBay Solutions, jobs usually come down by about day 111.
From 14,771 similar postings that came down, and 11 of NorthBay Solutions’s. Coming down is not always a hire.
NorthBay Solutions is hiring
39 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
PL/SQL
SQL
AWS
Oracle
PostgreSQL
Redshift
S3
Where the posting names them
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
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
- 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
- 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
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
Key Responsibilities
- Lead the architecture and implementation of data pipelines and data warehouse solutions on AWS
- Design and optimize Amazon Redshift-based analytics platforms
Key Requirements
- Strong hands-on experience with AWS data ecosystem (Redshift, Glue, S3, Lambda)
- Advanced expertise in Oracle PL/SQL and PostgreSQL (PL/pgSQL)
- 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
- 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
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
Demand for Data Engineer roles
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
US government figures for database architects
Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.