As a seasoned SQL professional, you will be part of a high-performing team that is shaping the future of data-driven decision making.
Your primary responsibility will be to design and develop large-scale SQL queries and data models that support analytics and reporting workflows across distributed data systems.
Key Responsibilities:
* Create complex SQL queries for large datasets in AWS Athena and PrestoSQL, ensuring optimal performance and efficiency.
* Develop and maintain robust data models, fact/dimension structures, partitioning, and data integrity checks to ensure accurate and reliable outputs.
* Transform raw data into actionable insights by building and managing data outputs in CSV, Excel, or other analytical formats.
* Collaborate with cross-functional teams to translate business requirements into efficient SQL logic, driving data-driven decision making.
* Tune query performance and optimize costs for S3-based storage environments, ensuring scalability and reliability.
* Maintain query performance, troubleshoot data issues, and guarantee accuracy and consistency.