Snowflake Administrator at Kforce Inc.
Boston, MA 02116
About the Job
- Snowflake Environment Management: Administer and manage Snowflake data warehouse environments, including setup, configuration, monitoring, and optimization
- Performance Tuning: Monitor and optimize performance, including query performance, resource utilization, and storage management
- User and Access Management: Manage user access, roles, and permissions to ensure data security and compliance with organizational policies
- Data Integration: Support and manage data integration processes, including data loading, transformation, and extraction
- Backup and Recovery: Implement and oversee backup and recovery strategies to ensure data integrity and availability
- Troubleshooting and Support: Provide technical support and troubleshooting for Snowflake-related issues, including resolving performance bottlenecks and query optimization
- Documentation and Reporting: Maintain detailed documentation of system configurations, procedures, and changes; Generate and deliver regular reports on system performance and usage
- Collaboration: Work closely with data engineers, analysts, and other IT professionals to ensure seamless integration and optimal performance of the Snowflake environment
- Best Practices: Stay up to date with Snowflake best practices and industry trends; Recommend and implement improvements and upgrades to enhance system functionality and performance
- Security: Ensure platform is up to date on System patches; Monitor, apply and test product security updates
Requirements:
- Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field; Relevant certifications are a plus
- 3+ years of hands-on experience in managing and administering Snowflake environments; Experience with other cloud-based data platforms is a plus
- Experience with ETL tools and data integration processes
- Experience in scripting languages such as PowerShell and Python
- Experience working in AWS cloud environments
- Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plus
- Experience working with Power BI and other BI, data visualization, and reporting tools
- Strong Database design and data modelling experience
- Experience with other relational database management systems, cloud data warehouses and big data platforms is a plus
- Experience with data integration solutions and tools, data pipelines, and modern ways of automating data using cloud based and on-premises technologies
- Knowledge of SQL and Snowflake-specific query optimization
- Knowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secure view, etc.
- Strong proficiency in Snowflake architecture, features, and capabilities
- Business requirement gathering and aligning to solutions delivery
- Strong SQL skills
- Excellent problem-solving and analytical skills with a strong attention to detail
- Effective communication skills, both written and verbal, with the ability to convey complex technical information to non-technical stakeholders
- Ability to identify and drive continuous improvements
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking “Apply Today” you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.