SQL/Data Engineer with Investment Management experience

Overview

Hybrid
Depends on Experience
Full Time

Skills

RDBMS
SQL
Data Engineer
investment management
portfolio
benchmarks
holdings
security
trades
ETL
ETL processes
SQL Server
Python
data transformation
data warehouse
software development
transformation

Job Details

Position: SQL/Data Engineer Consultant
Location: On-site Princeton NJ 3 days a week

The most important thing for the data role is that the person really needs to be hands-on and proficient with:
  • Writing (advanced) SQL
  • Doing Schema design
  • Solid RDBMS skills
  • Experience with and understanding of Investment Management domain processes and data (Portfolio, Benchmarks, Holdings, Security, Trades etc.)

Description of Role:

  • As a Data Engineer, you will be actively participating in the Investments Technology Services (ITS) team that is currently working on multiple software development projects.
  • The role requires hands-on experience with writing advanced SQL, including query structuring, and ETL/ELT process expertise.
  • You will be engineering enterprise data transformation and delivery to a variety of vendor cloud based platforms and a set of in-house developed databases.
  • Experience with and understanding of Investment Management domain processes and data (Portfolio, Benchmarks, Holdings, Security, Trades etc.).
Responsibilities:
  • As part of the Team, work on integrating our applications with our new cloud-based (AWS) enterprise data warehouse on Snowflake, using SQL and Python.
  • Develop ETL processes to capture and load various third-party security, analytics and benchmark data and internal data sources from our Snowflake based data warehouse.
  • Design and implement appropriate schemas, logical and physical models, and service interfaces for a new Portfolio and Benchmark Characteristics database in SQL Server.
  • Help in analyzing and migrating our legacy Regulatory Reporting applications from our current data warehouse to the new Snowflake data warehouse.
  • Work closely with peers to implement industry best practices for coding, testing and documentation.
  • Build common data processing components and encourage team wide adoption that can be leveraged to reduce code redundancy and increase reusability.
  • Prepare key documentation to support the technical design.
We look forward to reviewing your profile.
 
Thanks,
Talent Team @ SIALTP
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.