Snowflake Database Developer

Russell Tobin • New York, NY

1d • Hybrid

About The Position

We are responsible for sourcing, maintaining, distributing, and reporting on the Firm's inventory, position, and reference data. Supporting the Delta1 Structured Products business, our data sets underpin critical workflows across inventory management, prime brokerage, and firm-wide position reporting. As an authoritative source of key data sets, Tech sits at the forefront of database technology and is heavily involved in data engineering, data distribution, and analytics efforts. We are looking for an experienced general database developer to contribute to the support and development of a multi-terabyte inventory and position data platform serving the Delta1 Structured Products team globally. The successful candidate will play a key part in building out a new Snowflake-based data platform, while also supporting and maintaining our existing KDB+ technology stack. A central objective of the role is to help migrate our current KDB+ dependencies onto Snowflake a greenfield effort that offers significant scope for design and architectural input. Our team takes a best tool for the job approach, and the ideal candidate will bring strong interest and experience in cloud platforms and RDBMS technologies, including enterprise-scale, highly accessed transactional and time-series data systems. The tasks will include performance optimization, testing, database engineering, platform migration, version upgrades, and development and distribution on cloud platforms. The person joining the team must be able to operate in a fast-paced Agile environment where time to market is a key requirement without compromising on the quality and resiliency of the platform.

Requirements

• Knowledge (intermediate level) of development and performance optimization on major RDBMS technologies
• Scripting knowledge (Python)
• Knowledge of Unix/Linux operating systems
• Version control
• Excellent communication skills

Nice To Haves

• Data modelling concepts
• Knowledge of ETL products
• Experience with Snowflake or other cloud data platforms
• Exposure to KDB+/q (or a strong willingness to learn)
• Understanding of financial data domains inventory, securities lending/borrow, prime brokerage, or position data
• Agile practices
• Integrity & ownership
• Good team player
• High degree of motivation to expand technical and business knowledge

Responsibilities

• Migrating KDB data to Snowflake
• Data Management
• Model
• Access Controls
• Review how data is moved into Snowflake
• Liaise with the business on data migration strategies
• Performance optimization
• Testing
• Database engineering
• Platform migration
• Version upgrades
• Development and distribution on cloud platforms

Benefits

• Comprehensive healthcare coverage (medical, dental, and vision plans)
• Supplemental coverage (accident insurance, critical illness insurance and hospital indemnity)
• 401(k)-retirement savings
• Life & disability insurance
• Employee assistance program
• Legal support
• Pet insurance
• Employee discounts with preferred vendors

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed