We're seeking a seasoned SQL professional to join our high-performance data team. This role is perfect for an individual with extensive experience in query optimization, data modeling, and transforming raw data into actionable insights.
About the Position
* Write and optimize complex SQL queries for large datasets in Athena and PrestoSQL.
* Design, maintain, and improve data models (fact/dimension structures, partitioning, data integrity checks).
* Build and manage data outputs in CSV, Excel, or other analytical formats.
* Collaborate with data and business teams to translate data requirements into efficient SQL logic.
* Perform query tuning and cost optimization for S3-based storage environments.
* Monitor query performance, troubleshoot data issues, and ensure accuracy and consistency.
Key Responsibilities
* Develop and refine complex SQL queries for massive datasets in AWS Athena and PrestoSQL.
* Create, update, and enhance data models (dimensional modeling, data warehousing).
* Construct and govern data outputs in CSV, Excel, or other business intelligence formats.
* Foster collaboration between data and business stakeholders to convert data needs into optimized SQL solutions.
* Improve query efficiency and reduce costs for S3-based data stores.
* Analyze query performance, resolve data discrepancies, and guarantee data reliability.
Essential Skills & Qualifications
* Minimum 3–6 years of hands-on SQL development experience (advanced query design, joins, CTEs, window functions).
* Mandatory: Proven production-level expertise with Athena and PrestoSQL.
* Strong background working with data warehouses, data lakes, and S3-based querying.
* In-depth understanding of data modeling principles (star schema, data lineage, partitioning).
* Experience building and validating analytical datasets and exports (CSV, Excel, BI feeds).
* Ability to thrive in fast-paced, remote, data-driven work environments.
Benefits
* A dynamic and supportive team environment.
* Opportunities for growth and professional development.
* A competitive salary and benefits package.
Nice to Have
* Familiarity with AWS Glue, Redshift, or Trino.
* Experience with Python or lightweight ETL scripting.
* Exposure to business intelligence tools like Power BI, Tableau, or Looker.
Ideal Candidate
* Dedicated, meticulous, and self-motivated.
* Thrives in a fast-moving, independent, and fully remote setup.
* Effective communication and teamwork skills.