Snowflake Cloud Administrator (US Remote)

Ansys

4

(28)

Canonsburg, PA (Remote)

Why you should apply for a job to Ansys:

  • 4/5 in overall job satisfaction
  • 4.4/5 in supportive management
  • 82% say women are treated fairly and equally to men
  • 82% would recommend this company to other women
  • 79% say the CEO supports gender diversity
  • Ratings are based on anonymous reviews by Fairygodboss members.
  • Through our Employee Resource Groups, we reinforce our values of inclusion, belonging, and innovation.
  • Our flexible work arrangements and paid time off programs enable you to manage work and life.
  • We offer competitive salaries accompanied by pay-for-performance annual cash and equity incentives plans.
  • #14292

    Position summary

    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.
      • 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.

    • Strong team player with excellent leadership qualities, capable of effectively mentoring and motivating team members to achieve exceptional results.

    At Ansys, we know that changing the world takes vision, skill, and each other. We fuel new ideas, build relationships, and help each other realize our greatest potential. We are ONE Ansys. We operate on three key components: the commitments to our stakeholders, the behaviors of how we work together, and the actions of how we deliver results. Together as ONE Ansys, we are powering innovation that drives human advancement.

    Our Commitments:

    • Amaze with innovative products and solutions

    • Make our customers incredibly successful

    • Act with integrity

    • Ensure employees thrive and shareholders prosper

    Our Values:

    • Adaptability: Be open, welcome what's next

    • Courage: Be courageous, move forward passionately

    • Generosity: Be generous, share, listen, serve

    • Authenticity: Be you, make us stronger

    Our Actions:

    • We commit to audacious goals

    • We work seamlessly as a team

    • We demonstrate mastery

    • We deliver outstanding results

    INCLUSION IS AT OUR CORE
    We believe diverse thinking leads to better outcomes. We are committed to creating and nurturing a workplace that fuels this by welcoming people, no matter their background, identity, or experience, to a workplace where they are valued and where diversity, inclusion, equity, and belonging thrive.

    WELCOME WHAT'S NEXT IN YOUR CAREER AT ANSYS

    At Ansys, you will find yourself among the sharpest minds and most visionary leaders across the globe. Collectively we strive to change the world with innovative technology and transformational solutions. With a prestigious reputation in working with well-known, world-class companies, standards at Ansys are high - met by those willing to rise to the occasion and meet those challenges head on. Our team is passionate about pushing the limits of world-class simulation technology, empowering our customers to turn their design concepts into successful, innovative products faster and at a lower cost.

    At Ansys, it's about the learning, the discovery, and the collaboration. It's about the "what's next" as much as the "mission accomplished." And it's about the melding of disciplined intellect with strategic direction and results that have, can, and do impact real people in real ways. All this is forged within a working environment built on respect, autonomy, and ethics.

    CREATING A PLACE WE'RE PROUD TO BE
    Ansys is an S&P 500 company and a member of the NASDAQ-100. We are proud to have been recognized for the following more recent awards, although our list goes on: Newsweek's Most Loved Workplace globally and in the U.S., Gold Stevie Award Winner, America's Most Responsible Companies, Fast Company World Changing Ideas, Great Place to Work Certified (Belgium, China, Greece, France, India, Japan, Korea, Spain, Sweden, Taiwan, and U.K.).

    For more information, please visit us at https://www.ansys.com

    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.

    Ansys does not accept unsolicited referrals for vacancies, and any unsolicited referral will become the property of Ansys. Upon hire, no fee will be owed to the agency, person, or entity.

    #LI-RF1

    Why you should apply for a job to Ansys:

  • 4/5 in overall job satisfaction
  • 4.4/5 in supportive management
  • 82% say women are treated fairly and equally to men
  • 82% would recommend this company to other women
  • 79% say the CEO supports gender diversity
  • Ratings are based on anonymous reviews by Fairygodboss members.
  • Through our Employee Resource Groups, we reinforce our values of inclusion, belonging, and innovation.
  • Our flexible work arrangements and paid time off programs enable you to manage work and life.
  • We offer competitive salaries accompanied by pay-for-performance annual cash and equity incentives plans.