We are seeking a highly experienced and results-oriented Snowflake Architect to lead the design, implementation, and optimization of our cloud-based data warehouse solutions on the Snowflake platform & will be responsible for architecting scalable, performant, and secure data models and pipelines. Your deep understanding of data warehousing principles, combined with extensive hands-on experience with DBT and SQL, will be crucial in driving our data-driven initiatives.

Required Snowflake Experience: 5 years

Responsibilities :

- Snowflake Architecture & Design :Design and implement scalable and efficient data models, data warehousing architectures, and ETL/ELT pipelines on the Snowflake platform.
- Performance Optimization :Optimize Snowflake query performance, storage utilization, and overall system efficiency. Implement best practices for data loading, transformation, and querying.
- Data Modeling :Develop and maintain logical and physical data models that align with business requirements and ensure data integrity and consistency.
- DBT Development & Implementation :Leverage your extensive hands-on experience with DBT to build and maintain robust and modular data transformation workflows. Implement data quality checks and testing frameworks within DBT.
- SQL Expertise :Utilize your strong SQL skills for data manipulation, querying, analysis, and performance tuning within the Snowflake environment.
- Security & Governance :Implement and enforce data security policies, access controls, and data governance frameworks within Snowflake.




- Mentorship & Guidance :Provide technical guidance and mentorship to junior data engineers.

Mandatory Skills & Experience:

- 10+ years of overall industry experience in data warehousing and data engineering.
- 5+ years of demonstrable hands-on experience designing, implementing, and managing data solutions on the Snowflake platform.
- 5+ years of deep and practical hands-on experience with DBT (Data Build Tool) for data transformation and modeling.
- Expert-level proficiency in SQL, including complex queries, performance tuning, and stored procedures.
- Strong understanding of data warehousing concepts, including dimensional modeling (Kimball, Inmon), ETL/ELT processes, and data governance.
- Experience with cloud data integration tools and technologies (e.g., Fivetran, Airbyte, AWS Glue, Azure Data Factory).
- Solid understanding of data security principles and best practices in a cloud setting.
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration skills.
- Bachelor's degree in Computer Science, Engineering, or a related field.

Nice-to-Have Skills & Experience:

- Experience with migrating data warehouses from on-premise systems or other cloud platforms to Snowflake.
- Familiarity with scripting languages like Python for automation and data processing.
- Experience with data visualization tools (e.g., Tableau, Power BI).
- Knowledge of DevOps practices and CI/CD pipelines for data engineering.
- Experience with data quality frameworks and tools.
- Relevant Snowflake certifications.

Pay: ₹3,500,000.00 - ₹5,000,000.00 per year

Work Location: In person

📌 Snowflake Architect Jd (Noida)
🏢 Phoenix Business Consulting
📍 Noida