29 Sep
Data Architect - Prestigious Hedge Fund
New York, New york city , 10001 New york city USA

Vacancy expired!

Prestigious hedge fund in Midtown Manhattan seeks a Data Architect / Engineer to manage their data infrastructure. The role is partial hybrid, working on site 3-4 days per week.This individual will manage the receipt of data, analyze data for accuracy, create reports and work collaboratively with others to investigate and resolve issues. They are looking for someone to be a key part of the Data Analysis team which plays a critical role in achieving overall company goals.This role goes beyond writing stored procedures and using or designing database tables. For example, candidates for this role should have been involved in designing a massive database infrastructure. As well they should have re-engineered or migrated from one database server to another server that has scale. This individual should understand the engineering and security aspects of how databases work, i.e., how the database interacts with the underlying storage.

Responsibilities:
  • Manage large volumes of data and assist in retrieving and appraising new data
  • Work extensively with SQL in querying data
  • Process and analyze data to ensure accuracy and completeness via SQL
  • Research inquiries, validate data patterns and solve complex business problems using SQL
  • Monitor and implement data integrity across staging and production environments
  • Strong working knowledge of SQL, writing SQL queries and proficiency in MS Excel

Requirements:
  • Bachelor's degree in CS (Masters strongly preferred)
  • Strong knowledge of SQL (in either MS-SQL, PostGRESQL). Should have strong experience designing table layouts, triggers, optimizing tables for efficient queries, implementing stored procedures.
  • Strong experience in Linux/UNIX
  • Strong knowledge of Python, Shell, Perl. Knowledge in Java will be valuable.
  • Experience with financial data (price feeds, broker feeds, risk model feeds, etc.)
  • Experience implementing Data Warehouse involving securities data
  • 5 years or more experience in above technologies in a financial environment

Vacancy expired!


Related jobs

Report job