Intermediate Snowflake Data Platform Engineer

Need local DL and linkedin.

CTH

JD:

Key Responsibilities:

Package and integrate new Snowflake features into a common data platform for use by multiple application development teams. SRE experience a plus. Must know authentication of snowflake. AWS a plus and will be level 3 support. They will do disaster recovery and shakedown exercises.

• Administer code. Not super senior but experienced.
• Integrate Snowflake features into the Snowflake security architecture.
• Validate non-functional requirements, including disaster recovery and backup for Snowflake objects.
• Automate Snowflake environment deployment and administration using SQL, Python or Bash utilities.
• Collaborate with Application Development teams to ensure seamless integration and deployment of Snowflake platform capabilities.
• Utilize CI/CD tools such as GitLab, Bitbucket, and Jenkins to manage the configuration and execution of Snowflake utilities.
• Perform Snowflake and AWS administration tasks using Terraform or Ansible automation tools.
• Provide escalated Snowflake support to DTCC's Cloud Data Operations team.
• Develop Snowflake platform feature documentation, training materials and job aids for our operations staff.
• Support Disaster Recovery and Operational Rotation activities to validate the effectiveness of DTCC's business continuity planning.
• Provide Snowflake implementation and integration advice and consulting to application development teams.
• Report defects and problems to Snowflake and work with DTCC's Snowflake account team to validate and implement suggested fixes.

Qualifications:

• Proven experience with Snowflake data platform administration. A current SnowPro Core certification is strongly desired. More advanced Snowflake platform certifications are ideal.
• Experience with SQL programming and/or relational database administration on mainstream database platforms (Snowflake, Oracle, MS SQL Server, MySQL, PostgreSQL).
• Proficiency in Python and Bash script development on Linux.
• Basic proficiency with Terraform and Ansible.
• Experience with CI/CD toolchains including GitLab, Bitbucket and Jenkins.
• Basic AWS IaaS administration skills; experience with Azure or Google Cloud Platform is acceptable.
• Basic Linux system administration skills
• Familiar with Agile/Scrum project management methodology and associated workflow tools such as JIRA
• Familiar with ITSM processes (Incident, Problem, Change, Service Request fulfillment) and supporting tools such as ServiceNow.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.

Preferred Qualifications:

• Snowflake integration experience with enterprise Identity and Access Management (IAM) technologies such as Entra (Azure Active Directory) or Hashicorp Vault
• Experience integrating Snowflake monitoring features with observability tools such as Splunk, Grafana, or Dynatrace.
• Experience integrating Snowflake with ITSM tools such as ServiceNow or CMDB tools like CloudAware.
• Experience with Linux batch scheduling software such as Autosys or equivalent.
• Familiar with FinOps concepts and Snowflake cost/performance optimization strategies.
• Experience with Business Analytics applications such as Power BI, Looker or Quicksight
• Experience with the usage and administration of Snowpark container services.
• Experience with the usage and administration of Snowpipe stream analytics.