Snowflake Architect

PETADATA; Milwaukee (WI); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Professional work environment

Growth opportunities in IT

Job summary

A technology solutions company is seeking a Snowflake Architect to design and implement data warehouse solutions. The ideal candidate will have at least 12 years of experience in data architecture, with 6 years specifically working with Snowflake. Responsibilities include developing data models, ensuring data security, and mentoring team members. This role provides a professional work environment with growth opportunities in the IT sector.

Qualifications

• 12+ years of data architecture and engineering experience, with 6+ years working with Snowflake.
• Strong understanding of data security and compliance best practices.
• Experience in Manufacturing, Oil & Gas industry preferred.

Responsibilities

• Design and develop Snowflake data warehouse architectures.
• Lead the implementation of Snowflake solutions.
• Monitor and optimize Snowflake performance.
• Ensure data security and compliance.
• Provide technical leadership and mentorship.

Skills

Snowflake architecture expertise

Data integration & Migration experience

Data modularization

Proficiency in SQL

Excellent problem-solving skills

Education

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

Tools

Informatica

Talend

dbt

AWS

Azure

Google Cloud

Job description

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.

Key Responsibilities

• 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.

Qualifications

• 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 SnowPro Certification.
  • Cloud platform certifications (AWS Certified Solutions Architect, Microsoft Azure Data Engineer, etc.).

Educational Qualification

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.

Note

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: [e-mail]

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