Snowflake Senior Developer

Summary of role

We are seeking a Snowflake Senior Developer to design, develop, and optimize data solutions on our cloud data platform. You will work closely with data engineers, analysts, and architects to deliver high-quality, scalable data pipelines and models. Strong expertise in Snowflake, ETL/ELT, data modelling, and data warehousing is essential.

• 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 tools like dbt, Airflow, Azure Data Factory, or similar.
• Data Modeling:
  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.

• National Senior Certificate or G
  CSE (General Certificate of Secondary Education)
• Strong SQL skills (complex queries, performance tuning) and proficiency in Python for data processing.
• Experience with ETL/ELT tools (dbt, Airflow, ADF, Informatica, Matillion).
• 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.
• Exposure to streaming/CDC (Kafka, Fivetran, Debezium).
• BI tool integration (Power BI, Tableau, Looker).
• Certifications:
  
  Snow Pro Core or Advanced.