While technology is the heart of our business, a global and diverse culture is the heart of our success. We love our people and we take pride in catering them to a culture built on transparency, diversity, integrity, learning and growth.

If working in an environment that encourages you to innovate and excel, not just in professional but personal life, interests you- you would enjoy your career with Quantiphi!

Role:Associate Architect - Data (Snowflake)

Experience Level: 7-10 Years

Work location: Bangalore

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 standard 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.

Must have skills:

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

Associate Architect- Data (Snowflake)