Database Developer (Snowflake & KDB+)

Zealogics.com • New York, NY

3d • $45 - $50

About The Position

GDM-Tech (Global Data Mart) is part of TEDRA (Trade Enrichment Data Reporting & Allocations) within the Institutional Securities Technology (IST) Division. We are responsible for sourcing, maintaining, distributing, and reporting on the Firm's inventory, position, and reference data. Our data sets underpin critical workflows across inventory management, prime brokerage, and firm-wide position reporting. 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

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

Responsibilities

• Moving KDB data to Snowflake.
• Data Management, Model, Access Controls.
• Review how we are moving the data into snowflake.
• Liaise with the business on how to do this.
• Performance optimization, testing, database engineering, platform migration, version upgrades, and development and distribution on cloud platforms.

What This Job Offers

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