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!
