Snowflake Administrator

---

Job description

• Only qualified Snowflake Administrator candidates located near the Boston, MA area to be considered due to the position requiring an onsite presence

Qualifications:

Education:

Bachelor's degree in computer science, Information Technology, Data Science, or a related field. Relevant certifications are a plus

Experience:

3+ years of hands-on experience in managing and administering Snowflake environments. Experience with other cloud-based data platforms is a plus

Required Skills:

Strong proficiency in Snowflake architecture, features, and capabilities

Knowledge of SQL and Snowflake-specific query optimization

Experience with ETL tools and data integration processes

3+ 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, masking, secure view, etc.

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

Business requirement gathering and aligning to solutions delivery

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

Analytical Skills: Excellent problem-solving and analytical skills with a strong attention to detail

Communication: Effective communication skills, both written and verbal, with the ability to convey complex technical information to non-technical stakeholders

Teamwork: Ability to work independently and collaboratively in a fast-paced environment

Preferred Skills:

Snowflake certification (e.g., Snow Pro Core or Advanced Certification)

Experience with data visualization tools (e.g., Power BI)

Knowledge of technical areas such as T-SQL, DevOps, and scripting

Responsibilities:

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

• Only those lawfully authorized to work in the designated country associated with the position will be considered.

• Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.

Benefits:

For information and details on employment benefits offered with this position, please visit here . Should you have any questions/concerns, please contact our HR Department via our secure website .

California Pay Equity:

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here .

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department .

Rose International has an official agreement (ID ), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).

<!– job description page –>