Job Summary: We are seeking an experienced Snowflake architect specializing in data modeling to join our dynamic team. The ideal candidate will have a strong background in designing and implementing data models within the Snowflake environment, ensuring efficient data storage, retrieval, and analytics capabilities. This role requires deep technical expertise in Snowflake architecture, SQL, and ETL processes, along with a proven ability to collaborate with cross-functional teams to deliver scalable and reliable data solutions.
Responsibilities:
Data Modeling:
Design and implement scalable data models using Snowflake best practices.
Develop logical and physical data models based on business requirements.
Optimize data models for performance and efficiency, considering storage, retrieval, and computational costs.
Ensure data integrity and consistency across databases and data warehouses.
Snowflake Architecture:
Architect and maintain Snowflake environments, including databases, schemas, warehouses, and roles.
Implement Snowflake features such as clustering, partitioning, and materialized views to enhance performance.
Configure and optimize Snowflake storage options and virtual warehouses based on workload requirements.
Data Integration and ETL:
Collaborate with ETL developers to design and optimize data pipelines for ingesting and transforming data into Snowflake.
Implement data integration strategies to ensure seamless data flows between systems and platforms.
Monitor and troubleshoot ETL processes to ensure data quality and reliability.
Performance Tuning and Optimization:
Conduct performance tuning of SQL queries and data models to meet SLA requirements.
Implement indexing and caching strategies to improve query performance.
Monitor system performance metrics and recommend optimizations based on usage patterns.
Collaboration and Documentation:
Work closely with data engineers, analysts, and stakeholders to understand data requirements and deliver solutions.
Document data models, architecture designs, and configurations.
Provide technical guidance and mentorship to junior team members.
Requirements:
Proven experience as a Snowflake architect or data engineer with a focus on data modeling.
In-depth knowledge of Snowflake architecture, SQL, and database design principles.
Hands-on experience with designing and optimizing ETL processes.
Strong analytical and problem-solving skills, with the ability to troubleshoot complex issues.
Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team environment.
Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent work experience).
Snowflake certification (e.g., SnowPro Core) is a plus.