Senior Data Engineering Specialist
We are seeking an experienced Senior Data Engineering Specialist to join our team. In this role, you will be responsible for designing, developing, and leading enterprise-grade data integration and analytics solutions.
About the Role
As a Senior Data Engineering Specialist, you will have the opportunity to work on complex projects that involve optimizing query and database performance, analyzing execution plans, and recommending indexing, partitioning, and optimization strategies. You will also partner with DBAs to validate and implement tuning recommendations, oversee ETL/ELT workflows, and leverage AWS services for ingestion, transformation, and storage.
Key Responsibilities:
* Optimize Query and Database Performance
* Analyze execution plans and recommend indexing, partitioning, and optimization strategies.
* Partner with DBAs to validate and implement tuning recommendations.
* Lead ETL/ELT Workflows
* Leverage AWS services (S3, Redshift, Glue, Lambda, DMS) for ingestion, transformation, and storage.
* Mentor and Lead Teams
* Translate technical decisions into clear explanations for both technical and business stakeholders.
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.
* Fluent in English.
Benefits
You will enjoy a dynamic environment where professionals have the opportunity to interact with different technologies, participate in all types of projects, bring new ideas, and work from anywhere in Brazil and worldwide. We offer autonomy, clear goals, and a collaborative team.