Technical Requirements & Skills
- Advanced SQL Mastery:
Expert proficiency in writing analytical queries utilizing Window functions (RANK, LEAD/LAG), complex JOIN operations, and Common Table Expressions (CTEs).
- Database & Warehouse Platforms:
Hands-on experience operating enterprise relational systems (e.g., PostgreSQL, SQL Server) and cloud-native analytical platforms (e.g., Snowflake, BigQuery, Databricks, Azure Synapse).
- Programming Languages:
Proficient in Python, Scala, or PySpark to handle tasks that extend beyond pure SQL capabilities, such as advanced pipeline automation.
- ETL Tools & Orchestration:
Experience utilizing workflow transformation and orchestration tools like dbt, Apache Airflow.
- Cloud Architecture:
Foundational familiarity deploying data services within a major cloud landscape such as AWS, Google Cloud, or Microsoft Azure.