PETADATA
Position: Snowflake Architect
Location: Research Triangle Park, NC (Onsite Only)
Job Type: Full‑Time
Position Summary We are seeking a highly skilled and experienced Snowflake Architect to design, implement, and manage Snowflake data warehousing solutions. The ideal candidate will have deep expertise in Snowflake architecture, cloud data solutions, and data engineering, working closely with stakeholders to ensure our data infrastructure is optimized, secure, and scalable.
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.
Lead implementation of Snowflake solutions, set up environments, schema design, and pipelines.
Integrate Snowflake with existing systems, data sources, and BI tools (e.g., Tableau, Power BI).
Oversee migration of data from on‑premises or other cloud platforms to Snowflake.
Monitor and optimize Snowflake performance, including query tuning, resource allocation, and cost management.
Implement strategies for data partitioning, clustering, and caching to enhance performance.
Ensure data security, privacy, and compliance with regulations (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 requirements.
Provide technical leadership and mentorship to junior team members.
Create and maintain documentation for architecture, data models, and processes.
Conduct training sessions and workshops on Snowflake features and best practices.
Identify and resolve issues related to environments, data quality, and performance.
Provide ongoing support and maintenance for high availability.
Stay up-to-date with Snowflake updates, new features, and industry trends.
Evaluate and recommend new tools, technologies, and methodologies.
Qualifications
12+ years of data architecture and engineering experience, with at least 6+ years explicitly with Snowflake.
Experience with data integration & migration, and data modularization and ERP systems.
Industry experience preferred: Manufacturing, Oil & Gas.
Expertise in Snowflake architecture, data modeling, ETL/ELT, and performance tuning.
Proficiency in SQL, data warehousing concepts, and cloud platforms (AWS, Azure, GCP).
Experience with data integration/ETL tools (e.g., Informatica, Talend, dbt).
Strong understanding of data security and compliance best practices.
Excellent problem‑solving and ability to work under pressure.
Strong communication skills, capable of presenting technical concepts to non‑technical stakeholders.
Certifications (preferred): Snowflake SnowPro, AWS Certified Solutions Architect, Microsoft Azure Data Engineer, etc.
Educational Qualification Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
Contact Please email your resume to:
jhansib@petadata.co . Candidates must attend phone/video/in‑person interviews and will undergo background checks on education and experience.
#J-18808-Ljbffr
Location: Research Triangle Park, NC (Onsite Only)
Job Type: Full‑Time
Position Summary We are seeking a highly skilled and experienced Snowflake Architect to design, implement, and manage Snowflake data warehousing solutions. The ideal candidate will have deep expertise in Snowflake architecture, cloud data solutions, and data engineering, working closely with stakeholders to ensure our data infrastructure is optimized, secure, and scalable.
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.
Lead implementation of Snowflake solutions, set up environments, schema design, and pipelines.
Integrate Snowflake with existing systems, data sources, and BI tools (e.g., Tableau, Power BI).
Oversee migration of data from on‑premises or other cloud platforms to Snowflake.
Monitor and optimize Snowflake performance, including query tuning, resource allocation, and cost management.
Implement strategies for data partitioning, clustering, and caching to enhance performance.
Ensure data security, privacy, and compliance with regulations (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 requirements.
Provide technical leadership and mentorship to junior team members.
Create and maintain documentation for architecture, data models, and processes.
Conduct training sessions and workshops on Snowflake features and best practices.
Identify and resolve issues related to environments, data quality, and performance.
Provide ongoing support and maintenance for high availability.
Stay up-to-date with Snowflake updates, new features, and industry trends.
Evaluate and recommend new tools, technologies, and methodologies.
Qualifications
12+ years of data architecture and engineering experience, with at least 6+ years explicitly with Snowflake.
Experience with data integration & migration, and data modularization and ERP systems.
Industry experience preferred: Manufacturing, Oil & Gas.
Expertise in Snowflake architecture, data modeling, ETL/ELT, and performance tuning.
Proficiency in SQL, data warehousing concepts, and cloud platforms (AWS, Azure, GCP).
Experience with data integration/ETL tools (e.g., Informatica, Talend, dbt).
Strong understanding of data security and compliance best practices.
Excellent problem‑solving and ability to work under pressure.
Strong communication skills, capable of presenting technical concepts to non‑technical stakeholders.
Certifications (preferred): Snowflake SnowPro, AWS Certified Solutions Architect, Microsoft Azure Data Engineer, etc.
Educational Qualification Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
Contact Please email your resume to:
jhansib@petadata.co . Candidates must attend phone/video/in‑person interviews and will undergo background checks on education and experience.
#J-18808-Ljbffr