3 Pantheon Jobs

Key Roles and Responsibilities :

- Perform Data Warehouse engineering activities on multiple Snowflake warehouses

- Ability to explore new tools in the data space, Performance POCs, Set standards for the wider implementation

- Work with customers to resolve database related issues

- Work Service Now tickets with the ability to troubleshoot resolutions

- Ability to provide consultation on issue analysis related to data integrity & performance of ETL job.

- Experience in working with very large & complex SQL databases that have enabled high availability support

- Provide early testing of new features and services

- Implement and monitor Snowflake best practices

- Provide guidance on Snowflake upgrades, optimization, debugging and capacity planning

- Understanding of security protocols (i.e. Kerberos, SSL, etc)

- Understanding of Agile

- Strong problem solving skills

- Experience with cloud infrastructure administration (Azure,AWS)

- Hands-on experience working with SQL

- Quick learner and adaptive to the change

- Ability to explore new tools in the data space, Performance POCs, Set standards for the wider implementation

Primary skill set :

- User and Role Management : Proficiency in managing users, roles, and permissions within Snowflake to ensure secure and efficient access control

- Performance Tuning and Optimization : Ability to optimize query performance and manage compute resources effectively to ensure efficient data processing

- Data Loading and Unloading : Expertise in loading and unloading data, including understanding best practices for data ingestion and extraction

Nice to Have skill sets :

- Snowflake platform admin

- Soft skill sets : Scripting and Automation : Knowledge of scripting languages (e.g., Python, SQL) to automate administrative tasks and improve efficiency

- Cloud Platform Integration : Familiarity with integrating Snowflake with other cloud platforms like AWS, Azure, or GCP for seamless data operations

- Data Governance and Security : Understanding of data governance principles and security best practices to ensure data integrity and compliance.