Overview
PETADATA is currently looking to hire for the position of SNOWFLAKE ARCHITECT for one of their clients.
Experience : 10+ YRS
Job Type : [Full-Time / Part-Time / Contract]
Position : Snowflake Architect
Location : Houston, TX, Onsite Only
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.
- Data Modeling and Workflows : Create scalable and efficient data models and workflows, including data ingestion, transformation, and storage.
- Standards and Best Practices : 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.
- System Integration : Integrate Snowflake with existing systems, data sources, and BI tools (e.g., Tableau, Power BI).
- Data Migration : 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.
- Security and Compliance : Ensure data security, privacy, and compliance with relevant regulations (e.g., GDPR, CCPA). Implement and manage Snowflake security features, such as access controls, encryption, and data masking.
- Collaboration and Leadership : Work with data engineers, data scientists, and business analysts to understand data requirements and deliver solutions; provide technical leadership and mentorship to junior team members.
- Documentation and Training : Create and maintain comprehensive documentation; conduct training sessions and workshops 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.
- Innovation and Improvement : Stay up-to-date with Snowflake updates and industry trends; evaluate and recommend new tools, technologies, and methodologies.
Qualifications
Experience : 12+ years in data architecture and engineering, with at least 6+ years explicitly working with Snowflake.Must have data integration and 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, 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 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.
Note
Candidates required to attend phone / video / in-person interviews and, after selection, must go through all background checks on education and experience. Please email your resume to : jhansib@petadata.co. After carefully reviewing your experience and skills, one of our HR team members will contact you on the next steps.
Seniority level
Mid-Senior levelEmployment type
Full-timeJob function
Design, Art / Creative, and Information TechnologyIndustries
Technology, Information and InternetJ-18808-Ljbffr