Jobs via Dice
Snowflake Architect
Location:
Houston, TX, Onsite Only Experience:
10+ years Job Type:
Full-Time/Part-Time/Contract Position Summary
We are seeking a highly skilled and experienced Snowflake Architect to design, implement, and manage our Snowflake data warehousing solutions. The ideal candidate will possess deep expertise in Snowflake architecture, cloud data solutions, and data engineering. You will work closely with stakeholders to ensure our data infrastructure is optimized, secure, and scalable to meet our business needs. Key Responsibilities Architectural Design 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.
Implementation and Integration
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.
Performance Optimization
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.
Security and Compliance
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.
Collaboration and Leadership
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. Facilitate discussions with stakeholders to gather requirements, present solutions, and obtain feedback.
Documentation and Training
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.
Troubleshooting and Support
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.
Innovation and Improvement
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
12+ years of experience in data architecture and engineering, with at least 6+ years explicitly working with Snowflake. Experience in data integration & migration. Experience in data modularization and ERP Systems. Industry experience in Manufacturing, Oil & Gas 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 ability to work under pressure. Strong communication skills, with ability to present technical concepts to non-technical stakeholders. Certifications: Snowflake SnowPro Certification. Cloud platform certifications (AWS Certified Solutions Architect, Microsoft Azure Data Engineer, etc.).
Educational Qualification
Bachelor's/ Masters degree in Computer Science, Engineering, or a related field. Seniority level
Mid-Senior level Employment type
Part-time Job function
Design, Art/Creative, and Information Technology #J-18808-Ljbffr
Location:
Houston, TX, Onsite Only Experience:
10+ years Job Type:
Full-Time/Part-Time/Contract Position Summary
We are seeking a highly skilled and experienced Snowflake Architect to design, implement, and manage our Snowflake data warehousing solutions. The ideal candidate will possess deep expertise in Snowflake architecture, cloud data solutions, and data engineering. You will work closely with stakeholders to ensure our data infrastructure is optimized, secure, and scalable to meet our business needs. Key Responsibilities Architectural Design 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.
Implementation and Integration
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.
Performance Optimization
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.
Security and Compliance
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.
Collaboration and Leadership
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. Facilitate discussions with stakeholders to gather requirements, present solutions, and obtain feedback.
Documentation and Training
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.
Troubleshooting and Support
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.
Innovation and Improvement
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
12+ years of experience in data architecture and engineering, with at least 6+ years explicitly working with Snowflake. Experience in data integration & migration. Experience in data modularization and ERP Systems. Industry experience in Manufacturing, Oil & Gas 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 ability to work under pressure. Strong communication skills, with ability to present technical concepts to non-technical stakeholders. Certifications: Snowflake SnowPro Certification. Cloud platform certifications (AWS Certified Solutions Architect, Microsoft Azure Data Engineer, etc.).
Educational Qualification
Bachelor's/ Masters degree in Computer Science, Engineering, or a related field. Seniority level
Mid-Senior level Employment type
Part-time Job function
Design, Art/Creative, and Information Technology #J-18808-Ljbffr