Job Summary:
We're seeking an experienced Snowflake Admin with strong SQL and Python skills to manage and maintain our Snowflake cloud-based data warehousing platform. The ideal candidate will have a deep understanding of Snowflake architecture, SQL, and Python programming.
Key Responsibilities:
1. Snowflake Administration:
- Manage and monitor Snowflake accounts, users, and roles.
- Ensure security and access controls are in place.
2. SQL Development:
- Write complex SQL queries for data analysis and reporting.
- Optimize SQL queries for performance.
3. Python Scripting:
- Develop Python scripts for data loading, transformation, and automation.
- Use Python libraries like Pandas, NumPy, and Snowflake Connector.
4. Data Warehouse Management:
- Design, build, and maintain Snowflake data warehouses.
- Optimize data storage, processing, and querying.
5. Data Integration:
- Load data from various sources into Snowflake using Python and SQL.
- Integrate Snowflake with other tools and systems.
6. Query Optimization:
- Monitor and optimize query performance.
- Ensure efficient use of resources.
7. Data Governance:
- Implement data governance policies and procedures.
- Ensure data quality, security, and compliance.
8. User Support:
- Provide technical support to Snowflake users.
- Troubleshoot issues and resolve problems.
Requirements:
1. Snowflake certification (or willingness to obtain)
2. 2+ years of experience with Snowflake administration
3. Strong SQL skills (query writing, optimization, and performance tuning)
4. Python programming skills (data manipulation, automation, and scripting)
5. Experience with data integration tools and technologies
6. Strong problem-solving and analytical skills
7. Excellent communication and technical support skills
Nice to Have:
1. Experience with other cloud platforms (e.g., AWS, Azure, GCP)
2. Knowledge of data engineering and architecture
3. Familiarity with DevOps practices and tools
4. Experience with data visualization tools (e.g., Tableau, Power BI)
Education:
- Bachelor's degree in Computer Science, Information Technology, or
Any graduate