Snowflake Database Developer
Location: New York, NY (Hybrid 3 Days a Week Onsite) | Duration: 12 Months Contract to Hire | Payrate: $58 - 63 per hour
About the role
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.
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. 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.
Responsibilities
- Migrate KDB data to Snowflake
- Design and implement data management, modeling, and access controls in Snowflake
- Review and optimize data migration processes into Snowflake
- Liaise with the business to align data solutions with requirements
- Support and develop a multi-terabyte inventory and position data platform serving the Delta1 Structured Products team globally
- Performance optimization, testing, and database engineering
- Platform migration, version upgrades, and cloud-based development and distribution
Requirements
- Intermediate-level knowledge of development and performance optimization on major RDBMS technologies
- Scripting knowledge (Python)
- Knowledge of Unix/Linux operating systems and version control
- Excellent communication skills
Qualifications
- Data modeling 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)
- Experience with Agile practices
Skills
- Integrity and ownership
- Strong team player
- High degree of motivation to expand technical and business knowledge
Benefits
- Comprehensive healthcare coverage (medical, dental, and vision plans)
- Supplemental coverage (accident insurance, critical illness insurance, and hospital indemnity)
- 401(k)-retirement savings
- Life and disability insurance
- Employee assistance program and legal support
- Auto, home, and pet insurance
- Employee discounts with preferred vendors