Associate Architect- Data (Snowflake)

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.