Logo
PETADATA

Snowflake Architect

PETADATA, Milwaukee, Wisconsin, United States, 53244

Save Job

Experience:

12+ years in data architecture and engineering, with at least 6+ years explicitly working with Snowflake.

Job Type:

Full-Time

Location:

Houston, TX (Onsite Only)

Position Summary We are seeking a highly skilled Snowflake Architect to design, implement, and manage Snowflake data warehousing solutions. The ideal candidate will possess deep expertise in Snowflake architecture, cloud data solutions, and data engineering and will work closely with stakeholders to ensure our data infrastructure is optimized, secure, and scalable to meet our business needs.

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, including set‑up of environments, schema design, and data 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: query tuning, resource allocation, cost management.

Implement strategies for data partitioning, clustering, and caching to enhance performance.

Ensure data security, privacy, and compliance with regulations (e.g., GDPR, CCPA).

Manage Snowflake security features: access controls, encryption, data masking.

Collaborate with data engineers, data scientists, and business analysts to understand requirements and deliver solutions.

Provide technical leadership and mentorship to junior team members.

Document architecture, data models, and processes; conduct training sessions for team members and end‑users.

Identify and resolve issues related to Snowflake environments, data quality, and performance; provide ongoing support.

Stay up‑to‑date with Snowflake updates, new features, and industry trends; evaluate and recommend new tools and methodologies.

Qualifications

Experience: 12+ years in data architecture and engineering, with at least 6+ years explicitly working with Snowflake.

Data integration and migration experience.

Data modularization and ERP systems experience.

Preferred industry experience: Manufacturing, Oil & Gas.

Expertise in Snowflake architecture: data modeling, ETL/ELT processes, 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; 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 or Master’s degree in Computer Science, Engineering, or a related field.

Contact To apply, please email your resume to

jhansib@petadata.co . Candidates will attend phone/video interviews and, upon selection, will complete required background checks.

Seniority Level Mid‑Senior level

Employment Type Full‑time

Job Function Design, Information Technology

#J-18808-Ljbffr