CBTS is in search of a a skilled Snowflake Architect 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.
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.
***NO 3rd PARTY REQUEST PLEASE***
Duties
Snowflake Environment Setup & Maintenance:
- Set up and configure Snowflake accounts, virtual warehouses, databases, and other components. Regularly monitor the environment for performance, utilization, and cost management.
Security & Access Control:
- 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.
Performance Monitoring & Optimization:
- Continuously monitor performance metrics, optimize queries, manage workload balancing, and tune system configurations to improve performance and reduce costs.
Backup & Recovery:
- Implement backup strategies, manage data retention, and ensure proper disaster recovery procedures are in place.
Data Pipeline Management:
- 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.
Collaboration with Teams:
- 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.
Cost Management:
- Monitor resource usage, optimize compute and storage costs, and make recommendations to balance performance and financial efficiency.
Automation & Monitoring Tools:
- 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.
Required
Snowflake Expertise:
- In-depth knowledge of Snowflake’s architecture, features, and components such as virtual warehouses, data sharing, cloning, time travel, etc.
Cloud Platform Proficiency:
- Experience with major cloud platforms (AWS, Azure, Google Cloud) and their integration with Snowflake.
Database Management:
- Strong understanding of database principles, SQL, performance tuning, and optimization techniques.
Security & Compliance:
- Hands-on experience with Snowflake security features, including role-based access control, encryption, and compliance with industry regulations (e.g., GDPR, HIPAA).
Scripting & Automation:
- Experience in scripting languages like SQL, Python, or Bash to automate tasks and create monitoring solutions.
Performance Tuning & Monitoring:
- Expertise in query optimization, resource management, and performance monitoring.
Preferred Qualifications:
Certifications:
- Snowflake certification (e.g., SnowPro Core) or other cloud-related certifications are a plus.
Experience with Data Tools:
- Familiarity with data integration and ETL tools (e.g., Matillion, Talend, Informatica) or BI platforms (e.g., Tableau, Power BI) is advantageous.
Cloud Platforms:
- Experience with cloud data ecosystems like AWS Redshift, Google BigQuery, or Azure Synapse.
Big Data & Analytics:
- Exposure to big data processing technologies (e.g., Spark, Hadoop) and analytics tools.
Education & Experience:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 3+ years of experience as a Snowflake Admin or in a similar role managing large-scale cloud data platforms.
