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.