We are seeking a skilled Lead Data Engineer to design, develop and lead the delivery of high-performance data integration and analytics solutions.
This role involves leading technical decision-making, mentoring team members and collaborating with DBAs and business stakeholders to deliver scalable data solutions.
Key responsibilities include optimizing query and database performance, analyzing execution plans and recommending optimization strategies, partnering with DBAs to validate and implement tuning recommendations, overseeing ETL/ELT workflows, ensuring scalability, efficiency and data quality.
Leveraging AWS services such as S3, Redshift, Glue, Lambda and DMS for ingestion, transformation and storage is also essential.
The ideal candidate will have deep expertise in Oracle performance tuning, including query optimization, execution plans, indexes, partitioning and parallelism, hands-on experience writing and optimizing complex SQL queries, expertise 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 and fluency in English.
Nice to have skills include hands-on experience with AWS data services, prior experience in wealth management.
About the Role
As a Lead Data Engineer, you will be responsible for designing, developing and delivering high-performance data integration and analytics solutions. You will lead technical decision-making, mentor team members and collaborate with DBAs and business stakeholders to deliver scalable data solutions.
Responsibilities
* Optimize query and database performance to meet strict SLAs (<2 seconds)
* Analyze execution plans and recommend indexing, partitioning and optimization strategies
* Partner with DBAs to validate and implement tuning recommendations
* Oversee ETL/ELT workflows, ensuring scalability, efficiency and data quality
* Leverage AWS services (S3, Redshift, Glue, Lambda, DMS) for ingestion, transformation and storage
Requirements
* 7+ years of experience in data engineering within enterprise-scale environments
* Expertise in Oracle performance tuning, including query optimization, execution plans, indexes, partitioning and parallelism
* Hands-on experience writing and optimizing complex SQL queries
* Expertise 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
* Fluency in English
Nice to Have
* Hands-on experience with AWS data services (S3, Redshift, Glue, Lambda, DMS)
* Prior experience in wealth management