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.
If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!
