Job Description
Role: Senior Data Engineer - Investments Data Platform (Snowflake) Location: New York, NY (Hybrid). No remote Note: Expertise on data engineering with focus on DB and ETL/ELT. Data modelling, data governance. Data quality/reconciliation. Who are we looking for? 20+ years of experience building enterprise-scale data platforms, preferably within asset management, capital markets, or financial services , who will play a critical role in shaping the architecture, development standards, and long-term scalability of this strategic investments data platform. Key Responsibilities Data Platform & Pipeline Engineering Design, build, and maintain robust, scalable ELT pipelines on Snowflake to ingest data from IBOR/ABOR systems, custodians, market data providers, and internal platforms. Implement end-to-end ingestion, standardization, and transformation logic using Airflow, dbt, Python, and Snowflake stored procedures. Manage schema evolution, metadata, and versioning to support changing upstream data structures without disrupting downstream consumers. Data Modeling & Analytics Enablement Design and implement investment-focused data models to support holdings, transactions, cash flows, exposure analytics, and performance reporting. Build analytics-ready, well-documented data structures optimized for portfolio management, finance, risk, and regulatory use cases. Partner with reporting, analytics, and investment operations teams to translate business reporting requirements into scalable technical designs. Data Quality, Governance & Contr