Database Engineer (SNOWFLAKE)

Tricascade Tech; Dallas (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

DTCC Database Engineer (Snowflake) is sought to package and integrate Snowflake features into a shared data platform used by multiple dev teams. You will automate deployments with Python/Bash, support security and DR, and collaborate with development teams to ensure seamless Snowflake integration.

The role requires 6+ years of experience, a Bachelor's degree or equivalent, Snowflake administration, SQL, and cloud/DevOps tooling such as Terraform/Ansible, AWS, Linux, and CI/CD platforms.

Qualifications

• Minimum of 6+ years of related experience.
• Bachelor's degree preferred or equivalent experience.
• Snowflake data platform administration with SnowPro Core certification desirable.
• Experience with SQL programming and relational databases (Snowflake/Oracle/MS SQL Server/MySQL/PostgreSQL).
• Proficiency in Python and Bash on Linux.
• Basic Terraform and Ansible experience.
• Experience with CI/CD toolchains including GitLab, Bitbucket and Jenkins.
• Basic AWS IaaS administration skills; Azure or GCP acceptable.

Responsibilities

• Package and integrate new Snowflake features into a common data platform for use by multiple application development teams.
• 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 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 business continuity planning.
• Provide Snowflake implementation and integration advice and consulting to application development teams.
• Report defects and problems to Snowflake and work with Snowflake account team to validate and implement suggested fixes.

Skills

Snowflake administration

Python scripting

SQL programming

CI/CD tooling

GitLab

Bitbucket

Jenkins

Terraform

Ansible

Linux

Cloud familiarity

Education

Bachelor's degree or equivalent experience

Tools

Snowflake

Python

Terraform

Ansible

GitLab

Jenkins

Bitbucket

Job description

DTCC - Database Engineer (SNOWFLAKE) - more of a SNOWFLAKE ENGINEER

Your Primary Responsibilities:

• Package and integrate new Snowflake features into a common data platform for use by multiple application development teams.
• 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 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 business continuity planning.
• Provide Snowflake implementation and integration advice and consulting to application development teams.
• Report defects and problems to Snowflake and work with Snowflake account team to validate and implement suggested fixes.

Qualifications:

• Minimum of 6+ years of related experience
• Bachelor's degree preferred or equivalent experience
• 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.
• 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.

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.
• Experience with the usage and administration of Snowflake Cortex AI services.