Snowflake Data Architect

Job Title- Snowflake Data Architect

Experience- 9 to 15 Years

Location- Gurugram

Job Summary:

We are seeking a highly experienced and motivated Snowflake Data Architect & ETL Specialist to join our growing Data & Analytics team. The ideal candidate will be responsible for designing scalable Snowflake-based data architectures, developing robust ETL/ELT pipelines, and ensuring data quality, performance, and security across multiple data environments. You will work closely with business stakeholders, data engineers, and analysts to drive actionable insights and ensure data-driven decision-making.

Key Responsibilities:

• Design, develop, and implement scalable Snowflake-based data architectures.
• Build and maintain ETL/ELT pipelines using tools such as Informatica, Talend, Apache NiFi, Matillion, or custom Python/SQL scripts.
• Optimize Snowflake performance through clustering, partitioning, and caching strategies.
• Collaborate with cross-functional teams to gather data requirements and deliver business-ready solutions.
• Ensure data quality, governance, integrity, and security across all platforms.
• Migrate legacy data warehouses (e.g., Teradata, Oracle, SQL Server) to Snowflake.
• Automate data workflows and support CI/CD deployment practices.
• Implement data modeling techniques including dimensional modeling, star/snowflake schema, normalization/denormalization.
• Support and promote metadata management and data governance best practices.

Technical Skills (Hard Skills):

• Expertise in Snowflake: Architecture design, performance tuning, cost optimization.
• Strong proficiency in SQL, Python, and scripting for data engineering tasks.
• Hands-on experience with ETL tools: Informatica, Talend, Apache NiFi, Matillion, or similar.
• Proficient in data modeling (dimensional, relational, star/snowflake schema).
• Good knowledge of Cloud Platforms: AWS, Azure, or GCP.
• Familiar with orchestration and workflow tools such as Apache Airflow, dbt, or DataOps frameworks.
• Experience with CI/CD tools and version control systems (e.g., Git).
• Knowledge of BI tools such as Tableau, Power BI, or Looker.

Certifications (Preferred/Required):

• ✅ Snowflake SnowPro Core Certification – Required or Highly Preferred
• ✅ SnowPro Advanced Architect Certification – Preferred
• ✅ Cloud Certifications (e.g., AWS Certified Data Analytics – Specialty, Azure Data Engineer Associate) – Preferred
• ✅ ETL Tool Certifications (e.g., Talend, Matillion) – Optional but a plus

Soft Skills:

• Strong analytical and problem-solving capabilities.
• Excellent communication and collaboration skills.
• Ability to translate technical concepts into business-friendly language.
• Proactive, detail-oriented, and highly organized.
• Capable of multitasking in a fast-paced, dynamic environment.
• Passionate about continuous learning and adopting new technologies.

Why Join Us?

• Work on cutting-edge data platforms and cloud technologies
• Collaborate with industry leaders in analytics and digital transformation
• Be part of a data-first organization focused on innovation and impact
• Enjoy a flexible, inclusive, and collaborative work culture