Key Responsibilities:
- Lead the architecture, design, and deployment of scalable and secure Snowflake solutions.
- Collaborate with data engineers, analysts, and business stakeholders to define technical requirements.
- Develop and optimize data pipelines for ingestion and transformation using Snowflake and related tools.
- Implement performance tuning and workload management strategies in Snowflake.
- Drive data governance, security, and compliance standards in Snowflake.
- Design data models for analytics, reporting, and machine learning.
- Integrate Snowflake with various ETL/ELT tools, APIs, and BI platforms.
- Mentor junior team members and lead data architecture reviews.
Required Skills & Experience:
- 10+ years of experience in data engineering, cloud data architecture, or similar roles.
- 5+ years of hands-on experience architecting solutions on Snowflake.
- Strong expertise in SQL, performance tuning, and cost optimization within Snowflake.
- Experience with ETL/ELT tools like DBT, Informatica, Talend, Apache Airflow, etc.
- Knowledge of data modeling (dimensional, star/snowflake schema) and metadata management.
- Proficiency in cloud platforms (AWS, Azure, or GCP) with integration experience.
- Familiarity with Python, Scala, or Spark for data transformation tasks.
- Solid understanding of CI/CD pipelines, version control, and DevOps in a data context.
- Strong knowledge of data security, RBAC, and compliance best practices.
Nice to Have:
- Snowflake certification (SnowPro Core or Advanced Architect).
- Experience integrating Snowflake with Power BI, Tableau, or Looker.
- Background in financial services or Banking domains is a plus.