Snowflake Developer

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.

Hybrid - Onsite 1 day a week

Activities shall include:

• Participate in and support Azure / Snow Flake infrastructure configuration and setup tasks including but not limited to Data Factory, Tidal, network connectivity, database connectivity, etc.
• Perform Extract and Load activities leveraging generic pipeline infrastructure previously developed and extend the functionality to support related data sources.
• Develop transformation code modules utilizing data mapping provided by the bank to integrate staging data into the bank's Core Data Model and extend the data model when required.
• Input to Data Model modifications and new design elements as they relate to transformation targets
• 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.
• 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: CI/CD, Azure Cloud Dev Ops, Azure Data Bricks, Data Factory, GIT, Snowflake / SNOW SQL, Python, TIDAL, Data Integration tools (such as Informatica, SSIS) Microsoft SQL Server, Oracle, and process automation. Database model and design constructs for Star and Snow Flake schemas.

Skills:

• Preferred candidates will have 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.