Snowflake Engineer

Snowflake Development: Build and optimize Snowflake objects (databases, schemas, tables, views, tasks, streams, resource monitors). ETL/ELT Pipelines: Develop and maintain robust data pipelines using DBT. Other tools like Airflow, Azure Data Factory or similar are added advantage. Data Modelling: Implement dimensional models (star/snowflake schemas), handle SCDs, and design efficient structures for analytics. Performance Tuning: Optimize queries, manage clustering, caching, and warehouse sizing for cost and speed. Data Quality: Implement testing frameworks (dbt tests, Great Expectations) and ensure data accuracy and freshness. Security & Governance: Apply RBAC, masking policies, and comply with data governance standards. Collaboration: Work with BI teams to ensure semantic alignment and support self-service analytics. Documentation: Maintain clear technical documentation for pipelines, models, and processes. Strong SQL skills (complex queries, performance tuning) and proficiency in Python for data processing. Experience with ETL/ELT tool DBT. (Airflow, ADF, Informatica, Matillion). Exposure to streaming/CDC (Fivetran, Kafka, Debezium). Solid understanding of data warehousing concepts (Kimball, Data Vault, normalization). Familiarity with cloud platforms (Azure preferred; AWS/GCP acceptable). Knowledge of data governance, security, and compliance (GDPR). Excellent problem-solving and communication skills. Experience with Snowpark, UDFs, dynamic tables, and external tables. BI tool integration (Power BI, Tableau, Looker). Certifications: SnowPro Core or Advanced.