Data Engineer (Advanced SQL)

Overall Experience: 6-10 Yrs

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.