Associate Architect Data (Snowflake)

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 Strong software development skills in Python o Experience with DBT for database object modeling and provisioning.

o Experience in version control tools, particularly Azure DevOps.