What are the responsibilities and job description for the Senior Snowflake Administrator position at Pure Solutions, LLC?
Position: Snowflake Administrator
Location: Boston, MA (Hybrid)
Local candidates only
Last round: Face-to-Face
Required Skills:
- 10 years of hands-on experience in managing and administering Snowflake environments
- Strong proficiency in Snowflake architecture, features, and capabilities
- Knowledge of SQL and Snowflake-specific query optimization
- Experience with ETL tools and data integration processes
- 7 years of hands-on experience as a Snowflake Administrator
- Ability to identify and drive continuous improvements
- Strong problem solving and analytical skills
- Strong SQL skills
- Knowledge of Snowflake security features including access control, authentication, authorization, encryption, and masking, secure view, etc.
- Experience in scripting languages such as PowerShell and Python
- Experience working in AWS cloud environments
- Experience working with Power BI and other BI, data visualization, and reporting tools
- Strong Database design and data modelling experience
- Business requirement gathering and aligning to solutions delivery
- Experience with data integration solutions and tools, data pipelines, and modern ways of automating data using cloud based and on-premises technologies
Preferred Skills:
Experience with other cloud-based data platforms is a plus
Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plus
Experience with other relational database management systems, cloud data warehouses and big data platforms is a plus
Snowflake certification (e.g., SnowPro Core or Advanced Certification)
Experience with data visualization tools (e.g., Power BI)
Knowledge of technical areas such as T-SQL, DevOps, and scripting
