<div><div><div><p>CBTS is in search of a a skilled&nbsp;<strong>Snowflake Architect</strong>&nbsp;to manage, monitor, and optimize our Snowflake data warehouse. The role involves ensuring the stability, performance, security, and accessibility of the Snowflake environment. The ideal candidate will have a deep understanding of Snowflake architecture, cloud computing platforms, and database management, with experience in administering data solutions at scale.</p><p>This is an opportunity to stand up a new Snowflake environment. Enterprise as been on- prem Oracle and is implementing Snowflake - so looking for a candidate with greenfield experience.</p><p>***NO 3rd PARTY REQUEST PLEASE***</p><p>Duties</p><p><strong>Snowflake Environment Setup &amp; Maintenance:</strong></p><ul><li>Set up and configure Snowflake accounts, virtual warehouses, databases, and other components. Regularly monitor the environment for performance, utilization, and cost management.</li></ul><p><strong>Security &amp; Access Control:</strong></p><ul><li>Implement and manage security controls, including user roles, permissions, and network policies. Enforce best practices for data governance, including encryption and compliance with regulatory requirements.</li></ul><p><strong>Performance Monitoring &amp; Optimization:</strong></p><ul><li>Continuously monitor performance metrics, optimize queries, manage workload balancing, and tune system configurations to improve performance and reduce costs.</li></ul><p><strong>Backup &amp; Recovery:</strong></p><ul><li>Implement backup strategies, manage data retention, and ensure proper disaster recovery procedures are in place.</li></ul><p><strong>Data Pipeline Management:</strong></p><ul><li>Work closely with data engineers to oversee data loading, unloading, transformation, and integration processes to ensure seamless data flow into and out of the Snowflake environment.</li></ul><p><strong>Collaboration with Teams:</strong></p><ul><li>Collaborate with developers, analysts, and other stakeholders to troubleshoot issues and provide guidance on Snowflake-related matters. Support development teams in managing version control and code migration in Snowflake.</li></ul><p><strong>Cost Management:</strong></p><ul><li>Monitor resource usage, optimize compute and storage costs, and make recommendations to balance performance and financial efficiency.</li></ul><p><strong>Automation &amp; Monitoring Tools:</strong></p><ul><li>Leverage automation tools and scripting (Python, SQL, or others) for routine tasks like monitoring, backups, and data migration. Use monitoring tools to ensure system health and operational efficiency.</li></ul><p>&nbsp;</p><p><strong>Required</strong></p><p><strong>Snowflake Expertise:</strong></p><ul><li>In-depth knowledge of Snowflake’s architecture, features, and components such as virtual warehouses, data sharing, cloning, time travel, etc.</li></ul><p><strong>Cloud Platform Proficiency:</strong></p><ul><li>Experience with major cloud platforms (AWS, Azure, Google Cloud) and their integration with Snowflake.</li></ul><p><strong>Database Management:</strong></p><ul><li>Strong understanding of database principles, SQL, performance tuning, and optimization techniques.</li></ul><p><strong>Security &amp; Compliance:</strong></p><ul><li>Hands-on experience with Snowflake security features, including role-based access control, encryption, and compliance with industry regulations (e.g., GDPR, HIPAA).</li></ul><p><strong>Scripting &amp; Automation:</strong></p><ul><li>Experience in scripting languages like SQL, Python, or Bash to automate tasks and create monitoring solutions.</li></ul><p><strong>Performance Tuning &amp; Monitoring:</strong></p><ul><li>Expertise in query optimization, resource management, and performance monitoring.</li></ul><p>&nbsp;</p><p><strong>Preferred Qualifications:</strong></p><p><strong>Certifications:</strong></p><ul><li>Snowflake certification (e.g., SnowPro Core) or other cloud-related certifications are a plus.</li></ul><p><strong>Experience with Data Tools:</strong></p><ul><li>Familiarity with data integration and ETL tools (e.g., Matillion, Talend, Informatica) or BI platforms (e.g., Tableau, Power BI) is advantageous.</li></ul><p><strong>Cloud Platforms:</strong></p><ul><li>Experience with cloud data ecosystems like AWS Redshift, Google BigQuery, or Azure Synapse.</li></ul><p><strong>Big Data &amp; Analytics:</strong></p><ul><li>Exposure to big data processing technologies (e.g., Spark, Hadoop) and analytics tools.</li></ul><p><strong>Education &amp; Experience:</strong></p><ul><li>Bachelor's degree in Computer Science, Information Technology, or a related field.</li><li>3+ years of experience as a Snowflake Admin or in a similar role managing large-scale cloud data platforms.</li></ul></div><aside><p>SKILLS</p><ul><li>Optimization Techniques</li><li>Microsoft SQL Server</li><li>Python (Programming Language)</li><li>Snowflake Cloud</li><li>Performance Tuning</li><li>Microsoft Azure</li></ul></aside></div></div><section><h2>&nbsp;</h2></section>