We are looking for a highly skilled Senior SQL Developer to join our team. As a Senior SQL Engineer, you will be responsible for designing, building, and maintaining complex databases using Athena and PrestoSQL.
This is a technical role that requires strong experience in query optimization, data modeling, and database performance tuning. You will work closely with data scientists and business analysts to translate data requirements into efficient SQL logic.
Key responsibilities include:
* Writing and optimizing complex SQL queries for large datasets
* Designing and maintaining data models, including fact/dimension structures, partitioning, and data integrity checks
* Building and managing data outputs in CSV, Excel, or other analytical formats
* Collaborating with data and business teams to ensure accurate and consistent data delivery
* Performing query tuning and cost optimization for S3-based storage environments
Required skills and qualifications include:
* 3-6 years of hands-on SQL development experience
* Proven production-level experience with Athena and PrestoSQL
* Strong experience working with data warehouses, data lakes, and S3-based querying
* Solid understanding of data modeling concepts, including star schema, partitioning, and data lineage
* Experience building and validating analytical datasets and exports
Benefits of this role include:
* A fast-paced and dynamic work environment
* The opportunity to work with a talented team of data professionals
* A competitive salary and benefits package
Nice to have skills and qualifications include:
* Familiarity with AWS Glue, Redshift, or Trino
* Experience with Python or lightweight ETL scripting
* Exposure to BI tools like Power BI, Tableau, or Looker
Ideal candidate characteristics include:
* Hard-working, detail-oriented, and self-driven
* Thrives in a fast-moving, independent, and fully remote setup
* Communicates clearly and works proactively with distributed teams