Enterprise Data Solutions Architect
We are seeking a highly skilled and experienced Enterprise Data Solutions Architect to lead the design, development, and delivery of enterprise-grade data integration and analytics solutions. As a key member of our team, you will be responsible for designing and implementing scalable, efficient, and high-performing data architectures that meet the needs of our business.
Key Responsibilities:
* Optimize Database Performance: Develop and implement strategies to optimize database query performance, ensuring that queries execute within strict SLAs (< 2 seconds).
* Analyze Execution Plans: Analyze execution plans and recommend indexing, partitioning, and optimization strategies to improve database performance.
* Collaborate with DBAs: Partner with DBAs to validate and implement tuning recommendations, ensuring that database configurations are optimized for performance.
* Lead ETL/ELT Workflows: Oversee ETL/ELT workflows, ensuring scalability, efficiency, and data quality, while leveraging AWS services (S3, Redshift, Glue, Lambda, DMS) for ingestion, transformation, and storage.
* Leverage Technical Expertise: Leverage your expertise in Oracle performance tuning, including query optimization, execution plans, indexes, partitioning, and parallelism, to drive technical excellence and continuous improvement.
Required Qualifications:
* 7+ Years of Experience: Possess 7+ years of experience in data engineering within enterprise-scale environments.
* Oracle Performance Tuning: Demonstrate expertise in Oracle performance tuning, including query optimization, execution plans, indexes, partitioning, and parallelism.
* Complex SQL Queries: Possess hands-on experience writing and optimizing complex SQL queries.
* Oracle Data Integrator (ODI): Demonstrate expertise in Oracle Data Integrator (ODI).
* Data Warehouse Design: Possess experience in data warehouse design, ETL/ELT processes, and data modeling.
* Proven Leadership: Demonstrate proven leadership experience, including team mentoring and technical guidance.
* Excellent Communication: Possess excellent communication skills, with the ability to collaborate effectively with DBAs, technical teams, and business stakeholders.
What We Offer:
We offer autonomy, clear goals, and a dynamic and challenging environment where professionals can interact with different technologies, participate in all types of projects, bring new ideas, and work from anywhere in Brazil or around the world.
We value diversity and inclusion, and we are committed to creating an environment where everyone feels welcome and valued.