Snowflake Cloud Administrator

2 weeks ago

Chicago, United States Ansys Full time

**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**:
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 mínimal 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.
- 2 years in a data architect role with Snowflake Architect Certification - or 3 years in a data architect role without architect certification
- SnowPro certification required.
- Experience with distributed systems and big data technologies.
- Familiarity with Agile development methodologies.
- Excellent communication skills and the ability to work in a collaborative team environment.

**Preferred Qualifications and Skills**
- Strong understanding of data modeling, data warehousing, and data integration principles, with the ability to architect scalable and efficient data analytics solutions.
- Demonstrated expertise in leveraging cloud technologies to enhance data analytics.
- Data-build-tool (dbt) experience automating platform code in a versioned CI/CD process.
- Possess a broad set of working skills and knowledge across hardware, software systems and solutions development across more than one technical domain.
- Exceptional written and verbal communication skills, capable of articulating complex technical ideas and analytical findings in a concise and compelling manner.
-

  • Snowflake administrator

    4 weeks ago

    Chicago, United States First Soft Solutions Full time

    Job DescriptionJob DescriptionWe are actively hiring for #Snowflake AdminW2 positionLocation: Chicago, IL for a month later in New JerseyExperienced Snowflake Cloud Data Platform Administrator, who will plan, design, develop and implement Snowflake cloud data platform that follows industry best practices.Snowflake administrator will be integral part of team...

  • Snowflake Developer

    2 weeks ago

    Chicago, United States Noblesoft Technologies Full time

    Job DescriptionJob DescriptionRole: Sr Snowflake Developer(Need 10+ years of Canddidate)Location: Chicago, IL(onsite) Rate: $70/hr on C2CJD for Onsite Snowflake Developers (Snowflake, Database SQL, Python Scripting): 10+ years of strong Data warehouse experience Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries 3+ years of...

  • Snowflake Developer

    2 weeks ago

    Chicago, United States MethodHub Full time

    Job Title: Snowflake Developer with strong Python Scripting Pay Rate: $Open/hr on C2C Location: Chicago, IL (Onsite Day 1)Client: DirectDuration: 12 MonthsRequired Skills:Onsite Snowflake Developers (Snowflake, Database SQL, Python Scripting)• 10+ years of strong Data warehouse experience• Strong database (Oracle, MS SQL) skills in writing and optimizing...

  • Snowflake Developer

    2 weeks ago

    Chicago, United States MethodHub Full time

    Job Title: Snowflake Developer with strong Python Scripting Pay Rate: $Open/hr on C2C Location: Chicago, IL (Onsite Day 1)Client: DirectDuration: 12 MonthsRequired Skills:Onsite Snowflake Developers (Snowflake, Database SQL, Python Scripting)• 10+ years of strong Data warehouse experience• Strong database (Oracle, MS SQL) skills in writing and optimizing...

  • Snowflake Developer

    4 weeks ago

    Chicago, United States Ccube Full time

    **Snowflake Developer** **Chicago, IL (Onsite 3 Days a week)** **Full Time** **7+ Years experience** We are looking for a Snowflake Data Developer with experience in integration with Snowflake, knowledge of SQL, Data warehousing, data modeling, cloud based technologies and performance tuning. **Snowflake hands-on experience.** **Must have Strong SQL,...

  • Manager, Sales Engineering

    5 days ago

    Chicago, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. We’re at the forefront of the data revolution, committed to building the world’s greatest data and applications platform. Our ‘get it done’ culture allows everyone at Snowflake to have an equal opportunity to innovate on new ideas, create work with a lasting impact, and excel in a culture of...

  • Snowflake Architect

    4 days ago

    Chicago, United States Diligent Tec, Inc Full time

    Technical Skills (Required)· 3+ years Snowflake Architect level experience ( Production Grade ): ie previous titles like Data Analytics Architect or Principle Engineer· 5+ AWS Cloud Experience ( Production Grade)· 3+ Implementations in snowflake and understand the advanced capabilities like ML Model deployment etc Snowflake Optimization experience ( Auto...

  • Snowflake Architect

    5 days ago

    Chicago, United States Diligent Tec, Inc Full time

    Technical Skills (Required)· 3+ years Snowflake Architect level experience ( Production Grade ): ie previous titles like Data Analytics Architect or Principle Engineer· 5+ AWS Cloud Experience ( Production Grade)· 3+ Implementations in snowflake and understand the advanced capabilities like ML Model deployment etc Snowflake Optimization experience ( Auto...

  • Snowflake Developer

    4 weeks ago

    Chicago, United States Ccube Full time

    Job DescriptionJob DescriptionSnowflake DeveloperChicago, IL (Onsite 3 Days a week)Full Time***7+ Years experience***We are looking for a Snowflake Data Developer with experience in integration with Snowflake, knowledge of SQL, Data warehousing, data modeling, cloud based technologies and performance tuning.Snowflake hands-on experience.Must have...

  • Senior Software Engineer

    4 weeks ago

    Chicago, United States Capgemini Full time

    Title - Senior Software Engineer - Snowflake Location - Chicago IL (Hybrid) Duration Fulltime Key Responsibilities Designing and implementing data warehouse solutions using Snowflake architecture Developing and optimizing data pipelines and ETL processes within Snowflake. Utilizing Snowflake features such as Snowpipe, SnowSQL, and...

  • Support Account Manager

    7 days ago

    Chicago, United States Snowflake Full time

    Build the future of data. Join the Snowflake team. Snowflake's values are key to our approach and success in delivering world-class Support. Putting customers first, acting with integrity, owning initiative and accountability, and getting it done are Snowflake core values and are reflected in everything we do. Snowflake's Support team is expanding! We are...

  • Solutions Architect

    1 month ago

    Chicago, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. Snowflake Professional Services is the implementation and strategy experts for the Snowflake platform. We engage with customers at all phases of the customer journey to optimize, accelerate, and achieve business outcomes. Our teams of Solutions Architects demonstrate technical leadership everyday by writing...

  • Senior Sales Engineer

    5 days ago

    Chicago, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. We are  looking for a Sales Engineer who is accustomed to solving customer’s most complex problems and closing large deals. In this role you will work directly with the sales team and channel partners to understand the needs of our customers, strategize on how to navigate winning sales cycles, provide...

  • Snowflake Consultant

    4 days ago

    Chicago, United States Diverse Lynx Full time

    Job Profile : Snowflake Consultant Job Location : Chicago, IL ( Onsite hybrid mode )Type- Contract (w2/ C2C)Duration- Long term contract Preferred 7+ years of experience•Snowflake, Python, Apache Airflow,•Cloud Experience (AWS)•CI/CD using CircleCI•Real-time data replication/streaming tools (Kafka) Diverse Lynx LLC is an Equal Employment Opportunity...

  • Snowflake Developer with Python Scripting

    2 weeks ago

    Chicago, United States KASTECH Software Solutions Group Full time

    Job DescriptionJob DescriptionLocation: Chicago, ILRemote option : NoJD for Onsite Snowflake Developers (Snowflake, Database SQL, Python Scripting): 10+ years of strong Data warehouse experience Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries 3+ years of experience in designing and developing cloud computing solutions using...

  • Snowflake Consultant

    1 month ago

    Chicago, United States Diverse Lynx Full time

    Job Profile : Snowflake Consultant Job Location : Chicago, IL ( Onsite hybrid mode ) Type- Contract (w2/ C2C) Duration- Long term contract Preferred 7+ years of experience •Snowflake, Python, Apache Airflow, •Cloud Experience (AWS) •CI/CD using CircleCI •Real-time data replication/streaming tools (Kafka) Diverse Lynx LLC is an Equal Employment...

  • Snowflake Admin

    2 weeks ago

    Chicago, United States HCL USAAvance Consulting Full time

    Job Title: Snowflake Admin Job ID: 1404456BR Position Type: TP/CTH Location: Chicago, IL Mandatory Skillset: Snowflake Administration, Snowflake Performance Twining, SQL Queries, ETL/Datastage, Job Responsibilities: Identify the various aspects of compute and storage management Illustrate administrative tasks within the detailed architecture of Snowflake ...

  • Partner Sales Manager SLED

    3 weeks ago

    Chicago, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. Our SI partners play a key role in bringing our customers' data-backed ambitions to life by implementing and harnessing the power of the Snowflake Data Cloud for cutting edge workloads and use cases. Through our partnerships, we enable companies to empower their employees with the data they need when and how...

  • Support Account Manager

    3 days ago

    Chicago, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team.Snowflake Support is committed to providing high-quality resolutions to help deliver data-driven business insights and results. We are a team of subject matter experts collectively working toward our customers' success. We form partnerships with customers by listening, learning, and building connections....

  • Support Account Manager

    22 hours ago

    Chicago, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. Snowflake Support is committed to providing high-quality resolutions to help deliver data-driven business insights and results. We are a team of subject matter experts collectively working toward our customers' success. We form partnerships with customers by listening, learning, and building connections. ...