Hybrid, New York, NY, No Remote Senior Data Architect designing scalable Snowflake-based investment data platforms with ELT pipelines, data modeling, governance, and performance optimization.
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 & Controls
- Establish and enforce data quality checks, reconciliation controls, and validation frameworks to ensure accuracy and completeness of financial data.
- Implement governance standards including lineage, auditability, and data certification aligned with regulatory and internal control expectations.
- Support operational readiness by enabling monitoring, alerting, and issue resolution across data pipelines.
Performance & Scalability
- Optimize Snowflake performance and cost efficiency for large‑scale financial datasets through clustering, partitioning, and query tuning.
- Contribute to platform architecture decisions, development standards, and best practices to ensure long‑term scalability and maintainability.
Collaboration & Leadership
- Work closely with investment operations, finance, reporting, and analytics stakeholders to ensure platform alignment with business needs.
- Act as a senior technical contributor in a lean, high‑impact environment, influencing design decisions and mentoring junior engineers as needed.
Required Qualifications
- 10–15 years of experience building enterprise‑scale data platforms, preferably within asset management, capital markets, or financial services.
- Deep hands‑on experience with Snowflake, including performance optimization and advanced SQL development.
- Strong experience with modern ELT frameworks such as dbt and orchestration tools like Airflow.
- Advanced proficiency in SQL and Python for data transformation, automation, and control frameworks.
- Proven experience designing complex financial data models supporting holdings, transactions, cash flows, and exposure analytics.
- Solid understanding of IBOR/ABOR concepts, investment operations, and downstream reporting requirements.
- Experience implementing data quality, reconciliation, and governance controls in regulated environments.
Preferred Qualifications
- Experience working with custodian data feeds, market data, and investment accounting platforms.
- Familiarity with regulatory reporting and audit requirements in investment management.
- Exposure to cloud‑native data architectures and cost optimization strategies.
- Strong documentation and stakeholder communication skills.
Behavioral & Leadership Competencies
- Strong analytical problem‑solving; able to resolve complex technical and operational issues.
- Executive‑level communication and stakeholder management.
- Self‑motivated, outcome‑oriented, with a strong transformation and delivery focus.
- Collaborates effectively across matrixed teams; drives client satisfaction and trust.