RZS Recruitment
Database Developer/Architect with Snowflake
RZS Recruitment, New York, New York, us, 10261
About the job Database Developer/Architect with Snowflake
Database Developer/Architect with Snowflake
Location:
New York City, New York, United StatesOffice space available at location listedHybrid Role (3 days in week)
Industry:
Financial Services - Investment BankingJob Category:
Information Technology - Developer
Compensation Base Salary - USD $110,000 to $120,000Full-timeBenefits - FullRelocation Assistance Available - No
Candidate Details
10+ to 15 years experience Seniority Level - Mid-SeniorManagement Experience Required - NoMinimum Education - Bachelor's DegreeWillingness to Travel - Never
Security Clearance Required:
NoVisa 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 spaceFinancial Services experience will be a strong plusAbility to learn quickly and pick up new techniques and/or technologiesExcellent interpersonal skills and professional approachStrong 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
Database Developer/Architect with Snowflake
Location:
New York City, New York, United StatesOffice space available at location listedHybrid Role (3 days in week)
Industry:
Financial Services - Investment BankingJob Category:
Information Technology - Developer
Compensation Base Salary - USD $110,000 to $120,000Full-timeBenefits - FullRelocation Assistance Available - No
Candidate Details
10+ to 15 years experience Seniority Level - Mid-SeniorManagement Experience Required - NoMinimum Education - Bachelor's DegreeWillingness to Travel - Never
Security Clearance Required:
NoVisa 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 spaceFinancial Services experience will be a strong plusAbility to learn quickly and pick up new techniques and/or technologiesExcellent interpersonal skills and professional approachStrong 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