We are seeking an expert Data Architect to lead our team in designing and delivering high-performance, scalable data solutions. This individual will have expertise in query optimization, execution plans, indexing, and partitioning strategies.
Responsibilities:
* Develop complex SQL queries to meet strict SLAs (<2 seconds).
* Analyze execution plans and recommend tuning strategies.
* Collaborate with DBAs to implement tuning recommendations.
* Oversee ETL/ELT workflows for scalability, efficiency, and data quality.
* Leverage AWS services for ingestion, transformation, and storage.
* Mentor the team, promoting technical excellence and continuous improvement.
* Communicate technical decisions to 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.
* Experience in data warehouse design, ETL/ELT processes, and data modeling.
* Proven leadership experience, including team mentoring and technical guidance.
* Excellent communication skills, collaborating effectively with DBAs, technical teams, and business stakeholders.
Bonus Points:
* Hands-on experience with AWS data services (S3, Redshift, Glue, Lambda, DMS).
* Prior experience in financial institutions.