Data Engineer

You will develop the firm's data messaging platforms and data stores, handling transactional, reference data, and aggregated risk measures for real-time and archive processing, feeding into ODS, archives, and DataMart.

Responsibilities

• Translate business requirements into queries against relational tables and generate reports.
• Design and build scalable and performant databases.
• Develop database and ETL components, including stored procedures, queries, performance tuning, and archiving using Python, SQL, and ETL tools.
• Build efficient automation scripts using Python and Unix/K-Shell.

Required Skills

• 5+ years of experience in data engineering.
• Strong relational database skills with DB2/Sybase/SQL Server or Postgres/Greenplum.
• Proficiency in Python and SQL.
• Experience with ETL Tools.
• Strong knowledge of relational database performance tuning (indices, statistics, de-normalization).
• Experience with Agile development processes.
• Familiarity with the lifecycle of a trade and investment banking data flows.
• Experience with Unix/K-Shell.