Associate Technical Architect - Data - USA

Role overview

Lead the design and delivery of cloud data platforms for financial services, combining hands-on engineering with technical architecture and product delivery. The work focuses on alternative investment data, from modernizing legacy systems and building reliable pipelines to coordinating releases and aligning engineering work with business priorities.

Responsibilities

- Design and maintain Snowflake-based data platforms and pipelines for structured, semi-structured, and unstructured data. - Lead migrations from legacy data stores, defining data mappings, transformation rules, and consistent target architecture. - Build checks for reconciliation, schema validation, deduplication, and financial data integrity to support analytics and regulatory reporting. - Set technical roadmaps, prioritize backlogs, and balance new features with platform reliability and technical debt. - Guide delivery from requirements and technical design through development, testing, cutover, and launch. - Translate strategic goals into epics, user stories, and acceptance criteria; coordinate with business, analytics, and engineering stakeholders.

Requirements

- At least eight years of experience in data engineering, technical architecture, or technical product management. - Direct experience with sensitive financial data in alternative investments, such as private equity, hedge funds, private credit, or real estate. - Strong production Python and advanced SQL skills, including large-scale data processing, query optimization, window functions, and complex transformations. - Production experience with Snowflake and a cloud ecosystem such as AWS, Azure, or Google Cloud. - Experience owning end-to-end delivery, release management, operational cutovers, and Jira or Confluence workflows. - A bachelor’s or master’s degree in a quantitative, computing, data, or finance-related discipline.

Nice to have

- Experience with orchestration tools such as Airflow, Prefect, or Dagster, and transformation frameworks such as dbt. - Automated reconciliation for accounting, portfolio, or transactional data; familiarity with financial governance standards such as SOC 2, GDPR, or BCBS 239.

Benefits and work setup

- Full-time role based in New York, with exposure to enterprise data, cloud, and AI initiatives.