 
        
        Job Title: Lead Data Engineer
Our organization is seeking a skilled Lead Data Engineer to spearhead the development and implementation of cutting-edge data integration and analytics solutions.
Key Responsibilities:
 * Optimize database performance to meet strict service level agreements (<2 seconds).
 * Analyze execution plans and recommend indexing, partitioning, and optimization strategies to enhance query performance.
 * Collaborate with DBAs to validate and implement tuning recommendations to ensure optimal database performance.
 * Oversee ETL/ELT workflows to guarantee scalability, efficiency, and high-quality data.
 * Utilize AWS services (S3, Redshift, Glue, Lambda, DMS) for data ingestion, transformation, and storage.
 * Lead and mentor the team to foster technical excellence and continuous improvement.
 * Translate complex technical concepts into clear explanations for both technical and business stakeholders.
Required Qualifications:
 * 7+ years of experience in data engineering within large-scale enterprise environments.
 * Expertise in Oracle performance tuning, including query optimization, execution plans, indexes, partitioning, and parallelism.
 * Hands-on experience writing and optimizing complex SQL queries.
 * Proficiency in Oracle Data Integrator (ODI).
 * Experience in data warehouse design, ETL/ELT processes, and data modeling.
 * Proven leadership experience, including team mentoring and technical guidance.
 * Excellent communication skills, with the ability to collaborate effectively with DBAs, technical teams, and business stakeholders.