Lead Data Engineer (AWS / PLSQL / PL/PGSQL)
Core
Lead the design, development, and optimization of scalable data platforms and enterprise-level data engineering initiatives.
Role type
Lead Data Engineer (AWS, PL/SQL, PL/pgSQL)
Builds
Scalable data platforms, data warehouse solutions, and analytics platforms on AWS
Domain
Cloud Data Engineering, Data Warehousing
Deliverable
production ML models
Required skills
AWS Data Engineering, Data Architecture, Data Warehousing, SQL Development, Redshift, Oracle PL/SQL, PostgreSQL PL/pgSQL, ETL/ELT, Data Modeling, Query Optimization, Performance Tuning
Preferred skills
Linux/Unix, Git, CI/CD, Technical leadership, Mentoring
Technologies
AWS, Redshift, Oracle, PostgreSQL, S3, Lambda, Glue
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, Mentor engineers, conduct code reviews, and provide technical leadership
Seniority
Senior, hands-on IC with leadership responsibilities