Database Developer/Architect with Snowflake

RZS Recruitment; New York (NY); Hybrid; USD 110,000 - 120,000; Full time

Job summary

A recruitment agency is seeking a Database Developer/Architect with expertise in Snowflake for a hybrid role in New York City. Candidates should have 10-15 years of experience, a Bachelor's degree, and proficiency in data modeling, cloud computing solutions, and SQL. This position offers a competitive salary ranging from $110,000 to $120,000 per year and includes full benefits.

Qualifications

• 10+ to 15 years of experience in data modeling and cloud computing.
• Demonstrated expertise in Snowflake data modelling and ELT.
• Proficiency in designing, implementing and testing cloud computing solutions.

Responsibilities

• Implement complex stored procedures and best practices.
• Manage DB related activities such as DB modeling, design, development, maintenance and support.
• Create, monitor and optimize ETL/ELT processes.

Skills

Snowflake

ETL

RDBMS

complex SQL

PL/SQL

Unix Shell Scripting

performance tuning

troubleshoot

Education

Bachelor's Degree in Data Science, Computer Science, Information Technology, Engineering, or Mathematics

Tools

Talend

Informatica

DB2

Sybase

SQL Server

MemSQL

Job description

Database Developer/Architect with Snowflake

About the job Database Developer/Architect with Snowflake

Database Developer/Architect with Snowflake Location: New York City, New York, United States
Office space available at location listed
Hybrid Role (3 days in week) Industry: Financial Services - Investment Banking
Job Category: Information Technology - Developer

Compensation
Base Salary - USD $110,000 to $120,000
Full-time
Benefits - Full
Relocation Assistance Available - No

Candidate Details
10+ to 15 years experience
Seniority Level - Mid-Senior
Management Experience Required - No
Minimum Education - Bachelor's Degree
Willingness to Travel - Never
Security Clearance Required: No
Visa Candidate Considered: No

Minimum Qualifications

Demonstrate expertise in Snowflake data modelling and ELT using Snowflake SQL, implementing complex stored procedures and best practices with data warehouse and ETL concepts designing, implementing and testing cloud computing solutions using Snowflake technology

Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features Experience with data security and data access controls and design creating, monitoring and optimization of

ETL/ELT processes (Talend, Informatica) migrating solutions from on-premises to public cloud platform Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot Strong development experience in Snowflake.

Working experience on Data Warehousing and Business Intelligence projects and having very good understanding on Data Modeling and Methodologies (Enterprise Transactional Data Model (OLTP) and Dimensional modeling. Well versed with principles, techniques and best practices of data modeling).

Advanced proficiency with SQL for generation and extraction of data for use in analytics and reporting Experience in closely working with application teams and managing all the DB related activities such as DB modeling, design, development, maintenance and support

Strong Skills in Relational Databases including database design, writing complex queries and stored procedures, performance tuning

Experience in integration of various data sources like DB2, Sybase, SQL Server, MemSQL, Snowflake. Minimum of a Bachelors degree from an accredited higher learning institution in data science, computer science, information technology, engineering, or mathematics

Preferred Qualifications/ Skills

Knowledge about DevOps implementation in Data space
Financial Services experience will be a strong plus
Ability to learn quickly and pick up new techniques and/or technologies
Excellent interpersonal skills and professional approach
Strong analytical and problem-solving skills

Skills and Certifications [note: bold skills and certification are required]
Snowflake
ETL
RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot