Snowflake Developer - Remote

SoHo Dragon represents an investment bank with offices in Jersey City, NJ that needs to hire a Snowflake Developer who will work with both onshore and off shore teams for the integration of the bank's data with existing Snowflake environment, leveraging all existing process and procedures already in place.

This role will be remote.

Activities shall include:

Heavy SQL Development - must demonstrate strong hands on experience of advanced SQL coding concepts including but not limited to Joins, SQL Functions, Efficiency techniques. Be able to describe the ways you have put these techniques to work to achieve objectives

Understand the Azure / Snowflake environment (its pro's, con's), including Databricks, SnowSQL, SnowPipe, Time travel.

Develop transformation code modules utilizing data mapping provided by the bank to integrate staging data into Core Data Model and extend the data model when required. Heavy use of SnowSQL for this activity.

Develop enhancements to and participate in testing, automation and operational activities related to the components developed within the scope that does not require any additional special skills.

Python Development

Tidal Schedule development and Configuration

Participate in daily scrums, project related meetings, backlog grooming, sprint planning and retrospective sessions. Must understand the Agile development process and be committed to delivering assignments as planned and agreed.

Key knowledge and technology skills required: Snowflake / SNOW SQL, Python, TIDAL, CI/CD, Azure Cloud Dev Ops, Azure Data Bricks, Data Factory, GIT, Microsoft SQL Server, Oracle, and process automation. Database model and design constructs for Star and Snow Flake schemas.

Skills

Preferred candidates will have additional background / experience working with data in Financial Services Industry, specifically Banking and some product related knowledge including but not limited to Securities and Banking domains (OTC Derivatives, Cash, Finance, Commercial Paper, Collateral, Loans, Commitment).

Knowledge and understanding of Risk and Regulatory reporting also a plus.