Role & Responsibilities:

● In-depth knowledge of Snowflake’s data warehousing capabilities.
● Understanding of Snowflake’s virtual warehouse architecture and how to optimize performance and cost.
● Proficiency in using Snowflake’s data sharing and integration features for seamless collaboration.
● Develop and optimize complex SQL scripts, stored procedures, and data transformations.
● Work closely with data analysts, architects, and business teams to understand requirements and deliver reliable data solutions.
● Implement and maintain data models, dimensional modeling for data warehousing, data marts, and star/snowflake schemas to support reporting and analytics.
● Integrate data from various sources including APIs, flat files, relational databases, and cloud services.
● Ensure data quality, data governance, and compliance standards are met.
● Monitor and troubleshoot performance issues, errors,



and pipeline failures in Snowflake and associated tools.
● Participate in code reviews, testing, and deployment of data solutions in development and production environments.

Skills expectation:

o Experience with ETL/ELT tools and techniques, including Snowpipe, AWS Glue, openflow, fivetran or similar tools for real-time and periodic data processing.
o Strong skills in writing SQL queries, stored procedures, user-defined functions and functions in any of the SQL supported databases
o Skills in optimizing SQL queries for performance and efficiency and transforming data within Snowflake using SQL.
o Solid software development skills in Python o Experience with DBT for database object modeling and provisioning.
o Experience in version control tools, particularly Azure DevOps.

📌 Associate Architect Data (Bengaluru)
🏢 Quantiphi
📍 Bengaluru