About Our Ideal Candidate
We are seeking a seasoned SQL developer with deep expertise in data analytics and query optimization. The ideal candidate will have hands-on experience working with large-scale datasets, cloud-based databases, and distributed systems.
This role requires a strong understanding of data modeling concepts, including star schema, partitioning, and data lineage. Additionally, the candidate should have a solid grasp of advanced query design, joins, CTEs, and window functions.
-----------------------------------
Key Responsibilities:
* Design and implement complex SQL queries for large datasets using AWS Athena and PrestoSQL.
* Maintain and improve existing data models to ensure optimal performance and scalability.
* Develop and manage data outputs in CSV, Excel, or other analytical formats.
* Collaborate with cross-functional teams to translate business requirements into efficient SQL logic.
* Monitor query performance, troubleshoot data issues, and ensure accuracy and consistency.
-----------------------------------
Requirements & Qualifications:
* 3-6 years of hands-on experience in SQL development (advanced query design, joins, CTEs, window functions).
* Mandatory: 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 (star schema, partitioning, data lineage).
* Experience building and validating analytical datasets and exports (CSV, Excel, BI feeds).
* Comfortable working in fast-paced, remote, data-driven environments.