Snowflake Data Architect

Key Responsibilities:

• Architect and implement scalable data solutions using Snowflake.

• Design and optimize data models (star, snowflake, normalized) to support analytics and reporting.

• Lead the migration of legacy data warehouses to Snowflake.

• Define and enforce best practices for data ingestion, transformation, and storage.

• Collaborate with data engineers, analysts, and business stakeholders to align data architecture with business goals.

• Implement security, data governance, and compliance standards.

• Monitor and optimize Snowflake performance and cost efficiency.

• Stay current with Snowflake features and industry trends to drive innovation.

Must-Have Skills:

• 5+ years of experience in data architecture or engineering roles.

• 3+ years of hands-on experience with Snowflake.

• Strong expertise in SQL and data modeling (dimensional and normalized).

• Experience with ETL/ELT tools (e.g., dbt, Matillion, Informatica).

• Strong understanding of building ETL / ELT workloads using snowproc and snowflake SQL

• Proficiency in cloud platforms (AWS).

• Knowledge of data security, role-based access control, and data masking in Snowflake.

• Experience with performance tuning and cost optimization in Snowflake.

Nice-to-Have Skills:

• Experience in the life

• Snowflake certification (SnowPro Core or Advanced Architect).

• Experience with CI/CD pipelines for data workflows.

• Familiarity with Python or Scala for data processing.

• Experience with orchestration tools (e.g., Airflow, Prefect).

• Knowledge of data cataloging tools (e.g., Alation, Collibra).

• Exposure to real-time data streaming (e.g., Snowpipe).

• Experience in Agile/Scrum environments