Snowflake Architect

Overview

Position:
Snowflake Architect

Location:

Research Triangle Park, NC, Onsite Only

Experience:

10+ years

Job Type: Full-Time/Part-Time/Contract

PETADATA is currently looking to hire for the position of Snowflake Architect for one of their clients.

• Design and develop Snowflake data warehouse architectures to support various business needs.
• Create scalable and efficient data models and workflows, including data ingestion, transformation, and storage.
• Develop best practices and standards for Snowflake architecture and ensure adherence across projects.
• Architectural Design

• Lead the implementation of Snowflake solutions, including setting up Snowflake environments, schema design, and data pipelines.
• Integrate Snowflake with existing systems, data sources, and BI tools (e.g., Tableau, Power BI).
• Oversee the migration of data from on-premises or other cloud platforms to Snowflake.

• Monitor and optimize Snowflake performance, including query performance tuning, resource allocation, and cost management.
• Implement strategies for data partitioning, clustering, and caching to enhance performance.

• Ensure data security, privacy, and compliance with relevant regulations (e.g., GDPR, CCPA).
• Implement and manage Snowflake s security features, such as access controls, encryption, and data masking.

• Work closely with data engineers, data scientists, and business analysts to understand data requirements and deliver solutions that meet their needs.
• Provide technical leadership and mentorship to junior team members and other stakeholders.
• Facilitate discussions with stakeholders to gather requirements, present solutions, and obtain feedback.

• Create and maintain comprehensive documentation for Snowflake architecture, data models, and processes.
• Conduct training sessions and workshops to educate team members and end-users on Snowflake features and best practices.

• Identify and resolve issues related to Snowflake environments, data quality, and performance.
• Provide ongoing support and maintenance for Snowflake systems, ensuring high availability and reliability.

• Stay up-to-date with Snowflake updates, new features, and industry trends.
• Evaluate and recommend new tools, technologies, and methodologies to enhance data architecture and operations.

• Experience:
  
  12+ years of experience in data architecture and engineering, with at least 6+ years explicitly working with Snowflake.
• Must have data integration & Migration experience
• Required data modularization and ERP Systems experience
• Manufacturing, Oil & Gas industry experience is preferred.
• Expertise in Snowflake architecture, including data modeling, ETL/ELT processes, and performance tuning.
• Proficiency with SQL, data warehousing concepts, and cloud data platforms (AWS, Azure, Google Cloud).
• Experience with data integration and ETL tools (e.g., Informatica, Talend, dbt).
• Strong understanding of data security and compliance best practices.
• Excellent problem-solving skills and the ability to work under pressure.
• Strong communication skills, with the ability to present technical concepts to non-technical stakeholders.
• Certifications (Preferred):
  • Snowflake Snow Pro Certification.
  • Cloud platform certifications (AWS Certified Solutions Architect, Microsoft Azure Data Engineer, etc.).

Bachelor s/ Master’s degree in Computer Science, Engineering, or a related field.

We offer a professional work environment and are given every opportunity to grow in the Information technology world.

Candidates are required to attend Phone/Video Call / In person interviews. After selection, there will be background checks on Education and Experience.

Please email your resume to:

After carefully reviewing your experience and skills, one of our HR team members will contact you on the next steps.