Lead Data Engineer (AWS / PLSQL / PL/PGSQL)

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.

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

Requirements

10+ years of experience in Data Engineering, Data Warehousing, and Database Development; AWS Data Engineering; Data Architecture; Data Warehousing; SQL Development; Must Have: Redshift, Oracle PL/SQL, PostgreSQL PL/pgSQL; 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

Nice to have

AWS (S3, Lambda); SQL; ETL/ELT; Data Modeling; Query Optimization; Performance Tuning; Linux/Unix; Git; CI/CD