Snowflake Data Architect_96523

Company:IT Services Organization

Key Skills: Snowflake DB, Erwin, Data Architecture, Snowflake, AWS, Informatica, DataStage

Roles & Responsibilities:

• Design and implement scalable data architecture solutions using Snowflake.
• Develop and maintain data models using Erwin, including star schemas, snowflake schemas, and highly normalized data models.
• Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications.
• Ensure data integrity, quality, and consistency through effective data profiling and ETL processes.
• Work with ETL tools such as Informatica and DataStage to build and maintain data pipelines.
• Utilize AWS services such as S3, Lambda, and Data Pipeline to support data integration and processing.
• Optimize SQL queries and data warehouse performance for scalability and efficiency.
• Implement best practices in data governance, data modeling, and data architecture.
• Provide technical leadership, guidance, and mentorship to junior team members.
• Stay updated with the latest trends and technologies in cloud data platforms and data architecture.

Experience Required:

• 6 - 8 years of experience in data architecture, data modeling, or data engineering roles.
• Strong hands-on experience with Snowflake data warehouse architecture and implementation.
• Experience with data modeling tools such as Erwin.
• Hands-on experience with ETL tools like Informatica or DataStage.
• Good understanding of AWS cloud services related to data platforms.
• Strong SQL skills and experience optimizing queries in large-scale data environments.
• Experience working in data warehousing and big data environments.

Education: Any Graduation