Snowflake Data Architect

4 days ago

Bengaluru, KA, India Tecnoprism Remote Full-time
Job Overview We are looking for an experienced Snowflake Data Architect with strong expertise in designing and implementing scalable, cloud-based data warehouse solutions. The ideal candidate should have hands-on experience in Snowflake architecture, data modelling, ELT pipelines, SQL and modern data transformation frameworks such as dbt. Mandatory Skills
- Strong hands-on experience in Snowflake.
- Advanced SQL and data warehousing concepts.
- Data architecture and data modelling.
- ETL/ELT pipeline development.
- Cloud platforms AWS / Azure / GCP.
- Experience in performance tuning and query optimisation.
- Strong understanding of modern data engineering practices. Preferred Skills
- dbt (Data Build Tool).
- Snowpark and Python.
- Apache Airflow.
- Matillion / Informatica / Coalesce.
- CI/CD and Git.
- Data Vault 2.0.
- Experience with large-scale enterprise data platforms.

Key Responsibilities

- Design and implement scalable data warehouse architectures using Snowflake.
- Develop and optimise complex SQL queries, stored procedures and Snowflake workloads.
- Design and implement data transformation pipelines using dbt.
- Build efficient ELT/ETL workflows and integrate data from multiple sources.
- Implement data modelling techniques including Star Schema, Snowflake Schema and Data Vault.
- Optimise Snowflake performance, compute resources and query execution.
- Establish data governance, data quality, security and access control standards.
- Collaborate with data engineers, analytics teams and business stakeholders.
- Provide technical leadership and architectural guidance to development teams.