Snowflake Data Architect
4 days ago
Bengaluru, KA, India
Tecnoprism
Remote
Full-time
Free with email or Google
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
Free with email or Google
By continuing, you agree to our Terms & Privacy Policy.
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.
- 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.