Job Summary :

Client is looking for a senior snowflake developer for our NYC and London based financial services client operating in Public/Private Loans, CLOs, and Long/Short Credit.

You will play a pivotal role in accomplishing the successful delivery of our strategic initiatives. You will be responsible for developing solutions using technologies like Snowflake, Coalesce & Fivetran.

Requirements :

- IT experience of 8+ years with a minimum of 3+ years of experience as a Snowflake Developer.

- Design, develop, and optimize Snowflake objects such as databases, schemas, tables, views, and store procedures.

- Expertise in Snowflake utilities such as Snow SQL, Snow Pipe, Stages, Tables, Zero Copy Clone, Streams and Tasks, Time travel, data sharing, data governance, and row access policy.

- Experience in migrating data from Azure Cloud to Snowflake, ensuring data integrity, performance optimization, and minimal disruption to business operations.

- Experience in Snow pipe for continuous loading and unloading data into Snowflake tables.

- Experience in using the COPY, PUT, LIST, GET, and REMOVE commands.

- Experience in Azure integration and data loading (Batch and Bulk loading).

- Experience in creating the System Roles & Custom Roles and Role Hierarchy in Snowflake.

- Expertise in masking policy and network policy in Snowflake.

- Responsible for designing and maintaining ETL tools (Coalesce & Fivetran) that include extracting the data from the MS-SQL Server database and transforming the data as per Business requirements.

- Extensive experience in writing complex SQL Queries, Stored Procedures, Views, Functions, Triggers, Indexes, and Exception Handling using MS-SQL Server (TSQL).

- Effective communication skills and interpersonal skills.

- Ability to influence and collaborate effectively with cross-functional teams.

- Exceptional problem-solving abilities.

- Experience in working in an agile development environment.

- Experience working in a fast-paced, dynamic environment.

- Good to have some prior experience or high-level understanding of hedge funds, private debt, and private equity.

What's on offer :