Snowflake Cloud Administrator (US Remote)

at ANSYS in Chicago, Illinois, United States

Job Description

Requisition #:14292
Our Mission: Powering Innovation That Drives Human Advancement

When visionary companies need to know how their world-changing ideas will perform, they close the gap between design and reality with Ansys simulation. For more than 50 years, Ansys software has enabled innovators across industries to push boundaries by using the predictive power of simulation. From sustainable transportation to advanced semiconductors, from satellite systems to life-saving medical devices, the next great leaps in human advancement will be powered by Ansys.

Innovate With Ansys, Power Your Career.

Summary / Role Purpose:
As a Snowflake Cloud Administrator, you will be responsible for planning, designing, implementing, and maintaining a highly scalable, performant, and secure data architectures on and around the Snowflake cloud data platform. You will be working closely with enterprise architecture, data engineering and analytics teams to design, implement and monitor complex data architectures on the Snowflake platform and have a thorough understanding of Snowflake's performance optimization techniques. Your role will include ensuring the stability, security, and efficiency of Snowflake environments and that the data warehouse is properly integrated with other systems and applications within the organization's technology stack.

This includes working with other architects, developers, and stakeholders to ensure that the data warehouse supports the organization's overall digital transformation goals and data mesh strategy. Experience with Data Vault 2.0 preferred as well as demonstrable success managing large scale transactional and operational Data Marts/ Lakes.

You will also be responsible for creating and maintaining the technical documentation, ensuring compliance with data governance and security policies, and providing technical guidance and configuration to the team. This role requires a deep understanding of Snowflake's capabilities, as well as expertise in data modeling, ETL, specifically Fivetran HVR (High-Volume Replicator) and SQL.

This position is remote, although it requires traveling to corporate HQ based on business needs.

Key Duties and Responsibilities:
Expertise in Snowflake platform: You should have a deep understanding of the Snowflake platform and its capabilities. You should be able to design and implement complex data architectures on Snowflake and have a thorough understanding of Snowflake's performance optimization techniques.
ETL/ELT and data integration: You should be familiar with ETL/ELT, specifically Fivetran HVR (High-Volume Replicator) and data integration tools and techniques. You should be able to design and implement data pipelines that extract data from various sources and load it into Snowflake with minimal storage hops.
Performance Optimization: You should be able to implement strategies to optimize the performance of Snowflake databases, including query tuning, indexing, and data partitioning.
Security Management: You should be able to implement and maintain security best practices within the Snowflake environment, including user access control, data encryption, masking, and compliance with regulatory requirements.
Capacity Planning: You should be able to monitor resource utilization and plan for capacity expansion to accommodate future growth and workload demands.
Cost Management: You should be able to identify opportunities for cost optimization within the Snowflake environment, such as optimizing resource utilization, implementing auto-scaling policies, and leveraging cost-effective storage options.
Cloud expertise: You should have experience working with cloud-based data platforms such as AWS, Azure, or GCP. You should be familiar with cloud security best practices and have experience with cloud infrastructure automation tools.
Data governance and security: You should be familiar with data governance and security policies and be able to design solutions to ensure compliance using Snowflake capabilities.
Collaboration and communication: You should have excellent communication skills and the ability to work collaboratively with data engineering and analytics teams.
Strong advocacy of the Snowflake platform, its capabilities, and technical know-how.

Minimum Education/Certification Requirements and Experience
Bachelor's degree or equivalent experience in Information Technology, Computer Science, Engineering, or related field.
Experience Requirements- 7+ years' experience:
5 years of experience in Snowflake database management and administration.
2years in adata architect rolewith Snowflake Architect Certification - or... For full info follow application link.

ANSYS is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other protected characteristics.