Database Developer

PTR Global; New York (NY); On-site; USD 83,000 - 88,000; Full time

Job summary

PTR Global seeks a Database Developer / Data Platform Engineer in New York to help migrate and build a Snowflake-based data platform while maintaining the existing KDB+ stack. The role requires hands-on data engineering, performance tuning, and close collaboration with the Delta1/IST teams.

You will work in a fast-paced environment, contribute to multi-terabyte inventories and positions data, and drive cloud data platform design decisions with a strong emphasis on reliability and scalable data

Qualifications

• Experience optimizing major RDBMS workloads.
• Proficiency in Python scripting and Unix/Linux environments.
• Strong communication and collaboration skills.

Responsibilities

• Migrate KDB+ data to Snowflake and support the new data platform.
• Perform data management, modeling, and access control reviews.
• Collaborate with business stakeholders to translate requirements.
• Contribute to platform migration, upgrades, and performance tuning.
• Support cloud-based data platforms and enterprise-scale data systems.
• Maintain reliability and agility in a fast-paced environment.

Skills

RDBMS optimization

Python scripting

Unix/Linux

Excellent communication

Tools

Snowflake

KDB+/q

Unix/Linux

Job description

Job Title: Database Developer / Data Platform Engineer
Location: New York, NY 10019 (3 days onsite)
Duration: 12+ Months Contract with Extension
Job id – 178767

• Moving KDB data to Snowflake.
• Data Management, Model, Access Controls, Review how client is moving the data into snowflake.
• Liase with the business on how to do this.
• GDM-Tech (Global Data Mart) is part of TEDRA (Trade Enrichment Data Reporting & Allocations) within Institutional Securities Technology (IST) Division.
• Client is responsible for sourcing, maintaining, distributing, and reporting on the Firm's inventory, position, and reference data.
• Supporting the Delta1 Structured Products business, client’s data sets underpin critical workflows across inventory management, prime brokerage, and firm-wide position reporting.
• As an authoritative source of key data sets, GDM-Tech sits at the forefront of database technology and is heavily involved in data engineering, data distribution, and analytics efforts.
• Client is 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 client’s existing KDB+ technology stack.
• A central objective of the role is to help migrate client’s current KDB+ dependencies onto Snowflake a greenfield effort that offers significant scope for design and architectural input.
• Client’s 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.

Required Skills:

• 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

Desired Skills:

• 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

Other Personal Skills:

• Integrity and ownership, good team player, high degree of motivation to expand technical and business knowledge

About PTR Global:

PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com

At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:

• Pay any fee to be considered for, submitted to, or selected for any opportunity.
• Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process.
• Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup.

Pay Range: $60-64/hr. The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.

If you receive a suspicious message, email, or phone call claiming to be from PTR Global, do not respond or click on any links. Instead, contact us directly at [phone]. To report any concerns, please email us at [e-mail]

Add your LinkedIn Hashtag at end of the job description

Share your resume at [e-mail]