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.