Snowflake Architect / Lead

Job Summary :

We are looking for a highly experienced Senior Lead Data Engineer / Architect specializing in Snowflake data warehousing, with strong skills in Power BI . The ideal candidate will have 8–10 years of experience in data engineering and analytics, with proven leadership in designing, implementing, and optimizing large-scale Snowflake architectures and developing high-impact business intelligence solutions using Power BI.

Key Responsibilities :

• Lead the end-to-end architecture, design, and implementation of enterprise-grade data solutions on Snowflake.
• Build and maintain complex data pipelines and advanced ETL / ELT frameworks, leveraging Snowflake’s native features for scalability and performance.
• Optimize Snowflake databases, warehouses, secure data sharing, and storage structures for cost and performance efficiency.
• Collaborate with data architects and engineers to establish best practices for data governance, data security (RBAC, masking), and lifecycle management in Snowflake.
• Leverage advanced Snowflake capabilities : Streams, Tasks, Time Travel, Zero Copy Cloning, Data Sharing, and Materialized Views.
• Write highly optimized SQL queries, UDFs (user-defined functions), and scripts for large-scale analytics workloads.
• Mentor junior developers in Snowflake best practices, performance tuning, and troubleshooting.
• Drive integration between Power BI and Snowflake using native connectors and optimal data modeling.
• Support data security implementation, including Row-Level Security (RLS) and Column-Level Security (CLS) in both Snowflake and Power BI.

Qualifications :