Associate Technical Architect – Data

This is a fully remote position, open to applicants in New York.

📋 Description

• Design, develop, and uphold resilient cloud data pipelines and contemporary data lake environments utilizing Snowflake.

• Create and oversee automated, high-volume ingestions and transformations for structured, semi-structured, and unstructured financial datasets.

• Spearhead migration efforts from traditional data repositories to modern data architectures, establishing strong data mapping frameworks, transformation logic, and architectural consistency.

• Execute comprehensive data reconciliation, schema validation, de-duplication, and financial data integrity checks to support critical analytics and regulatory reporting.

• Drive product roadmaps, refine and prioritize technical backlogs, while balancing feature delivery with technical debt and platform reliability.

• Lead projects through all stages, from gathering business requirements and technical design to development, integration testing, user acceptance testing, cutover planning, and go-live execution.

• Decompose high-level strategic objectives into epics, technical user stories, and acceptance criteria in Jira.

• Act as the primary liaison between business users, quant/analytics teams, and engineering leads; proactively identify risks, align timelines, and ensure operational readiness during platform deployments.

⛳️ Requirements

• Over 8 years of practical experience in data engineering, technical product management, or technical architecture.

• In-depth knowledge of the financial services sector, specifically with experience handling sensitive financial data in the alternative investments domain (e.g., Private Equity, Hedge Funds, Private Credit, Real Estate).

• More than 8 years of production-grade Python development experience focusing on large-scale data processing, performance optimization, and automation using libraries such as Pandas, Polars, PySpark, or similar.

• Over 8 years of expertise in advanced SQL writing, including proficiency in complex Window Functions, Common Table Expressions (CTEs), recursive queries, dynamic conditional logic, and database query optimization.

• Proven experience in deploying and optimizing solutions on Snowflake and related cloud ecosystems (AWS, Azure, or GCP).

• Established background managing end-to-end project lifecycles, release management, operational cutover plans, and Jira/Confluence delivery frameworks.

• Experience in designing automated continuous reconciliation frameworks for complex accounting, portfolio, or transactional data.

• Familiarity with modern orchestration tools (e.g., Airflow, Prefect, Dagster) and data transformation frameworks (e.g., dbt).

• Knowledge of navigating regulatory and governance standards (e.g., SOC2, GDPR, BCBS 239) within buy-side or sell-side financial institutions.

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, Finance, or a related quantitative field.

🏝️ Benefits

• Join the fastest-growing AI-first digital transformation and engineering company globally.

• Collaborate with a vibrant team of highly skilled and dynamic professionals.

• Gain exposure to working alongside Fortune 500 companies and innovative market disruptors.

• Work with the latest technologies in artificial intelligence, machine learning, data, and cloud.