About the Position
We seek a seasoned SQL professional to collaborate with our high-performance data team, leveraging expertise in Athena and PrestoSQL to drive business growth.
Key Responsibilities:
1. Create complex SQL queries for large datasets in AWS Athena and PrestoSQL, ensuring optimal performance and scalability.
2. Design, maintain, and enhance data models (fact/dimension structures, partitioning, data integrity checks), aligning with business objectives.
3. Develop and manage data outputs in CSV, Excel, or other analytical formats, meeting stakeholder requirements.
4. Partner with data and business teams to translate data needs into efficient SQL logic, driving informed decision-making.
5. Tune query performance and optimize costs for S3-based storage environments, minimizing resource utilization.
6. Monitor query performance, troubleshoot data issues, and ensure accuracy and consistency, upholding data quality standards.
Requirements:
* 3–6 years of hands-on SQL development experience (advanced query design, joins, CTEs, window functions).
* Mandatory: Proven production-level experience with Athena and PrestoSQL, delivering scalable solutions.
* Strong background working with data warehouses, data lakes, and S3-based querying, driving business insights.
* Solid understanding of data modeling concepts (star schema, partitioning, data lineage), ensuring data integrity.
* Experience building and validating analytical datasets and exports (CSV, Excel, BI feeds), meeting stakeholder expectations.